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 827: || 'SELECT DECODE(cz_pb_mgr.bomsynch_flag,''Y'', cz_bom_synch.locText_origSysRef(t.orig_sys_ref),t.orig_sys_ref)'

823: || 'orig_sys_ref_tgt := NULL;'
824: || ' '
825: || 'BEGIN'
826: || ' '
827: || 'SELECT DECODE(cz_pb_mgr.bomsynch_flag,''Y'', cz_bom_synch.locText_origSysRef(t.orig_sys_ref),t.orig_sys_ref)'
828: || ' '
829: || 'INTO orig_sys_ref_tgt'
830: || ' '
831: || 'FROM cz_localized_texts'

Line 10538: 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);

10534: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.BOMSYNCHPROCEDURE', SQLCODE);
10535: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10536: END;
10537:
10538: 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);
10539:
10540: ----- if v_bomsynch_err_flag is not success then set publication status to ERROR
10541: IF (v_bomsynch_err_flag <> cz_bom_synch.error_flag_success)
10542: THEN

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

10537:
10538: 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);
10539:
10540: ----- if v_bomsynch_err_flag is not success then set publication status to ERROR
10541: IF (v_bomsynch_err_flag <> cz_bom_synch.error_flag_success)
10542: THEN
10543: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10544:
10545: BEGIN

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

10623: IS
10624: BEGIN
10625: IF (p_publication_id > 0)
10626: THEN
10627: SELECT DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.modelpublication_orgid(organization_id), 'N', organization_id)
10628: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.modelpublication_topitemid(top_item_id), 'N', top_item_id)
10629: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.modelpublication_productkey(product_key), 'N', product_key)
10630: INTO cz_pb_mgr.v_bomsynch_org_id
10631: ,cz_pb_mgr.v_bomsynch_item_id

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

10624: BEGIN
10625: IF (p_publication_id > 0)
10626: THEN
10627: SELECT DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.modelpublication_orgid(organization_id), 'N', organization_id)
10628: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.modelpublication_topitemid(top_item_id), 'N', top_item_id)
10629: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.modelpublication_productkey(product_key), 'N', product_key)
10630: INTO cz_pb_mgr.v_bomsynch_org_id
10631: ,cz_pb_mgr.v_bomsynch_item_id
10632: ,cz_pb_mgr.v_bomsynch_product_key

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

10625: IF (p_publication_id > 0)
10626: THEN
10627: SELECT DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.modelpublication_orgid(organization_id), 'N', organization_id)
10628: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.modelpublication_topitemid(top_item_id), 'N', top_item_id)
10629: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.modelpublication_productkey(product_key), 'N', product_key)
10630: INTO cz_pb_mgr.v_bomsynch_org_id
10631: ,cz_pb_mgr.v_bomsynch_item_id
10632: ,cz_pb_mgr.v_bomsynch_product_key
10633: FROM cz_model_publications

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

13858: l_devl_proj_product_key := NULL;
13859: l_bom_caption_text_id := 0;
13860: l_nonbom_caption_text_id := 0;
13861:
13862: SELECT DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_origsysref(orig_sys_ref), orig_sys_ref), bom_caption_rule_id
13863: ,nonbom_caption_rule_id, DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_invid(inventory_item_id), inventory_item_id)
13864: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_orgid(organization_id), organization_id)
13865: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_productkey(product_key), product_key), bom_caption_text_id
13866: ,nonbom_caption_text_id

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

13859: l_bom_caption_text_id := 0;
13860: l_nonbom_caption_text_id := 0;
13861:
13862: SELECT DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_origsysref(orig_sys_ref), orig_sys_ref), bom_caption_rule_id
13863: ,nonbom_caption_rule_id, DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_invid(inventory_item_id), inventory_item_id)
13864: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_orgid(organization_id), organization_id)
13865: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_productkey(product_key), product_key), bom_caption_text_id
13866: ,nonbom_caption_text_id
13867: INTO cz_pb_mgr.v_devl_orig_sys_ref, cz_pb_mgr.l_bom_caption_rule

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

13860: l_nonbom_caption_text_id := 0;
13861:
13862: SELECT DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_origsysref(orig_sys_ref), orig_sys_ref), bom_caption_rule_id
13863: ,nonbom_caption_rule_id, DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_invid(inventory_item_id), inventory_item_id)
13864: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_orgid(organization_id), organization_id)
13865: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_productkey(product_key), product_key), bom_caption_text_id
13866: ,nonbom_caption_text_id
13867: INTO cz_pb_mgr.v_devl_orig_sys_ref, cz_pb_mgr.l_bom_caption_rule
13868: ,cz_pb_mgr.l_nonbom_capt_rule_id, cz_pb_mgr.l_devl_proj_inv_id

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

