APPS.CZ_IMP_SINGLE dependencies on BOM_EXPLOSIONS

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

1476: ---Check the online PS_NODE table for obsolete ps_nodes, i.e. ps_nodes -
1477: ---which are not present in the current import data under the current project,-
1478: ---and so their corresponding BOMs were likely deleted in Oracle Applications.-
1479: ---For such ps_nodes DELETED_FLAG field should be set to '1'. -
1480: ---BOM_EXPLOSIONS is supposed to be correct, and so no verification is done -
1481: ---for parent-child relationships after some of the ps_nodes are marked as -
1482: ---deleted. -
1483: -------------------------------------------------------------------------------
1484:

Line 1632: nTopBillSequenceId BOM_EXPLOSIONS.top_bill_sequence_id%type;

1628: iLanguage tLanguage;
1629: iSrcLang tSrcLang;
1630: -- iFSKDevlProject tFSKDevlProject;
1631: iFSKDevlProject cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;
1632: nTopBillSequenceId BOM_EXPLOSIONS.top_bill_sequence_id%type;
1633:
1634: st_time number;
1635: end_time number;
1636: loop_end_time number;

Line 1652: l_comp_code bom_explosions.component_code%TYPE;

1648: WHERE organization_id = nOrg_ID
1649: AND top_item_id = nTop_ID
1650: AND explosion_type = sExpl_type;
1651:
1652: l_comp_code bom_explosions.component_code%TYPE;
1653: x_model_found BOOLEAN := FALSE;
1654: l_next_model_id NUMBER;
1655: l_parent_model_id NUMBER;
1656: l_next_item_id NUMBER;

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

3283: end if;
3284:
3285: IF((inRunExploder = 1) and (NOT(GET_REMOTE_IMPORT))) THEN
3286:
3287: DELETE FROM bom_explosions WHERE explosion_type = inExplType AND organization_id = inOrgId
3288: AND top_item_id = inTopId;
3289: COMMIT;
3290:
3291: BOMPNORD.bmxporder_explode_for_order(inOrgId, 2, inExplType, 1, outGrp_ID,

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

3295: COMMIT;
3296:
3297: IF(inGenStatistics = 1)THEN
3298:
3299: fnd_stats.gather_table_stats('BOM', 'BOM_EXPLOSIONS');
3300: END IF;
3301:
3302: IF(outError_code <> 0)THEN
3303: xERROR:=cz_utils.log_report(outErr_msg, 1, 'BOM_EXPLODER', 11276,inRunId);

Line 3316: SELECT 1 INTO l_check FROM cz_exv_bom_explosions

3312: --otherwise it is possible to delete active items from Configurator.
3313:
3314: BEGIN
3315:
3316: SELECT 1 INTO l_check FROM cz_exv_bom_explosions
3317: WHERE top_item_id = inTopId
3318: AND organization_id= inOrgId
3319: AND explosion_type = inExplType
3320: AND rexplode_flag = 1

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

3547: WHEN OTHERS THEN
3548: importUnchangedChildModels := 1;
3549: END;
3550:
3551: --Generate statistics on BOM_EXPLOSIONS after root explosion, default - NO.
3552:
3553: v_settings_id := 'GENSTATISTICSBOM';
3554: v_section_name := 'IMPORT';
3555: