APPS.OPI_DBI_PTP_BASELINE_PKG dependencies on OPI_DBI_PTP_COST

Line 141: l_stmt := ' insert into OPI_DBI_PTP_COST

137: -- row 2: from_date = baseline from_date, to_date = null, cost = item cost from cst_item_costs
138: IF l_new_orgs IS NOT NULL THEN
139: BIS_COLLECTION_UTILITIES.put_line('Collect item cost for new organizations.');
140: l_stmt_num := 30;
141: l_stmt := ' insert into OPI_DBI_PTP_COST
142: (
143: FROZEN_FLAG,
144: ORGANIZATION_ID,
145: INVENTORY_ITEM_ID,

Line 391: update OPI_DBI_PTP_COST

387: IF l_existing_orgs IS NOT NULL THEN
388: BIS_COLLECTION_UTILITIES.put_line('Collect item cost for existing organizations.');
389: l_stmt_num := 70;
390: l_stmt := '
391: update OPI_DBI_PTP_COST
392: set frozen_flag = null,
393: to_date = :g_sysdate,
394: last_update_date = :g_sysdate,
395: last_updated_by = :g_last_updated_by,

Line 406: merge into OPI_DBI_PTP_COST cost

402:
403: EXECUTE IMMEDIATE l_stmt USING g_sysdate, g_sysdate, g_last_updated_by, g_last_update_login;
404: l_stmt_num := 80;
405: l_stmt :='
406: merge into OPI_DBI_PTP_COST cost
407: using
408: (
409: select /*+ use_hash(cic) parallel(io) parallel(cic) */
410: :l_frozen_flag frozen_flag,

Line 480: update OPI_DBI_PTP_COST

476: EXECUTE IMMEDIATE l_stmt USING -1, g_sysdate, 1, g_sysdate, g_last_updated_by, g_sysdate, g_last_updated_by, g_last_update_login;
477:
478: --shift date back to global_start_date for new items
479: l_stmt :='
480: update OPI_DBI_PTP_COST
481: set from_date = :g_global_start_date
482: where (organization_id, inventory_item_id) in
483: (select organization_id, inventory_item_id from OPI_DBI_PTP_COST
484: where source = 1 and frozen_flag = -1 and creation_date = :g_sysdate

Line 483: (select organization_id, inventory_item_id from OPI_DBI_PTP_COST

479: l_stmt :='
480: update OPI_DBI_PTP_COST
481: set from_date = :g_global_start_date
482: where (organization_id, inventory_item_id) in
483: (select organization_id, inventory_item_id from OPI_DBI_PTP_COST
484: where source = 1 and frozen_flag = -1 and creation_date = :g_sysdate
485: minus
486: select organization_id, inventory_item_id from OPI_DBI_PTP_COST
487: where source = -1

Line 486: select organization_id, inventory_item_id from OPI_DBI_PTP_COST

482: where (organization_id, inventory_item_id) in
483: (select organization_id, inventory_item_id from OPI_DBI_PTP_COST
484: where source = 1 and frozen_flag = -1 and creation_date = :g_sysdate
485: minus
486: select organization_id, inventory_item_id from OPI_DBI_PTP_COST
487: where source = -1
488: )
489: ';
490: EXECUTE IMMEDIATE l_stmt USING g_global_start_date, g_sysdate;

Line 493: update opi_dbi_ptp_cost

489: ';
490: EXECUTE IMMEDIATE l_stmt USING g_global_start_date, g_sysdate;
491:
492: l_stmt_num := 90;
493: update opi_dbi_ptp_cost
494: set source = 1
495: where source = -1
496: ;
497:

Line 802: l_stmt := ' insert into OPI_DBI_PTP_COST

798:
799:
800: IF l_new_orgs IS NOT NULL THEN
801:
802: l_stmt := ' insert into OPI_DBI_PTP_COST
803: (
804: FROZEN_FLAG,
805: ORGANIZATION_ID,
806: INVENTORY_ITEM_ID,

Line 904: update OPI_DBI_PTP_COST

900: IF l_existing_orgs IS NOT NULL THEN
901: BIS_COLLECTION_UTILITIES.put_line('Collect item cost for existing organizations.');
902: l_stmt_num := 70;
903: l_stmt := '
904: update OPI_DBI_PTP_COST
905: set frozen_flag = null,
906: to_date = :g_sysdate,
907: last_update_date = :g_sysdate,
908: last_updated_by = :g_last_updated_by,

Line 920: merge into OPI_DBI_PTP_COST cost

916: EXECUTE IMMEDIATE l_stmt USING g_sysdate, g_sysdate, g_last_updated_by, g_last_update_login;
917:
918: l_stmt_num := 80;
919: l_stmt :='
920: merge into OPI_DBI_PTP_COST cost
921: using
922: (
923: select
924: :l_frozen_flag frozen_flag,

Line 991: update OPI_DBI_PTP_COST

987: BIS_COLLECTION_UTILITIES.put_line(TO_CHAR(SQL%ROWCOUNT) || ' Process Org costs merged into costing fact.');
988:
989: --shift date back to global_start_date for new items
990: l_stmt :='
991: update OPI_DBI_PTP_COST
992: set from_date = :g_global_start_date
993: where (organization_id, inventory_item_id) in
994: (select organization_id, inventory_item_id from OPI_DBI_PTP_COST
995: where source = 2 and frozen_flag = -1 and creation_date = :g_sysdate

Line 994: (select organization_id, inventory_item_id from OPI_DBI_PTP_COST

990: l_stmt :='
991: update OPI_DBI_PTP_COST
992: set from_date = :g_global_start_date
993: where (organization_id, inventory_item_id) in
994: (select organization_id, inventory_item_id from OPI_DBI_PTP_COST
995: where source = 2 and frozen_flag = -1 and creation_date = :g_sysdate
996: minus
997: select organization_id, inventory_item_id from OPI_DBI_PTP_COST
998: where source = -2

Line 997: select organization_id, inventory_item_id from OPI_DBI_PTP_COST

993: where (organization_id, inventory_item_id) in
994: (select organization_id, inventory_item_id from OPI_DBI_PTP_COST
995: where source = 2 and frozen_flag = -1 and creation_date = :g_sysdate
996: minus
997: select organization_id, inventory_item_id from OPI_DBI_PTP_COST
998: where source = -2
999: )
1000: ';
1001:

Line 1005: update opi_dbi_ptp_cost

1001:
1002: EXECUTE IMMEDIATE l_stmt USING g_global_start_date, g_sysdate;
1003:
1004: l_stmt_num := 90;
1005: update opi_dbi_ptp_cost
1006: set source = 2
1007: where source = -2
1008: ;
1009:

Line 1753: update OPI_DBI_PTP_COST cost

1749:
1750: FOR l_baseline_record IN l_baseline_info LOOP
1751: IF (l_baseline_record.data_start_date IS NOT NULL) and (l_baseline_record.data_start_date > l_baseline_record.from_date) THEN
1752: l_segment_num := 190;
1753: update OPI_DBI_PTP_COST cost
1754: set to_date = l_baseline_record.from_date
1755: where cost.organization_id in
1756: (select orgs.organization_id
1757: from OPI_DBI_BASELINE_PLANS setup,

Line 1768: update OPI_DBI_PTP_COST cost

1764: )
1765: and cost.to_date = l_baseline_record.data_start_date
1766: ;
1767:
1768: update OPI_DBI_PTP_COST cost
1769: set from_date = l_baseline_record.from_date
1770: where cost.organization_id in
1771: (select orgs.organization_id
1772: from OPI_DBI_BASELINE_PLANS setup,