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_LOAD_SPECS

Line 1075: FROM cz_lce_load_specs

1071: v_count PLS_INTEGER := 0;
1072: BEGIN
1073: SELECT count(*)
1074: INTO v_count
1075: FROM cz_lce_load_specs
1076: WHERE cz_lce_load_specs.lce_header_id = p_lce_header_id
1077: AND cz_lce_load_specs.deleted_flag = '0';
1078:
1079: IF (v_count > 0) THEN

Line 1076: WHERE cz_lce_load_specs.lce_header_id = p_lce_header_id

1072: BEGIN
1073: SELECT count(*)
1074: INTO v_count
1075: FROM cz_lce_load_specs
1076: WHERE cz_lce_load_specs.lce_header_id = p_lce_header_id
1077: AND cz_lce_load_specs.deleted_flag = '0';
1078:
1079: IF (v_count > 0) THEN
1080: SELECT count(*)

Line 1077: AND cz_lce_load_specs.deleted_flag = '0';

1073: SELECT count(*)
1074: INTO v_count
1075: FROM cz_lce_load_specs
1076: WHERE cz_lce_load_specs.lce_header_id = p_lce_header_id
1077: AND cz_lce_load_specs.deleted_flag = '0';
1078:
1079: IF (v_count > 0) THEN
1080: SELECT count(*)
1081: INTO v_count

Line 1082: FROM cz_lce_load_specs

1078:
1079: IF (v_count > 0) THEN
1080: SELECT count(*)
1081: INTO v_count
1082: FROM cz_lce_load_specs
1083: WHERE cz_lce_load_specs.lce_header_id = p_lce_header_id
1084: AND cz_lce_load_specs.attachment_expl_id > 0
1085: AND cz_lce_load_specs.required_expl_id > 0
1086: AND cz_lce_load_specs.attachment_comp_id > 0

Line 1083: WHERE cz_lce_load_specs.lce_header_id = p_lce_header_id

1079: IF (v_count > 0) THEN
1080: SELECT count(*)
1081: INTO v_count
1082: FROM cz_lce_load_specs
1083: WHERE cz_lce_load_specs.lce_header_id = p_lce_header_id
1084: AND cz_lce_load_specs.attachment_expl_id > 0
1085: AND cz_lce_load_specs.required_expl_id > 0
1086: AND cz_lce_load_specs.attachment_comp_id > 0
1087: AND cz_lce_load_specs.model_id > 0

Line 1084: AND cz_lce_load_specs.attachment_expl_id > 0

1080: SELECT count(*)
1081: INTO v_count
1082: FROM cz_lce_load_specs
1083: WHERE cz_lce_load_specs.lce_header_id = p_lce_header_id
1084: AND cz_lce_load_specs.attachment_expl_id > 0
1085: AND cz_lce_load_specs.required_expl_id > 0
1086: AND cz_lce_load_specs.attachment_comp_id > 0
1087: AND cz_lce_load_specs.model_id > 0
1088: AND cz_lce_load_specs.net_type > 0

Line 1085: AND cz_lce_load_specs.required_expl_id > 0

1081: INTO v_count
1082: FROM cz_lce_load_specs
1083: WHERE cz_lce_load_specs.lce_header_id = p_lce_header_id
1084: AND cz_lce_load_specs.attachment_expl_id > 0
1085: AND cz_lce_load_specs.required_expl_id > 0
1086: AND cz_lce_load_specs.attachment_comp_id > 0
1087: AND cz_lce_load_specs.model_id > 0
1088: AND cz_lce_load_specs.net_type > 0
1089: AND cz_lce_load_specs.deleted_flag = '0';

Line 1086: AND cz_lce_load_specs.attachment_comp_id > 0

1082: FROM cz_lce_load_specs
1083: WHERE cz_lce_load_specs.lce_header_id = p_lce_header_id
1084: AND cz_lce_load_specs.attachment_expl_id > 0
1085: AND cz_lce_load_specs.required_expl_id > 0
1086: AND cz_lce_load_specs.attachment_comp_id > 0
1087: AND cz_lce_load_specs.model_id > 0
1088: AND cz_lce_load_specs.net_type > 0
1089: AND cz_lce_load_specs.deleted_flag = '0';
1090:

