APPS.ENI_DBI_PCO_LOAD_PKG dependencies on ENI_DBI_PART_COUNT_ORG_TEMP

Line 76: (select * from eni_dbi_part_count_org_temp))

72: bbom.bill_sequence_id = bbom.common_bill_sequence_id and
73: exists (select 1 from bom_structures_b bbom_common
74: where bbom_common.common_bill_sequence_id = bbom.bill_sequence_id
75: and bbom_common.organization_id IN
76: (select * from eni_dbi_part_count_org_temp))
77: and mbic.snaptime$$ > NVL(last_collected_date,mbic.snaptime$$)
78: UNION -- Collects all deleted/modified bills whose orgs are in the org temp table
79: SELECT UNIQUE
80: bbom.assembly_item_id AS assembly_item_id,

Line 88: bbom.organization_id IN (select * from eni_dbi_part_count_org_temp)

84: WHERE
85: bbom.dmltype$$ <> 'I' and
86: bbom.alternate_bom_designator IS NULL and
87: bbom.bill_sequence_id = bbom.common_bill_sequence_id and
88: bbom.organization_id IN (select * from eni_dbi_part_count_org_temp)
89: UNION -- This query collects all the common bills for the organizations in the temp table
90: SELECT UNIQUE -- Collects any newly commoned bills
91: bbom.assembly_item_id AS assembly_item_id,
92: bbom.organization_id AS organization_id

Line 98: mlog_bbom.organization_id IN (select * from eni_dbi_part_count_org_temp) and

94: mlog$_bom_structures_b mlog_bbom, bom_structures_b bbom
95: WHERE
96: mlog_bbom.alternate_bom_designator IS NULL and
97: mlog_bbom.bill_sequence_id <> mlog_bbom.common_bill_sequence_id and
98: mlog_bbom.organization_id IN (select * from eni_dbi_part_count_org_temp) and
99: mlog_bbom.common_bill_sequence_id = bbom.bill_sequence_id;
100:
101: o_error_msg varchar2(1000);
102: o_error_code varchar2(1000);

Line 446: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_dbi_part_count_org_temp';

442: RAISE_APPLICATION_ERROR(-20000,l_error_msg);
443: END IF;
444:
445: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_dbi_part_count_f';
446: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_dbi_part_count_org_temp';
447:
448: DBMS_MVIEW.REFRESH('ENI_DBI_BOM_COMPONENTS_MV1','C');
449: DBMS_MVIEW.REFRESH('ENI_DBI_BOM_COMPONENTS_MV2','C');
450:

Line 452: INSERT INTO eni_dbi_part_count_org_temp

448: DBMS_MVIEW.REFRESH('ENI_DBI_BOM_COMPONENTS_MV1','C');
449: DBMS_MVIEW.REFRESH('ENI_DBI_BOM_COMPONENTS_MV2','C');
450:
451: IF (p_organization_id IS NULL) THEN
452: INSERT INTO eni_dbi_part_count_org_temp
453: (organization_id)
454: (SELECT organization_id from hr_all_organization_units);
455: COMMIT;
456: ELSE

Line 457: INSERT INTO eni_dbi_part_count_org_temp

453: (organization_id)
454: (SELECT organization_id from hr_all_organization_units);
455: COMMIT;
456: ELSE
457: INSERT INTO eni_dbi_part_count_org_temp
458: (organization_id) VALUES (p_organization_id);
459: COMMIT;
460: END IF;
461: ELSE

Line 466: SELECT NVL((SELECT 1 from eni_dbi_part_count_org_temp

462: -- delete from eni_dbi_part_count_f
463: -- where organization_id = p_organization_id;
464: -- COMMIT;
465:
466: SELECT NVL((SELECT 1 from eni_dbi_part_count_org_temp
467: where organization_id = p_organization_id),-1)
468: INTO l_org_exists
469: FROM DUAL;
470: IF (l_org_exists = -1) THEN

Line 471: INSERT INTO eni_dbi_part_count_org_temp

467: where organization_id = p_organization_id),-1)
468: INTO l_org_exists
469: FROM DUAL;
470: IF (l_org_exists = -1) THEN
471: INSERT INTO eni_dbi_part_count_org_temp
472: (organization_id) VALUES (p_organization_id);
473: COMMIT;
474: END IF;
475: END IF;