APPS.CZ_IMP_SINGLE dependencies on BOM_EXPLOSIONS

Line 1542: ---BOM_EXPLOSIONS is supposed to be correct, and so no verification is done -

1538: ---Check the online PS_NODE table for obsolete ps_nodes, i.e. ps_nodes -
1539: ---which are not present in the current import data under the current project,-
1540: ---and so their corresponding BOMs were likely deleted in Oracle Applications.-
1541: ---For such ps_nodes DELETED_FLAG field should be set to '1'. -
1542: ---BOM_EXPLOSIONS is supposed to be correct, and so no verification is done -
1543: ---for parent-child relationships after some of the ps_nodes are marked as -
1544: ---deleted. -
1545: -------------------------------------------------------------------------------
1546:

Line 1694: nTopBillSequenceId BOM_EXPLOSIONS.top_bill_sequence_id%type;

1690: iLanguage tLanguage;
1691: iSrcLang tSrcLang;
1692: -- iFSKDevlProject tFSKDevlProject;
1693: iFSKDevlProject cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;
1694: nTopBillSequenceId BOM_EXPLOSIONS.top_bill_sequence_id%type;
1695:
1696: st_time number;
1697: end_time number;
1698: loop_end_time number;

Line 1714: l_comp_code bom_explosions.component_code%TYPE;

1710: WHERE organization_id = nOrg_ID
1711: AND top_item_id = nTop_ID
1712: AND explosion_type = sExpl_type;
1713:
1714: l_comp_code bom_explosions.component_code%TYPE;
1715: x_model_found BOOLEAN := FALSE;
1716: l_next_model_id NUMBER;
1717: l_parent_model_id NUMBER;
1718: l_next_item_id NUMBER;

Line 3515: DELETE FROM bom_explosions WHERE explosion_type = inExplType AND organization_id = inOrgId

3511: end if;
3512:
3513: IF((inRunExploder = 1) and (NOT(GET_REMOTE_IMPORT))) THEN
3514:
3515: DELETE FROM bom_explosions WHERE explosion_type = inExplType AND organization_id = inOrgId
3516: AND top_item_id = inTopId;
3517: COMMIT;
3518:
3519: BOMPNORD.bmxporder_explode_for_order(inOrgId, 2, inExplType, 1, outGrp_ID,

Line 3527: fnd_stats.gather_table_stats('BOM', 'BOM_EXPLOSIONS');

3523: COMMIT;
3524:
3525: IF(inGenStatistics = 1)THEN
3526:
3527: fnd_stats.gather_table_stats('BOM', 'BOM_EXPLOSIONS');
3528: END IF;
3529:
3530: IF(outError_code <> 0)THEN
3531: xERROR:=cz_utils.log_report(outErr_msg, 1, 'BOM_EXPLODER', 11276,inRunId);

Line 3544: SELECT 1 INTO l_check FROM cz_exv_bom_explosions

3540: --otherwise it is possible to delete active items from Configurator.
3541:
3542: BEGIN
3543:
3544: SELECT 1 INTO l_check FROM cz_exv_bom_explosions
3545: WHERE top_item_id = inTopId
3546: AND organization_id= inOrgId
3547: AND explosion_type = inExplType
3548: AND rexplode_flag = 1

Line 3864: --Generate statistics on BOM_EXPLOSIONS after root explosion, default - NO.

3860: WHEN OTHERS THEN
3861: importUnchangedChildModels := 1;
3862: END;
3863:
3864: --Generate statistics on BOM_EXPLOSIONS after root explosion, default - NO.
3865:
3866: v_settings_id := 'GENSTATISTICSBOM';
3867: v_section_name := 'IMPORT';
3868: