eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_ASL_API_GRP dependencies on PO_ASL_API_PUB

Line 91: WHERE GT.process_action = PO_ASL_API_PUB.g_ACTION_SYNC;

87: p_using_organization_id => GT.using_organization_id,
88: p_vendor_id => GT.vendor_id ,
89: p_vendor_site_id => GT.vendor_site_id
90: )
91: WHERE GT.process_action = PO_ASL_API_PUB.g_ACTION_SYNC;
92: l_progress := 5;
93: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);
94:
95: --Populate asl ids in case of update

Line 108: WHERE GT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE;

104: AND (GT.vendor_id = PASL.vendor_id
105: OR GT.manufacturer_id = PASL.manufacturer_id)
106: AND Nvl(GT.vendor_site_id,-1)= Nvl(PASL.vendor_site_id,-1)
107: AND ROWNUM < 2)
108: WHERE GT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE;
109: l_progress := 10;
110: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);
111:
112: --Populate asl ids in case of create

Line 115: WHERE GT.process_action = PO_ASL_API_PUB.g_ACTION_CREATE;

111:
112: --Populate asl ids in case of create
113: UPDATE po_approved_supplier_list_gt GT
114: SET asl_id = po_approved_supplier_list_s.NEXTVAL
115: WHERE GT.process_action = PO_ASL_API_PUB.g_ACTION_CREATE;
116:
117: l_progress := 15;
118: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);
119:

Line 169: WHERE process_action = PO_ASL_API_PUB.g_ACTION_ADD;

165: /*--Populate capacity id in case of update and
166: --Capacity's process action is ADD
167: UPDATE po_supplier_item_capacity_gt PSIC
168: SET capacity_id = po_supplier_item_capacity_s.NEXTVAL
169: WHERE process_action = PO_ASL_API_PUB.g_ACTION_ADD;
170: l_progress := 42;
171: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);*/
172:
173: --Reject records if asl exist when mode is Create

Line 191: AND GT.process_action = PO_ASL_API_PUB.g_ACTION_CREATE;

187: AND GT.using_organization_id = PASL.using_organization_id
188: AND (GT.vendor_id = PASL.vendor_id
189: OR GT.manufacturer_id = PASL.manufacturer_id)
190: AND Nvl(GT.vendor_site_id,-1) = Nvl(PASL.vendor_site_id,-1))
191: AND GT.process_action = PO_ASL_API_PUB.g_ACTION_CREATE;
192:
193: l_progress := 45;
194: l_user_key_tbl1 := l_user_key_tbl;
195: l_entity_name1 := l_entity_name;

Line 215: AND GT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE;

211: AND GT.using_organization_id = PASL.using_organization_id
212: AND (GT.vendor_id = PASL.vendor_id
213: OR GT.manufacturer_id = PASL.manufacturer_id)
214: AND Nvl(GT.vendor_site_id,-1) = Nvl(PASL.vendor_site_id,-1))
215: AND GT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE;
216:
217: l_progress := 50;
218: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;
219: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;

Line 239: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

235: FROM po_asl_attributes PAA
236: WHERE PAAGT.asl_id = PAA.asl_id
237: AND PAAGT.using_organization_id = PAA.using_organization_id)
238: AND ASLGT.user_key = PAAGT.user_key
239: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
240: AND PAAGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;
241:
242: l_progress := 55;
243: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;

Line 240: AND PAAGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;

236: WHERE PAAGT.asl_id = PAA.asl_id
237: AND PAAGT.using_organization_id = PAA.using_organization_id)
238: AND ASLGT.user_key = PAAGT.user_key
239: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
240: AND PAAGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;
241:
242: l_progress := 55;
243: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;
244: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;

Line 264: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_CREATE

260: FROM po_asl_attributes_gt PAA
261: WHERE PAAGT.asl_id = PAA.asl_id
262: AND PAAGT.using_organization_id = PAA.using_organization_id)
263: AND ASLGT.user_key = PAAGT.user_key
264: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
265: AND PAAGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;
266:
267: l_progress := 57;
268: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;

Line 265: AND PAAGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;

261: WHERE PAAGT.asl_id = PAA.asl_id
262: AND PAAGT.using_organization_id = PAA.using_organization_id)
263: AND ASLGT.user_key = PAAGT.user_key
264: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
265: AND PAAGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;
266:
267: l_progress := 57;
268: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;
269: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;

Line 289: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

285: FROM po_asl_attributes PAA
286: WHERE PAAGT.asl_id = PAA.asl_id
287: AND PAAGT.using_organization_id = PAA.using_organization_id)
288: AND ASLGT.user_key = PAAGT.user_key
289: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
290: AND PAAGT.process_action IN
291: (PO_ASL_API_PUB.g_ACTION_DELETE, PO_ASL_API_PUB.g_ACTION_UPDATE);
292:
293: l_progress := 60;

Line 291: (PO_ASL_API_PUB.g_ACTION_DELETE, PO_ASL_API_PUB.g_ACTION_UPDATE);

287: AND PAAGT.using_organization_id = PAA.using_organization_id)
288: AND ASLGT.user_key = PAAGT.user_key
289: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
290: AND PAAGT.process_action IN
291: (PO_ASL_API_PUB.g_ACTION_DELETE, PO_ASL_API_PUB.g_ACTION_UPDATE);
292:
293: l_progress := 60;
294: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;
295: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;

Line 315: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

311: WHERE DOCGT.document_header_id = PAD.document_header_id
312: AND DOCGT.asl_id = PAD.asl_id
313: AND DOCGT.using_organization_id = PAD.using_organization_id)
314: AND ASLGT.user_key = DOCGT.user_key
315: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
316: AND DOCGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;
317:
318: l_progress := 62;
319: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;

Line 316: AND DOCGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;

312: AND DOCGT.asl_id = PAD.asl_id
313: AND DOCGT.using_organization_id = PAD.using_organization_id)
314: AND ASLGT.user_key = DOCGT.user_key
315: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
316: AND DOCGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;
317:
318: l_progress := 62;
319: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;
320: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;

Line 340: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

336: WHERE DOCGT.document_header_id = PAD.document_header_id
337: AND DOCGT.asl_id = PAD.asl_id
338: AND DOCGT.using_organization_id = PAD.using_organization_id)
339: AND ASLGT.user_key = DOCGT.user_key
340: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
341: AND DOCGT.process_action IN
342: (PO_ASL_API_PUB.g_ACTION_DELETE, PO_ASL_API_PUB.g_ACTION_UPDATE);
343:
344: l_progress := 65;

Line 342: (PO_ASL_API_PUB.g_ACTION_DELETE, PO_ASL_API_PUB.g_ACTION_UPDATE);

338: AND DOCGT.using_organization_id = PAD.using_organization_id)
339: AND ASLGT.user_key = DOCGT.user_key
340: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
341: AND DOCGT.process_action IN
342: (PO_ASL_API_PUB.g_ACTION_DELETE, PO_ASL_API_PUB.g_ACTION_UPDATE);
343:
344: l_progress := 65;
345: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;
346: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;

Line 366: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_CREATE

362: WHERE DOCGT.document_header_id = PAD.document_header_id
363: AND DOCGT.asl_id = PAD.asl_id
364: AND DOCGT.using_organization_id = PAD.using_organization_id)
365: AND ASLGT.user_key = DOCGT.user_key
366: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
367: AND DOCGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;
368:
369: l_progress := 70;
370: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;

Line 367: AND DOCGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;

363: AND DOCGT.asl_id = PAD.asl_id
364: AND DOCGT.using_organization_id = PAD.using_organization_id)
365: AND ASLGT.user_key = DOCGT.user_key
366: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
367: AND DOCGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;
368:
369: l_progress := 70;
370: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;
371: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;

Line 394: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

390: OR
391: CHVGT.authorization_sequence_dsp=CHV.authorization_sequence)
392: )
393: AND CHVGT.user_key = ASLGT.user_key
394: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
395: AND CHVGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;
396:
397: l_progress := 72;
398: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;

Line 395: AND CHVGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;

391: CHVGT.authorization_sequence_dsp=CHV.authorization_sequence)
392: )
393: AND CHVGT.user_key = ASLGT.user_key
394: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
395: AND CHVGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;
396:
397: l_progress := 72;
398: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;
399: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;

Line 421: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

417: AND CHVGT.authorization_code = CHV.authorization_code
418: AND CHVGT.authorization_sequence_dsp=CHV.authorization_sequence
419: )
420: AND CHVGT.user_key = ASLGT.user_key
421: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
422: AND CHVGT.process_action IN
423: (PO_ASL_API_PUB.g_ACTION_DELETE, PO_ASL_API_PUB.g_ACTION_UPDATE);
424:
425: l_progress := 75;

Line 423: (PO_ASL_API_PUB.g_ACTION_DELETE, PO_ASL_API_PUB.g_ACTION_UPDATE);

419: )
420: AND CHVGT.user_key = ASLGT.user_key
421: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
422: AND CHVGT.process_action IN
423: (PO_ASL_API_PUB.g_ACTION_DELETE, PO_ASL_API_PUB.g_ACTION_UPDATE);
424:
425: l_progress := 75;
426: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;
427: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;

Line 450: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_CREATE

446: OR CHVGT.authorization_sequence_dsp =
447: CHV.authorization_sequence_dsp)
448: )
449: AND CHVGT.user_key = ASLGT.user_key
450: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
451: AND CHVGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;
452:
453: --*************************************************************************
454: --Duplicate check is not required for po_supplier_item_capacity_gt

Line 451: AND CHVGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;

447: CHV.authorization_sequence_dsp)
448: )
449: AND CHVGT.user_key = ASLGT.user_key
450: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
451: AND CHVGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;
452:
453: --*************************************************************************
454: --Duplicate check is not required for po_supplier_item_capacity_gt
455: --as there is a check in the validation for dates overlapping. That check

Line 485: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

481: AND CAPGT.from_date_dsp = CAP.from_date
482: AND CAPGT.capacity_per_day_dsp = CAP.capacity_per_day
483: )
484: AND CAPGT.user_key = ASLGT.user_key
485: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
486: AND CAPGT.process_action IN
487: (PO_ASL_API_PUB.g_ACTION_DELETE, PO_ASL_API_PUB.g_ACTION_UPDATE);
488:
489: l_progress := 80;

Line 487: (PO_ASL_API_PUB.g_ACTION_DELETE, PO_ASL_API_PUB.g_ACTION_UPDATE);

483: )
484: AND CAPGT.user_key = ASLGT.user_key
485: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
486: AND CAPGT.process_action IN
487: (PO_ASL_API_PUB.g_ACTION_DELETE, PO_ASL_API_PUB.g_ACTION_UPDATE);
488:
489: l_progress := 80;
490: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;
491: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;

Line 512: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

508: AND TOLGT.using_organization_id = TOL.using_organization_id
509: AND TOLGT.number_of_days_dsp = TOL.number_of_days
510: )
511: AND TOLGT.user_key = ASLGT.user_key
512: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
513: AND TOLGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;
514:
515: l_progress := 82;
516: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;

Line 513: AND TOLGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;

509: AND TOLGT.number_of_days_dsp = TOL.number_of_days
510: )
511: AND TOLGT.user_key = ASLGT.user_key
512: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
513: AND TOLGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;
514:
515: l_progress := 82;
516: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;
517: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;

Line 538: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

534: AND TOLGT.using_organization_id = TOL.using_organization_id
535: AND TOLGT.number_of_days_dsp = TOL.number_of_days
536: )
537: AND TOLGT.user_key = ASLGT.user_key
538: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
539: AND TOLGT.process_action IN
540: (PO_ASL_API_PUB.g_ACTION_DELETE, PO_ASL_API_PUB.g_ACTION_UPDATE);
541:
542: l_progress := 85;

Line 540: (PO_ASL_API_PUB.g_ACTION_DELETE, PO_ASL_API_PUB.g_ACTION_UPDATE);

536: )
537: AND TOLGT.user_key = ASLGT.user_key
538: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
539: AND TOLGT.process_action IN
540: (PO_ASL_API_PUB.g_ACTION_DELETE, PO_ASL_API_PUB.g_ACTION_UPDATE);
541:
542: l_progress := 85;
543: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;
544: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;

Line 565: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_CREATE

561: AND TOLGT.using_organization_id = TOL.using_organization_id
562: AND TOLGT.number_of_days_dsp = TOL.number_of_days_dsp
563: )
564: AND TOLGT.user_key = ASLGT.user_key
565: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
566: AND TOLGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;
567:
568: l_progress := 90;
569: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;

Line 566: AND TOLGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;

562: AND TOLGT.number_of_days_dsp = TOL.number_of_days_dsp
563: )
564: AND TOLGT.user_key = ASLGT.user_key
565: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
566: AND TOLGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;
567:
568: l_progress := 90;
569: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;
570: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;

Line 620: --call the po_asl_api_pub.process for the next steps.

616: x_return_status => x_return_status,
617: x_return_msg => x_return_msg
618: );
619: l_progress := 99;
620: --call the po_asl_api_pub.process for the next steps.
621: po_asl_api_pvt.process(
622: p_session_key => p_session_key,
623: x_return_status => x_return_status,
624: x_return_msg => x_return_msg

Line 765: WHERE ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

761: SELECT user_key ,
762: 'po_approved_supplier_list_gt' AS entity ,
763: fnd_message.get_string('PO','BUSINESS_TYPE_NOT_EDITABLE') AS msg
764: FROM po_approved_supplier_list_gt ASLGT
765: WHERE ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
766: AND
767: EXISTS (SELECT asl_id
768: FROM po_approved_supplier_list ASL
769: WHERE ASL.asl_id = ASLGT.asl_id

Line 1023: AND PSIC.process_action = PO_ASL_API_PUB.g_ACTION_ADD)

1019: FROM po_supplier_item_capacity_gt PSIC
1020: WHERE PSIC.asl_id = PAAGT.asl_id
1021: AND PSIC.using_organization_id= PAAGT.using_organization_id
1022: AND PSIC.user_key = PAAGT.user_key
1023: AND PSIC.process_action = PO_ASL_API_PUB.g_ACTION_ADD)
1024:
1025: );
1026:
1027: l_progress := 20;

Line 1110: AND CHV.process_action = PO_ASL_API_PUB.g_ACTION_ADD)

1106: FROM chv_authorizations_gt CHV
1107: WHERE CHV.reference_id = PAAGT.asl_id
1108: AND CHV.using_organization_id = PAAGT.using_organization_id
1109: AND CHV.user_key = PAAGT.user_key
1110: AND CHV.process_action = PO_ASL_API_PUB.g_ACTION_ADD)
1111: AND PAAGT.process_action <> PO_ASL_API_PUB.g_ACTION_DELETE
1112: UNION ALL
1113: --Reject records if there is an entry in po_supplier_item_tolerance_gt
1114: -- when global_flag is N and VMI flag is not checked

Line 1111: AND PAAGT.process_action <> PO_ASL_API_PUB.g_ACTION_DELETE

1107: WHERE CHV.reference_id = PAAGT.asl_id
1108: AND CHV.using_organization_id = PAAGT.using_organization_id
1109: AND CHV.user_key = PAAGT.user_key
1110: AND CHV.process_action = PO_ASL_API_PUB.g_ACTION_ADD)
1111: AND PAAGT.process_action <> PO_ASL_API_PUB.g_ACTION_DELETE
1112: UNION ALL
1113: --Reject records if there is an entry in po_supplier_item_tolerance_gt
1114: -- when global_flag is N and VMI flag is not checked
1115: SELECT PAAGT.user_key ,

Line 1129: AND PSIT.process_action = PO_ASL_API_PUB.g_ACTION_ADD)

1125: FROM po_supplier_item_tolerance_gt PSIT
1126: WHERE PSIT.asl_id = PAAGT.asl_id
1127: AND PSIT.using_organization_id= PAAGT.using_organization_id
1128: AND PSIT.user_key = PAAGT.user_key
1129: AND PSIT.process_action = PO_ASL_API_PUB.g_ACTION_ADD)
1130:
1131: UNION ALL
1132: --Reject records if Price Update tolerance is -ve number
1133: SELECT user_key ,

Line 1461: AND PAAGT.process_action <> PO_ASL_API_PUB.g_ACTION_DELETE