Line 1087: AND cz_lce_load_specs.model_id > 0

1083: WHERE cz_lce_load_specs.lce_header_id = p_lce_header_id
1084: AND cz_lce_load_specs.attachment_expl_id > 0
1085: AND cz_lce_load_specs.required_expl_id > 0
1086: AND cz_lce_load_specs.attachment_comp_id > 0
1087: AND cz_lce_load_specs.model_id > 0
1088: AND cz_lce_load_specs.net_type > 0
1089: AND cz_lce_load_specs.deleted_flag = '0';
1090:
1091: IF (v_count = 0) THEN

Line 1088: AND cz_lce_load_specs.net_type > 0

1084: AND cz_lce_load_specs.attachment_expl_id > 0
1085: AND cz_lce_load_specs.required_expl_id > 0
1086: AND cz_lce_load_specs.attachment_comp_id > 0
1087: AND cz_lce_load_specs.model_id > 0
1088: AND cz_lce_load_specs.net_type > 0
1089: AND cz_lce_load_specs.deleted_flag = '0';
1090:
1091: IF (v_count = 0) THEN
1092: update cz_lce_load_specs

Line 1089: AND cz_lce_load_specs.deleted_flag = '0';

1085: AND cz_lce_load_specs.required_expl_id > 0
1086: AND cz_lce_load_specs.attachment_comp_id > 0
1087: AND cz_lce_load_specs.model_id > 0
1088: AND cz_lce_load_specs.net_type > 0
1089: AND cz_lce_load_specs.deleted_flag = '0';
1090:
1091: IF (v_count = 0) THEN
1092: update cz_lce_load_specs
1093: set deleted_flag = '1'

Line 1092: update cz_lce_load_specs

1088: AND cz_lce_load_specs.net_type > 0
1089: AND cz_lce_load_specs.deleted_flag = '0';
1090:
1091: IF (v_count = 0) THEN
1092: update cz_lce_load_specs
1093: set deleted_flag = '1'
1094: where cz_lce_load_specs.lce_header_id = p_lce_header_id
1095: and cz_lce_load_specs.deleted_flag = '0';
1096: commit;

Line 1094: where cz_lce_load_specs.lce_header_id = p_lce_header_id

1090:
1091: IF (v_count = 0) THEN
1092: update cz_lce_load_specs
1093: set deleted_flag = '1'
1094: where cz_lce_load_specs.lce_header_id = p_lce_header_id
1095: and cz_lce_load_specs.deleted_flag = '0';
1096: commit;
1097: RETURN TRUE;
1098: ELSE

Line 1095: and cz_lce_load_specs.deleted_flag = '0';

1091: IF (v_count = 0) THEN
1092: update cz_lce_load_specs
1093: set deleted_flag = '1'
1094: where cz_lce_load_specs.lce_header_id = p_lce_header_id
1095: and cz_lce_load_specs.deleted_flag = '0';
1096: commit;
1097: RETURN TRUE;
1098: ELSE
1099: RETURN FALSE;

Line 1241: ---------procedure that inserts LCE data into cz_lce_load_specs table

1237: x_err_message := substr(SQLERRM,1,2000);
1238: RAISE;
1239: END get_lce_headers;
1240: ---------------------------------------------
1241: ---------procedure that inserts LCE data into cz_lce_load_specs table
1242: ---------
1243: PROCEDURE cz_populate_lce_load_specs(p_lce_header_id IN NUMBER,
1244: x_populate_error_flag IN OUT NOCOPY VARCHAR2,
1245: x_populate_error_msg IN OUT NOCOPY VARCHAR2)

