eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_PB_MGR dependencies on CZ_BOM_SYNCH

Line 9782: cz_bom_synch.verify_model(cz_pb_mgr.v_root_model_id, cz_pb_mgr.v_server_local_name, v_bomsynch_err_flag, v_verify_model_run_id);

9778: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.BOMSYNCHPROCEDURE', SQLCODE);
9779: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
9780: END;
9781:
9782: cz_bom_synch.verify_model(cz_pb_mgr.v_root_model_id, cz_pb_mgr.v_server_local_name, v_bomsynch_err_flag, v_verify_model_run_id);
9783:
9784: ----- if v_bomsynch_err_flag is not success then set publication status to ERROR
9785: IF (v_bomsynch_err_flag <> cz_bom_synch.error_flag_success)
9786: THEN

Line 9785: IF (v_bomsynch_err_flag <> cz_bom_synch.error_flag_success)

9781:
9782: cz_bom_synch.verify_model(cz_pb_mgr.v_root_model_id, cz_pb_mgr.v_server_local_name, v_bomsynch_err_flag, v_verify_model_run_id);
9783:
9784: ----- if v_bomsynch_err_flag is not success then set publication status to ERROR
9785: IF (v_bomsynch_err_flag <> cz_bom_synch.error_flag_success)
9786: THEN
9787: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
9788:
9789: BEGIN

Line 9871: SELECT DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.modelpublication_orgid(organization_id), 'N', organization_id)

9867: IS
9868: BEGIN
9869: IF (p_publication_id > 0)
9870: THEN
9871: SELECT DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.modelpublication_orgid(organization_id), 'N', organization_id)
9872: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.modelpublication_topitemid(top_item_id), 'N', top_item_id)
9873: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.modelpublication_productkey(product_key), 'N', product_key)
9874: INTO cz_pb_mgr.v_bomsynch_org_id
9875: ,cz_pb_mgr.v_bomsynch_item_id

Line 9872: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.modelpublication_topitemid(top_item_id), 'N', top_item_id)

9868: BEGIN
9869: IF (p_publication_id > 0)
9870: THEN
9871: SELECT DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.modelpublication_orgid(organization_id), 'N', organization_id)
9872: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.modelpublication_topitemid(top_item_id), 'N', top_item_id)
9873: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.modelpublication_productkey(product_key), 'N', product_key)
9874: INTO cz_pb_mgr.v_bomsynch_org_id
9875: ,cz_pb_mgr.v_bomsynch_item_id
9876: ,cz_pb_mgr.v_bomsynch_product_key

Line 9873: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.modelpublication_productkey(product_key), 'N', product_key)

9869: IF (p_publication_id > 0)
9870: THEN
9871: SELECT DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.modelpublication_orgid(organization_id), 'N', organization_id)
9872: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.modelpublication_topitemid(top_item_id), 'N', top_item_id)
9873: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.modelpublication_productkey(product_key), 'N', product_key)
9874: INTO cz_pb_mgr.v_bomsynch_org_id
9875: ,cz_pb_mgr.v_bomsynch_item_id
9876: ,cz_pb_mgr.v_bomsynch_product_key
9877: FROM cz_model_publications

Line 12864: SELECT DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_origsysref(orig_sys_ref), orig_sys_ref), bom_caption_rule_id

12860: l_devl_proj_product_key := NULL;
12861: l_bom_caption_text_id := 0;
12862: l_nonbom_caption_text_id := 0;
12863:
12864: SELECT DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_origsysref(orig_sys_ref), orig_sys_ref), bom_caption_rule_id
12865: ,nonbom_caption_rule_id, DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_invid(inventory_item_id), inventory_item_id)
12866: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_orgid(organization_id), organization_id)
12867: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_productkey(product_key), product_key), bom_caption_text_id
12868: ,nonbom_caption_text_id

Line 12865: ,nonbom_caption_rule_id, DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_invid(inventory_item_id), inventory_item_id)

12861: l_bom_caption_text_id := 0;
12862: l_nonbom_caption_text_id := 0;
12863:
12864: SELECT DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_origsysref(orig_sys_ref), orig_sys_ref), bom_caption_rule_id
12865: ,nonbom_caption_rule_id, DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_invid(inventory_item_id), inventory_item_id)
12866: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_orgid(organization_id), organization_id)
12867: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_productkey(product_key), product_key), bom_caption_text_id
12868: ,nonbom_caption_text_id
12869: INTO cz_pb_mgr.v_devl_orig_sys_ref, cz_pb_mgr.l_bom_caption_rule

Line 12866: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_orgid(organization_id), organization_id)

12862: l_nonbom_caption_text_id := 0;
12863:
12864: SELECT DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_origsysref(orig_sys_ref), orig_sys_ref), bom_caption_rule_id
12865: ,nonbom_caption_rule_id, DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_invid(inventory_item_id), inventory_item_id)
12866: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_orgid(organization_id), organization_id)
12867: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_productkey(product_key), product_key), bom_caption_text_id
12868: ,nonbom_caption_text_id
12869: INTO cz_pb_mgr.v_devl_orig_sys_ref, cz_pb_mgr.l_bom_caption_rule
12870: ,cz_pb_mgr.l_nonbom_capt_rule_id, cz_pb_mgr.l_devl_proj_inv_id

Line 12867: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_productkey(product_key), product_key), bom_caption_text_id

