APPS.CTO_COST_ROLLUP_CONC_PK dependencies on BOM_CTO_SRC_ORGS_GT

Line 178: from bom_cto_src_orgs_gt

174: x_org_id number ) is
175: */
176: cursor cfg_src_org_cur ( x_config_item number) is
177: select distinct organization_id
178: from bom_cto_src_orgs_gt
179: where config_item_id = x_config_item ;
180: /* commented and rcv_org_id = x_org_id; */ -- bugfix 3777922
181:
182:

Line 193: from bom_cto_src_orgs_gt

189: of the parent config.
190: */
191: cursor cfg_mfg_org_cur ( x_config_item number) is
192: select distinct organization_id
193: from bom_cto_src_orgs_gt
194: where config_item_id = x_config_item
195: and rcv_org_id = organization_id ;
196:
197:

Line 418: delete from bom_cto_src_orgs_gt ;

414: WriteToLog('Processing Config Id : '||l_config_item||' Attrib: '||l_config_orgs);
415: WriteToLog('-------------------------------------------------------------------');
416:
417:
418: delete from bom_cto_src_orgs_gt ;
419:
420:
421: WriteToLog('deleted from bom_cto_src_orgs_gt : '|| sql%rowcount );
422: /*

Line 421: WriteToLog('deleted from bom_cto_src_orgs_gt : '|| sql%rowcount );

417:
418: delete from bom_cto_src_orgs_gt ;
419:
420:
421: WriteToLog('deleted from bom_cto_src_orgs_gt : '|| sql%rowcount );
422: /*
423:
424:
425:

Line 599: insert into bom_cto_src_orgs_gt

595:
596:
597: WriteToLog('get_sourcing_org: Adding dummy record for ship org. ');
598:
599: insert into bom_cto_src_orgs_gt
600: (
601: config_item_id,
602: organization_id,
603: rcv_org_id,

Line 628: from bom_cto_src_orgs_gt

624: sysdate -- program_update_date
625: from dual
626: where NOT EXISTS
627: (select NULL
628: from bom_cto_src_orgs_gt
629: where rcv_org_id = p_org_id
630: and organization_id = p_org_id
631: and config_item_id = l_config_item );
632:

Line 635: -- query the bom_cto_src_orgs_gt table and get all sourcing orgs for parent config.

631: and config_item_id = l_config_item );
632:
633:
634: --
635: -- query the bom_cto_src_orgs_gt table and get all sourcing orgs for parent config.
636: --
637: open cfg_src_org_cur (l_config_item); -- bugfix 3777622
638: LOOP
639: WriteToLog ('inside cfg_src_org_cur loop for parent.');

Line 826: insert into bom_cto_src_orgs_gt

822:
823:
824: WriteToLog('get_sourcing_org: Adding dummy record for ship org. ');
825:
826: insert into bom_cto_src_orgs_gt
827: (
828: config_item_id,
829: organization_id,
830: rcv_org_id,

Line 855: from bom_cto_src_orgs_gt

851: sysdate -- program_update_date
852: from dual
853: where NOT EXISTS
854: (select NULL
855: from bom_cto_src_orgs_gt
856: where rcv_org_id = l_parent_org_id -- bugfix 3777922
857: and organization_id = l_parent_org_id -- bugfix 3777922
858: and config_item_id = l_child_config_item ) ; -- bugfix 3941383
859:

Line 871: -- query the bom_cto_src_orgs_gt table and get all sourcing orgs for child config.

867:
868:
869:
870: --
871: -- query the bom_cto_src_orgs_gt table and get all sourcing orgs for child config.
872: --
873: /* old call open cfg_src_org_cur (l_child_config_item,p_org_id); */
874:
875:

Line 1342: from bom_cto_src_orgs_gt

1338: begin
1339:
1340: select distinct 'Y'
1341: into l_circular_src
1342: from bom_cto_src_orgs_gt
1343: where config_item_id = p_config_item_id
1344: and rcv_org_id = l_curr_src_org;
1345:
1346: exception

Line 1368: insert into bom_cto_src_orgs_gt

1364:
1365: begin
1366:
1367:
1368: insert into bom_cto_src_orgs_gt
1369: (
1370: config_item_id,
1371: organization_id,
1372: rcv_org_id,

Line 1397: from bom_cto_src_orgs_gt

1393: sysdate -- program_update_date
1394: from dual
1395: where NOT EXISTS
1396: (select NULL
1397: from bom_cto_src_orgs_gt
1398: where rcv_org_id = p_organization_id
1399: and organization_id = l_curr_src_org
1400: and config_item_id = p_config_item_id );
1401:

Line 1451: insert into bom_cto_src_orgs_gt

1447:
1448: begin
1449:
1450:
1451: insert into bom_cto_src_orgs_gt
1452: (
1453: config_item_id,
1454: organization_id,
1455: rcv_org_id,

Line 1480: from bom_cto_src_orgs_gt

1476: sysdate -- program_update_date
1477: from dual
1478: where NOT EXISTS
1479: (select NULL
1480: from bom_cto_src_orgs_gt
1481: where rcv_org_id = p_organization_id
1482: and organization_id = l_curr_src_org
1483: and config_item_id = p_config_item_id );
1484:

Line 1580: insert into bom_cto_src_orgs_gt

1576:
1577:
1578: begin
1579:
1580: insert into bom_cto_src_orgs_gt
1581: (
1582: config_item_id,
1583: rcv_org_id,
1584: organization_id,

Line 1608: from bom_cto_src_orgs_gt

1604: sysdate -- program_update_date
1605: from dual
1606: where NOT EXISTS
1607: (select NULL
1608: from bom_cto_src_orgs_gt
1609: where rcv_org_id = p_organization_id
1610: and organization_id =p_organization_id
1611: and config_item_id = p_config_item_id );
1612: