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_UPGRADE dependencies on CZ_LCE_HEADERS

Line 1054: -- delete cz_lce_headers for component_id = devl_project_id with model_ref_expl_flag = -1

1050:
1051: IF (devlProjectId.COUNT > 0) THEN
1052: FOR i IN devlProjectId.FIRST..devlProjectId.LAST
1053: LOOP
1054: -- delete cz_lce_headers for component_id = devl_project_id with model_ref_expl_flag = -1
1055: -- Bug #2369725
1056: update cz_lce_headers set deleted_flag = '1'
1057: where component_id = devlProjectId(i)
1058: and deleted_flag = '0'

Line 1056: update cz_lce_headers set deleted_flag = '1'

1052: FOR i IN devlProjectId.FIRST..devlProjectId.LAST
1053: LOOP
1054: -- delete cz_lce_headers for component_id = devl_project_id with model_ref_expl_flag = -1
1055: -- Bug #2369725
1056: update cz_lce_headers set deleted_flag = '1'
1057: where component_id = devlProjectId(i)
1058: and deleted_flag = '0'
1059: and model_ref_expl_id = -1;
1060: commit;

Line 1131: FROM cz_lce_headers

1127: SELECT lce_header_id
1128: BULK
1129: COLLECT
1130: INTO x_lce_header_tbl
1131: FROM cz_lce_headers
1132: WHERE cz_lce_headers.deleted_flag = '0'
1133: AND cz_lce_headers.component_id IN
1134: (
1135: SELECT ps_node_id

Line 1132: WHERE cz_lce_headers.deleted_flag = '0'

1128: BULK
1129: COLLECT
1130: INTO x_lce_header_tbl
1131: FROM cz_lce_headers
1132: WHERE cz_lce_headers.deleted_flag = '0'
1133: AND cz_lce_headers.component_id IN
1134: (
1135: SELECT ps_node_id
1136: FROM cz_ps_nodes

Line 1133: AND cz_lce_headers.component_id IN

1129: COLLECT
1130: INTO x_lce_header_tbl
1131: FROM cz_lce_headers
1132: WHERE cz_lce_headers.deleted_flag = '0'
1133: AND cz_lce_headers.component_id IN
1134: (
1135: SELECT ps_node_id
1136: FROM cz_ps_nodes
1137: WHERE cz_ps_nodes.deleted_flag = '0'

Line 1212: FROM cz_lce_headers

1208: SELECT lce_header_id
1209: BULK
1210: COLLECT
1211: INTO v_lce_hdrs_tbl
1212: FROM cz_lce_headers
1213: WHERE cz_lce_headers.component_id = v_all_published_models_tbl(pubLceHdr)
1214: AND cz_lce_headers.deleted_flag = '0';
1215: EXCEPTION
1216: WHEN NO_DATA_FOUND THEN

Line 1213: WHERE cz_lce_headers.component_id = v_all_published_models_tbl(pubLceHdr)

1209: BULK
1210: COLLECT
1211: INTO v_lce_hdrs_tbl
1212: FROM cz_lce_headers
1213: WHERE cz_lce_headers.component_id = v_all_published_models_tbl(pubLceHdr)
1214: AND cz_lce_headers.deleted_flag = '0';
1215: EXCEPTION
1216: WHEN NO_DATA_FOUND THEN
1217: x_err_message := 'The lce_header_id for component '||v_all_published_models_tbl(pubLceHdr)||' does not have data in cz_lce_headers';

Line 1214: AND cz_lce_headers.deleted_flag = '0';

1210: COLLECT
1211: INTO v_lce_hdrs_tbl
1212: FROM cz_lce_headers
1213: WHERE cz_lce_headers.component_id = v_all_published_models_tbl(pubLceHdr)
1214: AND cz_lce_headers.deleted_flag = '0';
1215: EXCEPTION
1216: WHEN NO_DATA_FOUND THEN
1217: x_err_message := 'The lce_header_id for component '||v_all_published_models_tbl(pubLceHdr)||' does not have data in cz_lce_headers';
1218: WHEN OTHERS THEN

Line 1217: x_err_message := 'The lce_header_id for component '||v_all_published_models_tbl(pubLceHdr)||' does not have data in cz_lce_headers';

1213: WHERE cz_lce_headers.component_id = v_all_published_models_tbl(pubLceHdr)
1214: AND cz_lce_headers.deleted_flag = '0';
1215: EXCEPTION
1216: WHEN NO_DATA_FOUND THEN
1217: x_err_message := 'The lce_header_id for component '||v_all_published_models_tbl(pubLceHdr)||' does not have data in cz_lce_headers';
1218: WHEN OTHERS THEN
1219: RAISE;
1220: END;
1221:

Line 1248: v_lce_header_id cz_lce_headers.lce_header_id%TYPE;

1244: x_populate_error_flag IN OUT NOCOPY VARCHAR2,
1245: x_populate_error_msg IN OUT NOCOPY VARCHAR2)
1246: IS
1247:
1248: v_lce_header_id cz_lce_headers.lce_header_id%TYPE;
1249: v_component_id cz_lce_headers.component_id%TYPE;
1250: v_model_ref_expl_id cz_lce_headers.model_ref_expl_id%TYPE;
1251: v_net_type cz_lce_headers.net_type%TYPE;
1252: v_devl_project_id cz_lce_headers.devl_project_id%TYPE;

Line 1249: v_component_id cz_lce_headers.component_id%TYPE;

1245: x_populate_error_msg IN OUT NOCOPY VARCHAR2)
1246: IS
1247:
1248: v_lce_header_id cz_lce_headers.lce_header_id%TYPE;
1249: v_component_id cz_lce_headers.component_id%TYPE;
1250: v_model_ref_expl_id cz_lce_headers.model_ref_expl_id%TYPE;
1251: v_net_type cz_lce_headers.net_type%TYPE;
1252: v_devl_project_id cz_lce_headers.devl_project_id%TYPE;
1253: v_model_id cz_lce_headers.devl_project_id%TYPE;

Line 1250: v_model_ref_expl_id cz_lce_headers.model_ref_expl_id%TYPE;

1246: IS
1247:
1248: v_lce_header_id cz_lce_headers.lce_header_id%TYPE;
1249: v_component_id cz_lce_headers.component_id%TYPE;
1250: v_model_ref_expl_id cz_lce_headers.model_ref_expl_id%TYPE;
1251: v_net_type cz_lce_headers.net_type%TYPE;
1252: v_devl_project_id cz_lce_headers.devl_project_id%TYPE;
1253: v_model_id cz_lce_headers.devl_project_id%TYPE;
1254: v_exception_err NUMBER := 0;

Line 1251: v_net_type cz_lce_headers.net_type%TYPE;

1247:
1248: v_lce_header_id cz_lce_headers.lce_header_id%TYPE;
1249: v_component_id cz_lce_headers.component_id%TYPE;
1250: v_model_ref_expl_id cz_lce_headers.model_ref_expl_id%TYPE;
1251: v_net_type cz_lce_headers.net_type%TYPE;
1252: v_devl_project_id cz_lce_headers.devl_project_id%TYPE;
1253: v_model_id cz_lce_headers.devl_project_id%TYPE;
1254: v_exception_err NUMBER := 0;
1255:

Line 1252: v_devl_project_id cz_lce_headers.devl_project_id%TYPE;

1248: v_lce_header_id cz_lce_headers.lce_header_id%TYPE;
1249: v_component_id cz_lce_headers.component_id%TYPE;
1250: v_model_ref_expl_id cz_lce_headers.model_ref_expl_id%TYPE;
1251: v_net_type cz_lce_headers.net_type%TYPE;
1252: v_devl_project_id cz_lce_headers.devl_project_id%TYPE;
1253: v_model_id cz_lce_headers.devl_project_id%TYPE;
1254: v_exception_err NUMBER := 0;
1255:
1256: BEGIN

Line 1253: v_model_id cz_lce_headers.devl_project_id%TYPE;

1249: v_component_id cz_lce_headers.component_id%TYPE;
1250: v_model_ref_expl_id cz_lce_headers.model_ref_expl_id%TYPE;
1251: v_net_type cz_lce_headers.net_type%TYPE;
1252: v_devl_project_id cz_lce_headers.devl_project_id%TYPE;
1253: v_model_id cz_lce_headers.devl_project_id%TYPE;
1254: v_exception_err NUMBER := 0;
1255:
1256: BEGIN
1257: IF (p_lce_header_id IS NOT NULL) THEN

Line 1269: FROM cz_lce_headers

1265: ,v_component_id
1266: ,v_model_ref_expl_id
1267: ,v_net_type
1268: ,v_devl_project_id
1269: FROM cz_lce_headers
1270: WHERE cz_lce_headers.lce_header_id = p_lce_header_id
1271: AND cz_lce_headers.deleted_flag = '0';
1272: EXCEPTION
1273: WHEN NO_DATA_FOUND THEN

Line 1270: WHERE cz_lce_headers.lce_header_id = p_lce_header_id

1266: ,v_model_ref_expl_id
1267: ,v_net_type
1268: ,v_devl_project_id
1269: FROM cz_lce_headers
1270: WHERE cz_lce_headers.lce_header_id = p_lce_header_id
1271: AND cz_lce_headers.deleted_flag = '0';
1272: EXCEPTION
1273: WHEN NO_DATA_FOUND THEN
1274: x_populate_error_msg := 'The lce_deader_id '||p_lce_header_id||' does not have data in cz_lce_headers';

Line 1271: AND cz_lce_headers.deleted_flag = '0';

1267: ,v_net_type
1268: ,v_devl_project_id
1269: FROM cz_lce_headers
1270: WHERE cz_lce_headers.lce_header_id = p_lce_header_id
1271: AND cz_lce_headers.deleted_flag = '0';
1272: EXCEPTION
1273: WHEN NO_DATA_FOUND THEN
1274: x_populate_error_msg := 'The lce_deader_id '||p_lce_header_id||' does not have data in cz_lce_headers';
1275: RAISE;

Line 1274: x_populate_error_msg := 'The lce_deader_id '||p_lce_header_id||' does not have data in cz_lce_headers';

1270: WHERE cz_lce_headers.lce_header_id = p_lce_header_id
1271: AND cz_lce_headers.deleted_flag = '0';
1272: EXCEPTION
1273: WHEN NO_DATA_FOUND THEN
1274: x_populate_error_msg := 'The lce_deader_id '||p_lce_header_id||' does not have data in cz_lce_headers';
1275: RAISE;
1276: WHEN OTHERS THEN
1277: RAISE;
1278: END;

Line 1360: UPDATE cz_lce_headers

1356: ,v_component_id
1357: ,v_model_id
1358: ,v_net_type );
1359:
1360: UPDATE cz_lce_headers
1361: SET model_ref_expl_id = v_model_ref_expl_id,
1362: devl_project_id = v_model_id,
1363: NBR_REQUIRED_EXPLS = 0
1364: WHERE lce_header_id = v_lce_header_id;

Line 1651: TYPE tHeaderId IS TABLE OF cz_lce_headers.lce_header_id%TYPE INDEX BY BINARY_INTEGER;

1647: TYPE tSetEffUntil IS TABLE OF cz_effectivity_sets.effective_until%TYPE INDEX BY BINARY_INTEGER;
1648: TYPE tSetEffId IS TABLE OF cz_effectivity_sets.effectivity_set_id%TYPE INDEX BY BINARY_INTEGER;
1649: TYPE tSetName IS TABLE OF cz_effectivity_sets.name%TYPE INDEX BY BINARY_INTEGER;
1650:
1651: TYPE tHeaderId IS TABLE OF cz_lce_headers.lce_header_id%TYPE INDEX BY BINARY_INTEGER;
1652: TYPE tExplNodeId IS TABLE OF cz_model_ref_expls.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;
1653: TYPE tExplNodeId_idx_vc2 IS TABLE OF cz_model_ref_expls.model_ref_expl_id%TYPE INDEX BY VARCHAR2(15);
1654:
1655: IsLogicGenerated tIntegerArray_idx_vc2; --jonatara:int2long:bug6054920

Line 1851: nHeaderId cz_lce_headers.lce_header_id%TYPE;

1847: vUsageMask cz_rules.effective_usage_mask%TYPE;
1848: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;
1849: nAux cz_model_ref_expls.model_ref_expl_id%TYPE;
1850: MaxDepthValue cz_model_ref_expls.node_depth%TYPE;
1851: nHeaderId cz_lce_headers.lce_header_id%TYPE;
1852: nPreviousHeaderId cz_lce_headers.lce_header_id%TYPE;
1853: nNewLogicFileFlag PLS_INTEGER := 0;
1854: nRuleAssignedLevel PLS_INTEGER;
1855: MaxDepthIndex PLS_INTEGER;

