DBA Data[Home] [Help]

APPS.PO_SOURCING_RULES_SV dependencies on MRP_SR_SOURCE_ORG_S

Line 535: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL

531: PO_DEBUG.put_line(' Inserting Record in Mrp Sr Source Org');
532: END IF;
533:
534: X_progress := '050';
535: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL
536: INTO x_sr_source_id
537: FROM SYS.DUAL;
538:
539:

Line 1191: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL

1187: );
1188:
1189: -- update existing links to sourcing rule
1190:
1191: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL
1192: INTO x_sr_source_id
1193: FROM SYS.DUAL;
1194:
1195: SELECT nvl(max(rank),0) +1

Line 1295: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL

1291: );
1292:
1293: -- update existing links to sourcing rule
1294:
1295: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL
1296: INTO x_sr_source_id
1297: FROM SYS.DUAL;
1298:
1299: SELECT nvl(max(rank),0) +1

Line 1379: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL

1375:
1376: X_progress := '100';
1377: -- update existing links to sourcing rule
1378:
1379: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL
1380: INTO x_sr_source_id
1381: FROM SYS.DUAL;
1382:
1383: -- #13961772 POASLGEN IS NOT PROPERLY UPDATING SOURCING RULES