- Mar 24 Wed 2010 14:34
{GL} Account Segment Security Setup
- Mar 15 Mon 2010 11:24
{Form} How to create Select all checkbox
How to create Select all “checkbox”
<Sample>
go_block('RECEIPT_MATCH');
first_recor;
LOOP
:RECEIPT_MATCH.SELECTION_CHECKBOX:='Y';--OR THE VALUE YOU WANT TO PASS
EXIT WHEN :SYSTEM.LAST_RECORD='TRUE';
NEXT_RECORD;
END LOOP;
FIRST_RECORD;
- Feb 23 Tue 2010 15:27
ERP PL/SQL Concurrent Program
If we need write Oracle PL/SQL Program for concurrent program using.
We need create procedure (ex. xx_procedure)
This xx_procedure need has base two parameter.(errbuf out varchar2,retcode out number).
- Errbuf : Errbuf is one the paramter which will define in pl/sql to store procedure to get error messges into log file.
- Retcode: this parameter will be used to get the status of the concurrent program. It will give the values
- 0 for sucess
- 1 for warning
- 2 for errors
- Jan 25 Mon 2010 12:34
{Issue} Can’t update Initial Pick-Up Date at Delivery Detail
- Jan 12 Tue 2010 18:57
{API} Move Order Backorder
This job is doing backorder all open move order .(ps. it’s not work for WMS move order)
Below is what I do.
For you all reference.