Line 1852: nPreviousHeaderId cz_lce_headers.lce_header_id%TYPE;

1848: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;
1849: nAux cz_model_ref_expls.model_ref_expl_id%TYPE;
1850: MaxDepthValue cz_model_ref_expls.node_depth%TYPE;
1851: nHeaderId cz_lce_headers.lce_header_id%TYPE;
1852: nPreviousHeaderId cz_lce_headers.lce_header_id%TYPE;
1853: nNewLogicFileFlag PLS_INTEGER := 0;
1854: nRuleAssignedLevel PLS_INTEGER;
1855: MaxDepthIndex PLS_INTEGER;
1856: logicNetType PLS_INTEGER;

Line 2726: --in CZ_LCE_HEADERS records for structure file of this component.

2722:
2723: --Build the MODEL_REF_EXPL_ID(COMPONENT_ID) hash table for all the components
2724: --inside this project (not inside referenced projects). All such components
2725: --have CHILD_MODEL_EXPL_ID null. We need this table to populate MODEL_REF_EXPL_ID
2726: --in CZ_LCE_HEADERS records for structure file of this component.
2727:
2728: IF(v_tChildModelExpl(i) IS NULL)THEN
2729: v_NodeIdByComponent(v_tPsNodeId(i)) := v_NodeId(i);
2730: END IF;