DBA Data[Home] [Help]

APPS.GML_PO_CON_REQ dependencies on STANDARD

Line 15: # Purchase Orders (Standard and Planned), Releases from Oralce to GEMMS

11: #
12: # DESCRIPTION
13: #
14: # This Procedure fires the Concurrent Request to Synchronize the
15: # Purchase Orders (Standard and Planned), Releases from Oralce to GEMMS
16: # and Receipts from GEMMS to Oracle.
17: #
18: # This Executable Fired with the FND_SUBMIT_REQUEST is a SQL File which
19: # opens the Common Purchasing Log File in the directory named in the

Line 20: # init.ora and displays the log file in the Standard Concurent Manager

16: # and Receipts from GEMMS to Oracle.
17: #
18: # This Executable Fired with the FND_SUBMIT_REQUEST is a SQL File which
19: # opens the Common Purchasing Log File in the directory named in the
20: # init.ora and displays the log file in the Standard Concurent Manager
21: # request log.
22: #
23: # MODIFICATION HISTORY
24: #

Line 159: IF v_transaction_type IN('STANDARD') THEN

155: Err_Msg VARCHAR2(1000);
156:
157: BEGIN
158:
159: IF v_transaction_type IN('STANDARD') THEN
160:
161: FOR shipping_details_rec IN shipping_details(v_po_header_id)
162: LOOP
163: Gml_Po_Interface.insert_rec( shipping_details_rec.po_header_id,

Line 229: | For standard PO whole PO will be synched again. |

225: | required. Retrieve po_header_id AND COMMENT |
226: | OUT converting from_date AND TO_DATE TO_DATE IN |
227: | second LOOP. |
228: | 15-NOV-2001 Bug#2048971 Uday Phadtare Entire procedure was rewritten |
229: | For standard PO whole PO will be synched again. |
230: | For Planned PO only failed releases will be synched. |
231: | For Blanket PO only failed releases will be synched. |
232: | PPO template does not get synched through po_resub. It has |
233: | to be exclusively synched through PO form. |

Line 375: IF get_trans_type_rec.type_lookup_code = 'STANDARD' THEN

371: OPEN get_trans_type(v_po_no);
372: FETCH get_trans_type INTO get_trans_type_rec;
373: CLOSE get_trans_type;
374:
375: IF get_trans_type_rec.type_lookup_code = 'STANDARD' THEN
376:
377: OPEN get_synch_failed_rows_PO(get_trans_type_rec.po_header_id);
378: FETCH get_synch_failed_rows_PO INTO get_synch_failed_rows_PO_rec;
379: CLOSE get_synch_failed_rows_PO;