13861:
13862: SELECT DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_origsysref(orig_sys_ref), orig_sys_ref), bom_caption_rule_id
13863: ,nonbom_caption_rule_id, DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_invid(inventory_item_id), inventory_item_id)
13864: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_orgid(organization_id), organization_id)
13865: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.devlproject_productkey(product_key), product_key), bom_caption_text_id
13866: ,nonbom_caption_text_id
13867: INTO cz_pb_mgr.v_devl_orig_sys_ref, cz_pb_mgr.l_bom_caption_rule
13868: ,cz_pb_mgr.l_nonbom_capt_rule_id, cz_pb_mgr.l_devl_proj_inv_id
13869: ,cz_pb_mgr.l_devl_proj_org_id

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

17521: OR(cz_pb_mgr.v_ps_type_old_tbl(i) = PS_NODE_TYPE_REFERENCE AND cz_pb_mgr.v_ps_src_appl_id_old_tbl(i) = SRC_APPL_ID_BOM))
17522: THEN
17523: SELECT item_id, item_type_id
17524: ,DECODE(cz_pb_mgr.bomsynch_flag
17525: ,'Y', NVL(cz_bom_synch.itemmaster_origsysref(orig_sys_ref), cz_pb_mgr.null_string)
17526: ,NVL(orig_sys_ref, cz_pb_mgr.null_string)
17527: )
17528: ,bom_item, ref_part_nbr, NVL(src_application_id, 0)
17529: BULK COLLECT INTO cz_pb_mgr.v_item_masters_ref, cz_pb_mgr.v_item_types_ref

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

17596: IF ((cz_pb_mgr.v_item_types_tbl(i) IS NOT NULL) AND(v_bom_flg_ref(i) = bom_item))
17597: THEN
17598: SELECT item_type_id, NAME, NVL(src_application_id, 0)
17599: ,DECODE(cz_pb_mgr.bomsynch_flag
17600: ,'Y', NVL(cz_bom_synch.itemtype_origsysref(orig_sys_ref), cz_pb_mgr.null_string)
17601: ,NVL(orig_sys_ref, cz_pb_mgr.null_string)
17602: )
17603: BULK COLLECT INTO cz_pb_mgr.v_item_types_ref, v_type_name_tbl, v_type_src_app_tbl
17604: ,v_item_types_orig_tbl

Line 17728: ,'Y', NVL(cz_bom_synch.itemtypeprop_origsysref(itp.orig_sys_ref), cz_pb_mgr.null_string)

17724: cz_pb_mgr.v_src_item_type_prop_orig_ref.DELETE; --Bug9031588
17725: BEGIN
17726: SELECT itp.property_id, itp.item_type_id,p.def_num_value, p.data_type
17727: ,DECODE (cz_pb_mgr.bomsynch_flag
17728: ,'Y', NVL(cz_bom_synch.itemtypeprop_origsysref(itp.orig_sys_ref), cz_pb_mgr.null_string)
17729: ,NVL(itp.orig_sys_ref, cz_pb_mgr.null_string)),NVL(itp.orig_sys_ref, cz_pb_mgr.null_string)
17730: BULK COLLECT INTO cz_pb_mgr.v_item_prop_id_ref, cz_pb_mgr.v_item_prop_type_ref
17731: ,cz_pb_mgr.v_item_prop_num_val_ref, cz_pb_mgr.v_item_prop_data_typ_ref
17732: ,v_tgt_item_type_prop_orig_ref, v_src_item_type_prop_orig_ref

Line 17785: ,'Y', NVL(cz_bom_synch.itempropvalues_origsysref(orig_sys_ref), cz_pb_mgr.null_string)

17781:
17782: BEGIN
17783: SELECT property_id, item_id
17784: ,DECODE(cz_pb_mgr.bomsynch_flag
17785: ,'Y', NVL(cz_bom_synch.itempropvalues_origsysref(orig_sys_ref), cz_pb_mgr.null_string)
17786: , NVL(orig_sys_ref, cz_pb_mgr.null_string)
17787: ),NVL(orig_sys_ref, cz_pb_mgr.null_string)
17788: BULK COLLECT INTO cz_pb_mgr.v_it_prop_vals_id_ref, cz_pb_mgr.v_it_prop_vals_item_ref
17789: ,v_tgt_item_prop_val_orig_ref,v_src_item_prop_val_orig_ref

