APPS.OPI_DBI_PTP_BASELINE_PKG dependencies on OPI_DBI_PTP_CONV

Line 108: from opi_dbi_ptp_conv

104: and org.plan_id = plan.plan_id
105: ) org1,
106: (select distinct organization_id,
107: 1 existing_flag
108: from opi_dbi_ptp_conv
109: ) org2
110: where org1.organization_id = org2.organization_id (+)
111: ;
112:

Line 289: insert into OPI_DBI_PTP_CONV

285: (l_secondary_rate IS NULL AND
286: g_secondary_currency_code IS NULL) ) ) THEN
287: l_stmt_num := 60;
288: l_stmt := '
289: insert into OPI_DBI_PTP_CONV
290: (
291: FROZEN_FLAG,
292: ORGANIZATION_ID,
293: CONVERSION_RATE,

Line 325: insert into OPI_DBI_PTP_CONV

321: ;
322: EXECUTE IMMEDIATE l_stmt USING l_org_list(i), 0, 0, l_currency_code, g_global_start_date, l_from_dates(i), 1, g_sysdate, g_last_updated_by, g_sysdate, g_last_updated_by, g_last_update_login;
323:
324: l_stmt := '
325: insert into OPI_DBI_PTP_CONV
326: (
327: FROZEN_FLAG,
328: ORGANIZATION_ID,
329: CONVERSION_RATE,

Line 502: update OPI_DBI_PTP_CONV

498: --get conversion rate for existing organizations
499: BIS_COLLECTION_UTILITIES.put_line('Collect conversion rate for existing organizations.');
500: l_stmt_num := 100;
501: l_stmt := '
502: update OPI_DBI_PTP_CONV
503: set frozen_flag = null,
504: to_date = :g_sysdate,
505: last_update_date = :g_sysdate,
506: last_updated_by = :g_last_updated_by,

Line 565: merge into OPI_DBI_PTP_CONV conv

561: (l_secondary_rate IS NULL AND
562: g_secondary_currency_code IS NULL) ) ) THEN
563:
564: l_stmt := '
565: merge into OPI_DBI_PTP_CONV conv
566: using
567: (
568: select
569: :l_org_id organization_id,

Line 647: update OPI_DBI_PTP_CONV

643: END IF;
644: END LOOP;
645:
646: l_stmt_num := 140;
647: update OPI_DBI_PTP_CONV
648: set source = 1
649: where source = -1
650: ;
651: END IF;

Line 712: from opi_dbi_ptp_conv

708: and org.plan_id = plan.plan_id
709: ) org1,
710: (select distinct organization_id,
711: 1 existing_flag
712: from opi_dbi_ptp_conv
713: ) org2,
714: mtl_parameters mp
715: where org1.organization_id = org2.organization_id (+)
716: and org1.organization_id = mp.organization_id

Line 1783: update OPI_DBI_PTP_CONV conv

1779: )
1780: and cost.from_date = l_baseline_record.data_start_date
1781: ;
1782:
1783: update OPI_DBI_PTP_CONV conv
1784: set to_date = l_baseline_record.from_date
1785: where conv.organization_id in
1786: (select orgs.organization_id
1787: from OPI_DBI_BASELINE_PLANS setup,

Line 1798: update OPI_DBI_PTP_CONV conv

1794: )
1795: and conv.to_date = l_baseline_record.data_start_date
1796: ;
1797:
1798: update OPI_DBI_PTP_CONV conv
1799: set from_date = l_baseline_record.from_date
1800: where conv.organization_id in
1801: (select orgs.organization_id
1802: from OPI_DBI_BASELINE_PLANS setup,