1457: 'po_asl_attributes_gt' AS entity ,
1458: fnd_message.get_string('PO','SUPPLIER_SCHEDULING_DISABLED') AS msg
1459: FROM po_asl_attributes_gt PAAGT
1460: WHERE PAAGT.vendor_site_id IS NULL
1461: AND PAAGT.process_action <> PO_ASL_API_PUB.g_ACTION_DELETE
1462: AND (PAAGT.enable_plan_schedule_flag_dsp = 'Y'
1463: OR PAAGT.enable_ship_schedule_flag_dsp = 'Y'
1464: OR PAAGT.enable_autoschedule_flag_dsp = 'Y'
1465: OR PAAGT.scheduler_id IS NOT NULL

Line 1580: AND DOCGT.process_action <> PO_ASL_API_PUB.g_ACTION_DELETE

1576: fnd_message.get_string('PO','LINE_NUM_MANDATORY') AS msg
1577: FROM po_asl_documents_gt DOCGT
1578: WHERE DOCGT.document_type_code <> 'CONTRACT'
1579: AND DOCGT.document_line_id IS NULL
1580: AND DOCGT.process_action <> PO_ASL_API_PUB.g_ACTION_DELETE
1581: );
1582:
1583: l_progress := 50;
1584: --call po_asl_api_pvt.reject_asl_record for above rejected records

Line 1749: AND PSICGT.process_action <> PO_ASL_API_PUB.g_ACTION_DELETE

1745: fnd_message.get_string('PO','INVALID_FROM_DATE') AS msg
1746: FROM po_supplier_item_capacity_gt PSICGT
1747: WHERE (PSICGT.from_date_dsp IS NULL
1748: OR PSICGT.from_date_dsp < SYSDATE)
1749: AND PSICGT.process_action <> PO_ASL_API_PUB.g_ACTION_DELETE
1750:
1751: UNION ALL
1752: --Reject records if to_date is less than current date or from_date
1753: SELECT user_key ,

Line 1792: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_CREATE

1788: BETWEEN PSIC.from_date_dsp AND PSIC.to_date_dsp)
1789: AND PSICGT.user_key = PSIC.user_key
1790: AND PSICGT.using_organization_id = PSIC.using_organization_id)
1791: AND PSICGT.user_key = ASLGT.user_key
1792: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
1793: AND PSICGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;
1794:
1795: l_progress := 40;
1796: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;

Line 1793: AND PSICGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;

1789: AND PSICGT.user_key = PSIC.user_key
1790: AND PSICGT.using_organization_id = PSIC.using_organization_id)
1791: AND PSICGT.user_key = ASLGT.user_key
1792: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
1793: AND PSICGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;
1794:
1795: l_progress := 40;
1796: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;
1797: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;

Line 1819: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

1815: BETWEEN PSIC.from_date AND PSIC.To_Date)
1816: AND PSICGT.asl_id =PSIC.asl_id
1817: AND PSICGT.using_organization_id=PSIC.using_organization_id)
1818: AND PSICGT.user_key = ASLGT.user_key
1819: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1820: AND PSICGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;
1821:
1822: l_progress := 60;
1823: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;

Line 1820: AND PSICGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;

1816: AND PSICGT.asl_id =PSIC.asl_id
1817: AND PSICGT.using_organization_id=PSIC.using_organization_id)
1818: AND PSICGT.user_key = ASLGT.user_key
1819: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1820: AND PSICGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;
1821:
1822: l_progress := 60;
1823: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;
1824: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;

Line 1991: l_process_action := PO_ASL_API_PUB.g_ACTION_CREATE;

1987: po_asl_api_pvt.log('p_using_organization_id' || p_using_organization_id);
1988: po_asl_api_pvt.log('p_vendor_id' || p_vendor_id);
1989: po_asl_api_pvt.log('p_vendor_site_id' || p_vendor_site_id);
1990: l_found := 0;
1991: l_process_action := PO_ASL_API_PUB.g_ACTION_CREATE;
1992:
1993: SELECT 1 INTO l_found
1994: FROM dual
1995: WHERE EXISTS

Line 2006: l_process_action := PO_ASL_API_PUB.g_ACTION_UPDATE;

2002: AND Nvl(PASL.vendor_site_id,-1) = Nvl(p_vendor_site_id,-1));
2003:
2004: IF l_found = 1
2005: THEN
2006: l_process_action := PO_ASL_API_PUB.g_ACTION_UPDATE;
2007: END IF;
2008:
2009: po_asl_api_pvt.log('process_action:' || l_process_action);
2010: po_asl_api_pvt.log('END ::: determine_action');