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.

[Home] [Help]

APPS.CZ_PB_MGR dependencies on CZ_XFR_PROJECT_BILLS

Line 10510: FROM cz_xfr_project_bills

10506: IF (v_bom_err_flag = '0')
10507: THEN
10508: SELECT source_server
10509: INTO v_source_server
10510: FROM cz_xfr_project_bills
10511: WHERE model_ps_node_id = (SELECT devl_project_id
10512: FROM cz_ps_nodes
10513: WHERE cz_ps_nodes.ps_node_id = v_bom_ps_node_id AND cz_ps_nodes.deleted_flag = '0');
10514:

Line 19127: ------insert into cz_xfr_project_bills

19123: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
19124: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
19125: END;
19126:
19127: ------insert into cz_xfr_project_bills
19128: IF (v_rp_orig_sys_ref IS NOT NULL)
19129: THEN
19130: BEGIN
19131: EXECUTE IMMEDIATE 'BEGIN'

Line 19133: || 'insert into cz_xfr_project_bills'

19129: THEN
19130: BEGIN
19131: EXECUTE IMMEDIATE 'BEGIN'
19132: || ' '
19133: || 'insert into cz_xfr_project_bills'
19134: || cz_pb_mgr.v_db_link
19135: || ' ('
19136: || ' '
19137: || 'MODEL_PS_NODE_ID'

Line 19199: || 'FROM cz_xfr_project_bills'

19195: || ',SOURCE_SERVER'
19196: || ' '
19197: || ',COPY_ADDL_CHILD_MODELS'
19198: || ' '
19199: || 'FROM cz_xfr_project_bills'
19200: || ' '
19201: || 'WHERE cz_xfr_project_bills.MODEL_PS_NODE_ID = cz_pb_mgr.v_imported_ps_node'
19202: || ' '
19203: || 'AND cz_xfr_project_bills.deleted_flag = ''0'';'

Line 19201: || 'WHERE cz_xfr_project_bills.MODEL_PS_NODE_ID = cz_pb_mgr.v_imported_ps_node'

19197: || ',COPY_ADDL_CHILD_MODELS'
19198: || ' '
19199: || 'FROM cz_xfr_project_bills'
19200: || ' '
19201: || 'WHERE cz_xfr_project_bills.MODEL_PS_NODE_ID = cz_pb_mgr.v_imported_ps_node'
19202: || ' '
19203: || 'AND cz_xfr_project_bills.deleted_flag = ''0'';'
19204: || ' '
19205: || 'commit;'

Line 19203: || 'AND cz_xfr_project_bills.deleted_flag = ''0'';'

19199: || 'FROM cz_xfr_project_bills'
19200: || ' '
19201: || 'WHERE cz_xfr_project_bills.MODEL_PS_NODE_ID = cz_pb_mgr.v_imported_ps_node'
19202: || ' '
19203: || 'AND cz_xfr_project_bills.deleted_flag = ''0'';'
19204: || ' '
19205: || 'commit;'
19206: || ' '
19207: || 'END;';

Line 20011: v_org_id cz_xfr_project_bills.organization_id%TYPE; -- Bug9031588

20007: l_srcroot VARCHAR2(32000);
20008: l_targrootpath VARCHAR2(32000);
20009: l_srcmodel VARCHAR2(32000);
20010: l_tgt_fld_path VARCHAR2(32000);
20011: v_org_id cz_xfr_project_bills.organization_id%TYPE; -- Bug9031588
20012: v_component_item_id cz_xfr_project_bills.component_item_id%TYPE; -- Bug9031588
20013: v_top_item_id cz_xfr_project_bills.top_item_id%TYPE; -- Bug9031588
20014:
20015: v_import_server_on_remote cz_servers.server_local_id%TYPE;

Line 20012: v_component_item_id cz_xfr_project_bills.component_item_id%TYPE; -- Bug9031588

20008: l_targrootpath VARCHAR2(32000);
20009: l_srcmodel VARCHAR2(32000);
20010: l_tgt_fld_path VARCHAR2(32000);
20011: v_org_id cz_xfr_project_bills.organization_id%TYPE; -- Bug9031588
20012: v_component_item_id cz_xfr_project_bills.component_item_id%TYPE; -- Bug9031588
20013: v_top_item_id cz_xfr_project_bills.top_item_id%TYPE; -- Bug9031588
20014:
20015: v_import_server_on_remote cz_servers.server_local_id%TYPE;
20016: l_target_imp_server_on_local cz_servers.server_local_id%TYPE;

Line 20013: v_top_item_id cz_xfr_project_bills.top_item_id%TYPE; -- Bug9031588

20009: l_srcmodel VARCHAR2(32000);
20010: l_tgt_fld_path VARCHAR2(32000);
20011: v_org_id cz_xfr_project_bills.organization_id%TYPE; -- Bug9031588
20012: v_component_item_id cz_xfr_project_bills.component_item_id%TYPE; -- Bug9031588
20013: v_top_item_id cz_xfr_project_bills.top_item_id%TYPE; -- Bug9031588
20014:
20015: v_import_server_on_remote cz_servers.server_local_id%TYPE;
20016: l_target_imp_server_on_local cz_servers.server_local_id%TYPE;
20017: l_instance_nm cz_servers.instance_name%TYPE;