12863:
12864: SELECT DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_origsysref(orig_sys_ref), orig_sys_ref), bom_caption_rule_id
12865: ,nonbom_caption_rule_id, DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_invid(inventory_item_id), inventory_item_id)
12866: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_orgid(organization_id), organization_id)
12867: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_productkey(product_key), product_key), bom_caption_text_id
12868: ,nonbom_caption_text_id
12869: INTO cz_pb_mgr.v_devl_orig_sys_ref, cz_pb_mgr.l_bom_caption_rule
12870: ,cz_pb_mgr.l_nonbom_capt_rule_id, cz_pb_mgr.l_devl_proj_inv_id
12871: ,cz_pb_mgr.l_devl_proj_org_id

Line 16405: ,'Y', NVL(cz_bom_synch.itemmaster_origsysref(orig_sys_ref), cz_pb_mgr.null_string)

16401: IF ((cz_pb_mgr.v_ps_type_old_tbl(i) = 436) OR(cz_pb_mgr.v_ps_type_old_tbl(i) = 437) OR(cz_pb_mgr.v_ps_type_old_tbl(i) = 438))
16402: THEN
16403: SELECT item_id, item_type_id
16404: ,DECODE(cz_pb_mgr.bomsynch_flag
16405: ,'Y', NVL(cz_bom_synch.itemmaster_origsysref(orig_sys_ref), cz_pb_mgr.null_string)
16406: ,NVL(orig_sys_ref, cz_pb_mgr.null_string)
16407: )
16408: ,bom_item, ref_part_nbr, NVL(src_application_id, 0)
16409: BULK COLLECT INTO cz_pb_mgr.v_item_masters_ref, cz_pb_mgr.v_item_types_ref

Line 16480: ,'Y', NVL(cz_bom_synch.itemtype_origsysref(orig_sys_ref), cz_pb_mgr.null_string)

16476: IF ((cz_pb_mgr.v_item_types_tbl(i) IS NOT NULL) AND(v_bom_flg_ref(i) = bom_item))
16477: THEN
16478: SELECT item_type_id, NAME, NVL(src_application_id, 0)
16479: ,DECODE(cz_pb_mgr.bomsynch_flag
16480: ,'Y', NVL(cz_bom_synch.itemtype_origsysref(orig_sys_ref), cz_pb_mgr.null_string)
16481: ,NVL(orig_sys_ref, cz_pb_mgr.null_string)
16482: )
16483: BULK COLLECT INTO cz_pb_mgr.v_item_types_ref, v_type_name_tbl, v_type_src_app_tbl
16484: ,v_item_types_orig_tbl

Line 22277: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_origsysref(orig_sys_ref), 'N', orig_sys_ref)

22273: )
22274: ,ps_node_id, parent_id, reference_id, effectivity_set_id
22275: ,intl_text_id, violation_text_id, displayname_capt_rule_id, component_id
22276: ,effective_usage_mask, item_id, ps_node_type
22277: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_origsysref(orig_sys_ref), 'N', orig_sys_ref)
22278: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_compseqpath(component_sequence_path), 'N', component_sequence_path)
22279: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_compseqid(component_sequence_id), 'N', component_sequence_id)
22280: ,NVL(ui_timestamp_add, creation_date), reverse_connector_id
22281: BULK COLLECT INTO cz_pb_mgr.v_cz_ps_nodes_new_ref

Line 22278: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_compseqpath(component_sequence_path), 'N', component_sequence_path)

22274: ,ps_node_id, parent_id, reference_id, effectivity_set_id
22275: ,intl_text_id, violation_text_id, displayname_capt_rule_id, component_id
22276: ,effective_usage_mask, item_id, ps_node_type
22277: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_origsysref(orig_sys_ref), 'N', orig_sys_ref)
22278: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_compseqpath(component_sequence_path), 'N', component_sequence_path)
22279: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_compseqid(component_sequence_id), 'N', component_sequence_id)
22280: ,NVL(ui_timestamp_add, creation_date), reverse_connector_id
22281: BULK COLLECT INTO cz_pb_mgr.v_cz_ps_nodes_new_ref
22282: ,cz_pb_mgr.v_cz_ps_nodes_old_ref, cz_pb_mgr.v_ps_parent_id_ref, cz_pb_mgr.v_ps_ref_id_ref, cz_pb_mgr.v_ps_eff_set_id_ref

Line 22279: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_compseqid(component_sequence_id), 'N', component_sequence_id)

22275: ,intl_text_id, violation_text_id, displayname_capt_rule_id, component_id
22276: ,effective_usage_mask, item_id, ps_node_type
22277: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_origsysref(orig_sys_ref), 'N', orig_sys_ref)
22278: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_compseqpath(component_sequence_path), 'N', component_sequence_path)
22279: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_compseqid(component_sequence_id), 'N', component_sequence_id)
22280: ,NVL(ui_timestamp_add, creation_date), reverse_connector_id
22281: BULK COLLECT INTO cz_pb_mgr.v_cz_ps_nodes_new_ref
22282: ,cz_pb_mgr.v_cz_ps_nodes_old_ref, cz_pb_mgr.v_ps_parent_id_ref, cz_pb_mgr.v_ps_ref_id_ref, cz_pb_mgr.v_ps_eff_set_id_ref
22283: ,cz_pb_mgr.v_ps_intl_old_ref, cz_pb_mgr.v_ps_viol_old_ref, cz_pb_mgr.v_ps_capt_rule_ref, cz_pb_mgr.v_cz_ps_nodes_comp_ref