Line 1347: insert into cz_lce_load_specs ( ATTACHMENT_EXPL_ID

1343: END IF; /* end if of net_type */
1344: END IF; /* end if of p_lce_header_id is not null */
1345:
1346: BEGIN
1347: insert into cz_lce_load_specs ( ATTACHMENT_EXPL_ID
1348: ,LCE_HEADER_ID
1349: ,REQUIRED_EXPL_ID
1350: ,ATTACHMENT_COMP_ID
1351: ,MODEL_ID

Line 1493: FROM cz_lce_load_specs

1489: SELECT distinct attachment_expl_id
1490: BULK
1491: COLLECT
1492: INTO v_attachment_expl_id_tbl
1493: FROM cz_lce_load_specs
1494: WHERE cz_lce_load_specs.lce_header_id = v_all_lce_headers(allLceHeader)
1495: AND cz_lce_load_specs.deleted_flag = '0';
1496: EXCEPTION
1497: WHEN NO_DATA_FOUND THEN

Line 1494: WHERE cz_lce_load_specs.lce_header_id = v_all_lce_headers(allLceHeader)

1490: BULK
1491: COLLECT
1492: INTO v_attachment_expl_id_tbl
1493: FROM cz_lce_load_specs
1494: WHERE cz_lce_load_specs.lce_header_id = v_all_lce_headers(allLceHeader)
1495: AND cz_lce_load_specs.deleted_flag = '0';
1496: EXCEPTION
1497: WHEN NO_DATA_FOUND THEN
1498: x_error_msg := 'No attachment expl id found in cz_lce_load_specs for lce_header_id '||v_all_lce_headers(allLceHeader);

Line 1495: AND cz_lce_load_specs.deleted_flag = '0';

1491: COLLECT
1492: INTO v_attachment_expl_id_tbl
1493: FROM cz_lce_load_specs
1494: WHERE cz_lce_load_specs.lce_header_id = v_all_lce_headers(allLceHeader)
1495: AND cz_lce_load_specs.deleted_flag = '0';
1496: EXCEPTION
1497: WHEN NO_DATA_FOUND THEN
1498: x_error_msg := 'No attachment expl id found in cz_lce_load_specs for lce_header_id '||v_all_lce_headers(allLceHeader);
1499: report_upgrade_logic_errors(NULL,NULL,v_all_lce_headers(allLceHeader),x_error_msg,'VERIFY_LOGIC');

Line 1498: x_error_msg := 'No attachment expl id found in cz_lce_load_specs for lce_header_id '||v_all_lce_headers(allLceHeader);

1494: WHERE cz_lce_load_specs.lce_header_id = v_all_lce_headers(allLceHeader)
1495: AND cz_lce_load_specs.deleted_flag = '0';
1496: EXCEPTION
1497: WHEN NO_DATA_FOUND THEN
1498: x_error_msg := 'No attachment expl id found in cz_lce_load_specs for lce_header_id '||v_all_lce_headers(allLceHeader);
1499: report_upgrade_logic_errors(NULL,NULL,v_all_lce_headers(allLceHeader),x_error_msg,'VERIFY_LOGIC');
1500: WHEN OTHERS THEN
1501: x_error_status := -1;
1502: x_error_msg := 'Error in retrieving attachment expl id from cz_load_specs for lce_header_id '||v_all_lce_headers(allLceHeader)||' '||SQLERRM;

Line 1512: FROM cz_lce_load_specs

1508: SELECT distinct net_type
1509: BULK
1510: COLLECT
1511: INTO v_net_type_tbl
1512: FROM cz_lce_load_specs
1513: WHERE cz_lce_load_specs.lce_header_id = v_all_lce_headers(allLceHeader)
1514: AND cz_lce_load_specs.deleted_flag = '0';
1515: EXCEPTION
1516: WHEN NO_DATA_FOUND THEN

Line 1513: WHERE cz_lce_load_specs.lce_header_id = v_all_lce_headers(allLceHeader)

1509: BULK
1510: COLLECT
1511: INTO v_net_type_tbl
1512: FROM cz_lce_load_specs
1513: WHERE cz_lce_load_specs.lce_header_id = v_all_lce_headers(allLceHeader)
1514: AND cz_lce_load_specs.deleted_flag = '0';
1515: EXCEPTION
1516: WHEN NO_DATA_FOUND THEN
1517: x_error_msg := 'No net_type found in cz_lce_load_specs for lce_header_id '||v_all_lce_headers(allLceHeader);

Line 1514: AND cz_lce_load_specs.deleted_flag = '0';

1510: COLLECT
1511: INTO v_net_type_tbl
1512: FROM cz_lce_load_specs
1513: WHERE cz_lce_load_specs.lce_header_id = v_all_lce_headers(allLceHeader)
1514: AND cz_lce_load_specs.deleted_flag = '0';
1515: EXCEPTION
1516: WHEN NO_DATA_FOUND THEN
1517: x_error_msg := 'No net_type found in cz_lce_load_specs for lce_header_id '||v_all_lce_headers(allLceHeader);
1518: report_upgrade_logic_errors(NULL,NULL,v_all_lce_headers(allLceHeader),x_error_msg,'VERIFY_LOGIC');

Line 1517: x_error_msg := 'No net_type found in cz_lce_load_specs for lce_header_id '||v_all_lce_headers(allLceHeader);

1513: WHERE cz_lce_load_specs.lce_header_id = v_all_lce_headers(allLceHeader)
1514: AND cz_lce_load_specs.deleted_flag = '0';
1515: EXCEPTION
1516: WHEN NO_DATA_FOUND THEN
1517: x_error_msg := 'No net_type found in cz_lce_load_specs for lce_header_id '||v_all_lce_headers(allLceHeader);
1518: report_upgrade_logic_errors(NULL,NULL,v_all_lce_headers(allLceHeader),x_error_msg,'VERIFY_LOGIC');
1519: WHEN OTHERS THEN
1520: x_error_status := -1;
1521: x_error_msg := 'Error in retrieving net type from cz_load_specs for lce_header_id '||v_all_lce_headers(allLceHeader)||' '||SQLERRM;

Line 1547: FROM cz_lce_load_specs

1543: SELECT distinct required_expl_id
1544: BULK
1545: COLLECT
1546: INTO v_required_expl_tbl
1547: FROM cz_lce_load_specs
1548: WHERE cz_lce_load_specs.lce_header_id = v_all_lce_headers(allLceHeader)
1549: AND cz_lce_load_specs.deleted_flag = '0';
1550: EXCEPTION
1551: WHEN NO_DATA_FOUND THEN

Line 1548: WHERE cz_lce_load_specs.lce_header_id = v_all_lce_headers(allLceHeader)

1544: BULK
1545: COLLECT
1546: INTO v_required_expl_tbl
1547: FROM cz_lce_load_specs
1548: WHERE cz_lce_load_specs.lce_header_id = v_all_lce_headers(allLceHeader)
1549: AND cz_lce_load_specs.deleted_flag = '0';
1550: EXCEPTION
1551: WHEN NO_DATA_FOUND THEN
1552: x_error_msg := 'No required_expl_id found in cz_lce_load_specs for lce_header_id '||v_all_lce_headers(allLceHeader);

Line 1549: AND cz_lce_load_specs.deleted_flag = '0';

1545: COLLECT
1546: INTO v_required_expl_tbl
1547: FROM cz_lce_load_specs
1548: WHERE cz_lce_load_specs.lce_header_id = v_all_lce_headers(allLceHeader)
1549: AND cz_lce_load_specs.deleted_flag = '0';
1550: EXCEPTION
1551: WHEN NO_DATA_FOUND THEN
1552: x_error_msg := 'No required_expl_id found in cz_lce_load_specs for lce_header_id '||v_all_lce_headers(allLceHeader);
1553: report_upgrade_logic_errors(NULL,NULL,v_all_lce_headers(allLceHeader),x_error_msg,'VERIFY_LOGIC');

Line 1552: x_error_msg := 'No required_expl_id found in cz_lce_load_specs for lce_header_id '||v_all_lce_headers(allLceHeader);

1548: WHERE cz_lce_load_specs.lce_header_id = v_all_lce_headers(allLceHeader)
1549: AND cz_lce_load_specs.deleted_flag = '0';
1550: EXCEPTION
1551: WHEN NO_DATA_FOUND THEN
1552: x_error_msg := 'No required_expl_id found in cz_lce_load_specs for lce_header_id '||v_all_lce_headers(allLceHeader);
1553: report_upgrade_logic_errors(NULL,NULL,v_all_lce_headers(allLceHeader),x_error_msg,'VERIFY_LOGIC');
1554: WHEN OTHERS THEN
1555: x_error_status := -1;
1556: x_error_msg := 'Error in retrieving required_expl_id from cz_load_specs for lce_header_id '||v_all_lce_headers(allLceHeader)||' '||SQLERRM;

Line 1566: FROM cz_lce_load_specs

1562: LOOP
1563: BEGIN
1564: SELECT attachment_expl_id
1565: INTO v_attachment_expl_id
1566: FROM cz_lce_load_specs
1567: WHERE cz_lce_load_specs.required_expl_id = v_required_expl_tbl(reqdExplId)
1568: AND cz_lce_load_specs.lce_header_id = v_all_lce_headers(allLceHeader)
1569: AND cz_lce_load_specs.deleted_flag = '0';
1570: EXCEPTION

Line 1567: WHERE cz_lce_load_specs.required_expl_id = v_required_expl_tbl(reqdExplId)

1563: BEGIN
1564: SELECT attachment_expl_id
1565: INTO v_attachment_expl_id
1566: FROM cz_lce_load_specs
1567: WHERE cz_lce_load_specs.required_expl_id = v_required_expl_tbl(reqdExplId)
1568: AND cz_lce_load_specs.lce_header_id = v_all_lce_headers(allLceHeader)
1569: AND cz_lce_load_specs.deleted_flag = '0';
1570: EXCEPTION
1571: WHEN NO_DATA_FOUND THEN

Line 1568: AND cz_lce_load_specs.lce_header_id = v_all_lce_headers(allLceHeader)

1564: SELECT attachment_expl_id
1565: INTO v_attachment_expl_id
1566: FROM cz_lce_load_specs
1567: WHERE cz_lce_load_specs.required_expl_id = v_required_expl_tbl(reqdExplId)
1568: AND cz_lce_load_specs.lce_header_id = v_all_lce_headers(allLceHeader)
1569: AND cz_lce_load_specs.deleted_flag = '0';
1570: EXCEPTION
1571: WHEN NO_DATA_FOUND THEN
1572: x_error_msg := 'No attachment expl id found in cz_lce_load_specs for lce_header_id '||v_all_lce_headers(allLceHeader)||' and required_expl_id '||v_required_expl_tbl(reqdExplId);

Line 1569: AND cz_lce_load_specs.deleted_flag = '0';

1565: INTO v_attachment_expl_id
1566: FROM cz_lce_load_specs
1567: WHERE cz_lce_load_specs.required_expl_id = v_required_expl_tbl(reqdExplId)
1568: AND cz_lce_load_specs.lce_header_id = v_all_lce_headers(allLceHeader)
1569: AND cz_lce_load_specs.deleted_flag = '0';
1570: EXCEPTION
1571: WHEN NO_DATA_FOUND THEN
1572: x_error_msg := 'No attachment expl id found in cz_lce_load_specs for lce_header_id '||v_all_lce_headers(allLceHeader)||' and required_expl_id '||v_required_expl_tbl(reqdExplId);
1573: report_upgrade_logic_errors(NULL,NULL,v_all_lce_headers(allLceHeader),x_error_msg,'VERIFY_LOGIC');

Line 1572: x_error_msg := 'No attachment expl id found in cz_lce_load_specs for lce_header_id '||v_all_lce_headers(allLceHeader)||' and required_expl_id '||v_required_expl_tbl(reqdExplId);

1568: AND cz_lce_load_specs.lce_header_id = v_all_lce_headers(allLceHeader)
1569: AND cz_lce_load_specs.deleted_flag = '0';
1570: EXCEPTION
1571: WHEN NO_DATA_FOUND THEN
1572: x_error_msg := 'No attachment expl id found in cz_lce_load_specs for lce_header_id '||v_all_lce_headers(allLceHeader)||' and required_expl_id '||v_required_expl_tbl(reqdExplId);
1573: report_upgrade_logic_errors(NULL,NULL,v_all_lce_headers(allLceHeader),x_error_msg,'VERIFY_LOGIC');
1574: WHEN OTHERS THEN
1575: x_error_status := -1;
1576: x_error_msg := 'Error in retrieving attachment expl id from cz_load_specs for lce_header_id '||v_all_lce_headers(allLceHeader)||' '||SQLERRM;