Line 20178: * CZ_XFR_PROJECT_BILLS are also migrated. However, the column SOURCE_SERVER

20174:
20175: /*
20176: * Bug 5516478
20177: * On migrating a model to a remote server, if there are BOM models involved,
20178: * CZ_XFR_PROJECT_BILLS are also migrated. However, the column SOURCE_SERVER
20179: * in CZ_XFR_PROJECT_BILLS needs to be resolved to the import server on the
20180: * migration target. Currently it was being copied from the source to the
20181: * target. In order to do this we need to query CZ_SERVERS in the migration
20182: * target to get the SERVER_LOCAL_ID.

Line 20179: * in CZ_XFR_PROJECT_BILLS needs to be resolved to the import server on the

20175: /*
20176: * Bug 5516478
20177: * On migrating a model to a remote server, if there are BOM models involved,
20178: * CZ_XFR_PROJECT_BILLS are also migrated. However, the column SOURCE_SERVER
20179: * in CZ_XFR_PROJECT_BILLS needs to be resolved to the import server on the
20180: * migration target. Currently it was being copied from the source to the
20181: * target. In order to do this we need to query CZ_SERVERS in the migration
20182: * target to get the SERVER_LOCAL_ID.
20183: */

Line 20456: ------insert into cz_xfr_project_bills

20452: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MIGRATEMODEL', SQLCODE);
20453: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
20454: END;
20455:
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)

Line 20464: FROM cz_xfr_project_bills

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';
20467:
20468: EXECUTE IMMEDIATE 'BEGIN'

Line 20465: WHERE cz_xfr_project_bills.MODEL_PS_NODE_ID = cz_pb_mgr.v_imported_ps_node

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';
20467:
20468: EXECUTE IMMEDIATE 'BEGIN'
20469: || ' '

Line 20466: AND cz_xfr_project_bills.deleted_flag = '0';

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';
20467:
20468: EXECUTE IMMEDIATE 'BEGIN'
20469: || ' '
20470: || 'insert into cz_xfr_project_bills'

Line 20470: || 'insert into cz_xfr_project_bills'

20466: AND cz_xfr_project_bills.deleted_flag = '0';
20467:
20468: EXECUTE IMMEDIATE 'BEGIN'
20469: || ' '
20470: || 'insert into cz_xfr_project_bills'
20471: || cz_pb_mgr.v_db_link
20472: || ' ('
20473: || ' '
20474: || 'MODEL_PS_NODE_ID'

Line 20536: || 'FROM cz_xfr_project_bills'

20532: || ',:4'
20533: || ' '
20534: || ',COPY_ADDL_CHILD_MODELS'
20535: || ' '
20536: || 'FROM cz_xfr_project_bills'
20537: || ' '
20538: || 'WHERE cz_xfr_project_bills.MODEL_PS_NODE_ID = cz_pb_mgr.v_imported_ps_node'
20539: || ' '
20540: || 'AND cz_xfr_project_bills.deleted_flag = ''0'';'

Line 20538: || 'WHERE cz_xfr_project_bills.MODEL_PS_NODE_ID = cz_pb_mgr.v_imported_ps_node'

20534: || ',COPY_ADDL_CHILD_MODELS'
20535: || ' '
20536: || 'FROM cz_xfr_project_bills'
20537: || ' '
20538: || 'WHERE cz_xfr_project_bills.MODEL_PS_NODE_ID = cz_pb_mgr.v_imported_ps_node'
20539: || ' '
20540: || 'AND cz_xfr_project_bills.deleted_flag = ''0'';'
20541: || ' '
20542: || 'commit;'

Line 20540: || 'AND cz_xfr_project_bills.deleted_flag = ''0'';'

20536: || 'FROM cz_xfr_project_bills'
20537: || ' '
20538: || 'WHERE cz_xfr_project_bills.MODEL_PS_NODE_ID = cz_pb_mgr.v_imported_ps_node'
20539: || ' '
20540: || 'AND cz_xfr_project_bills.deleted_flag = ''0'';'
20541: || ' '
20542: || 'commit;'
20543: || ' '
20544: || 'END;'

Line 25067: * CZ_XFR_PROJECT_BILLS are also migrated. However, the column SOURCE_SERVER

25063: ------------------------------------------------------------------------------------------------
25064: /*
25065: * Bug 5516478
25066: * On migrating a model to a remote server, if there are BOM models involved,
25067: * CZ_XFR_PROJECT_BILLS are also migrated. However, the column SOURCE_SERVER
25068: * in CZ_XFR_PROJECT_BILLS needs to be resolved to the import server on the
25069: * migration target. Currently it was being copied from the source to the
25070: * target. In order to do this we need to query CZ_SERVERS in the migration
25071: * target to get the SERVER_LOCAL_ID.

Line 25068: * in CZ_XFR_PROJECT_BILLS needs to be resolved to the import server on the

25064: /*
25065: * Bug 5516478
25066: * On migrating a model to a remote server, if there are BOM models involved,
25067: * CZ_XFR_PROJECT_BILLS are also migrated. However, the column SOURCE_SERVER
25068: * in CZ_XFR_PROJECT_BILLS needs to be resolved to the import server on the
25069: * migration target. Currently it was being copied from the source to the
25070: * target. In order to do this we need to query CZ_SERVERS in the migration
25071: * target to get the SERVER_LOCAL_ID.
25072: */