DBA Data[Home] [Help]

APPS.PO_SOURCING_RULES_SV dependencies on MRP_SR_SOURCE_ORG_S

Line 527: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL

523: PO_DEBUG.put_line(' Inserting Record in Mrp Sr Source Org');
524: END IF;
525:
526: X_progress := '050';
527: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL
528: INTO x_sr_source_id
529: FROM SYS.DUAL;
530:
531:

Line 1129: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL

1125: );
1126:
1127: -- update existing links to sourcing rule
1128:
1129: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL
1130: INTO x_sr_source_id
1131: FROM SYS.DUAL;
1132:
1133: SELECT nvl(max(rank),0) +1

Line 1233: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL

1229: );
1230:
1231: -- update existing links to sourcing rule
1232:
1233: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL
1234: INTO x_sr_source_id
1235: FROM SYS.DUAL;
1236:
1237: SELECT nvl(max(rank),0) +1

Line 1317: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL

1313:
1314: X_progress := '100';
1315: -- update existing links to sourcing rule
1316:
1317: SELECT MRP_SR_SOURCE_ORG_S.NEXTVAL
1318: INTO x_sr_source_id
1319: FROM SYS.DUAL;
1320:
1321: SELECT nvl(max(rank),0) +1