Line 20460: SELECT DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.projectBill_orgId(organization_id), organization_id)

20456: ------insert into cz_xfr_project_bills
20457: IF (v_rp_orig_sys_ref IS NOT NULL) THEN
20458: BEGIN
20459: -- Bug9031588
20460: SELECT DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.projectBill_orgId(organization_id), organization_id)
20461: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.projectBill_compItemId(component_item_id),component_item_id)
20462: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.projectBill_topItemId(top_item_id),top_item_id)
20463: INTO v_org_id, v_component_item_id, v_top_item_id
20464: FROM cz_xfr_project_bills

Line 20461: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.projectBill_compItemId(component_item_id),component_item_id)

20457: IF (v_rp_orig_sys_ref IS NOT NULL) THEN
20458: BEGIN
20459: -- Bug9031588
20460: SELECT DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.projectBill_orgId(organization_id), organization_id)
20461: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.projectBill_compItemId(component_item_id),component_item_id)
20462: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.projectBill_topItemId(top_item_id),top_item_id)
20463: INTO v_org_id, v_component_item_id, v_top_item_id
20464: FROM cz_xfr_project_bills
20465: WHERE cz_xfr_project_bills.MODEL_PS_NODE_ID = cz_pb_mgr.v_imported_ps_node

Line 20462: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.projectBill_topItemId(top_item_id),top_item_id)

20458: BEGIN
20459: -- Bug9031588
20460: SELECT DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.projectBill_orgId(organization_id), organization_id)
20461: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.projectBill_compItemId(component_item_id),component_item_id)
20462: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.projectBill_topItemId(top_item_id),top_item_id)
20463: INTO v_org_id, v_component_item_id, v_top_item_id
20464: FROM cz_xfr_project_bills
20465: WHERE cz_xfr_project_bills.MODEL_PS_NODE_ID = cz_pb_mgr.v_imported_ps_node
20466: AND cz_xfr_project_bills.deleted_flag = '0';

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

23482: )
23483: ,ps_node_id, parent_id, reference_id, effectivity_set_id
23484: ,intl_text_id, violation_text_id, displayname_capt_rule_id, component_id
23485: ,effective_usage_mask, item_id, ps_node_type
23486: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_origsysref(orig_sys_ref), 'N', orig_sys_ref)
23487: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_compseqpath(component_sequence_path), 'N', component_sequence_path)
23488: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_compseqid(component_sequence_id), 'N', component_sequence_id)
23489: ,NVL(ui_timestamp_add, creation_date), reverse_connector_id, src_application_id
23490: BULK COLLECT INTO cz_pb_mgr.v_cz_ps_nodes_new_ref

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

23483: ,ps_node_id, parent_id, reference_id, effectivity_set_id
23484: ,intl_text_id, violation_text_id, displayname_capt_rule_id, component_id
23485: ,effective_usage_mask, item_id, ps_node_type
23486: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_origsysref(orig_sys_ref), 'N', orig_sys_ref)
23487: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_compseqpath(component_sequence_path), 'N', component_sequence_path)
23488: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_compseqid(component_sequence_id), 'N', component_sequence_id)
23489: ,NVL(ui_timestamp_add, creation_date), reverse_connector_id, src_application_id
23490: BULK COLLECT INTO cz_pb_mgr.v_cz_ps_nodes_new_ref
23491: ,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 23488: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_compseqid(component_sequence_id), 'N', component_sequence_id)

23484: ,intl_text_id, violation_text_id, displayname_capt_rule_id, component_id
23485: ,effective_usage_mask, item_id, ps_node_type
23486: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_origsysref(orig_sys_ref), 'N', orig_sys_ref)
23487: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_compseqpath(component_sequence_path), 'N', component_sequence_path)
23488: ,DECODE(cz_pb_mgr.bomsynch_flag, 'Y', cz_bom_synch.psnode_compseqid(component_sequence_id), 'N', component_sequence_id)
23489: ,NVL(ui_timestamp_add, creation_date), reverse_connector_id, src_application_id
23490: BULK COLLECT INTO cz_pb_mgr.v_cz_ps_nodes_new_ref
23491: ,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
23492: ,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