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_CONFIG_API_PVT dependencies on CZ_CONFIG_HDRS

Line 48: ( instance_hdr_id cz_config_hdrs.config_hdr_id%TYPE

44:
45: TYPE NUMBER_TBL_TYPE IS TABLE OF NUMBER INDEX BY VARCHAR2(15);-- Bug 6892148;
46:
47: TYPE instance_rec_type IS RECORD
48: ( instance_hdr_id cz_config_hdrs.config_hdr_id%TYPE
49: ,instance_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE
50: ,txn_flag VARCHAR2(1)
51: );
52:

Line 49: ,instance_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE

45: TYPE NUMBER_TBL_TYPE IS TABLE OF NUMBER INDEX BY VARCHAR2(15);-- Bug 6892148;
46:
47: TYPE instance_rec_type IS RECORD
48: ( instance_hdr_id cz_config_hdrs.config_hdr_id%TYPE
49: ,instance_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE
50: ,txn_flag VARCHAR2(1)
51: );
52:
53: TYPE instance_tbl_type IS TABLE of instance_rec_type INDEX BY PLS_INTEGER;

Line 55: TYPE config_hdr_tbl_type IS TABLE OF cz_config_hdrs%ROWTYPE INDEX BY PLS_INTEGER;

51: );
52:
53: TYPE instance_tbl_type IS TABLE of instance_rec_type INDEX BY PLS_INTEGER;
54:
55: TYPE config_hdr_tbl_type IS TABLE OF cz_config_hdrs%ROWTYPE INDEX BY PLS_INTEGER;
56: TYPE config_item_tbl_type IS TABLE OF cz_config_items%ROWTYPE INDEX BY PLS_INTEGER;
57: TYPE config_input_tbl_type IS TABLE OF cz_config_inputs%ROWTYPE INDEX BY PLS_INTEGER;
58: TYPE config_attr_tbl_type IS TABLE OF cz_config_attributes%ROWTYPE INDEX BY PLS_INTEGER;
59: TYPE config_extattr_tbl_type IS TABLE OF cz_config_ext_attributes%ROWTYPE INDEX BY PLS_INTEGER;

Line 69: SELECT cz_config_hdrs_s.NEXTVAL

65:
66: BEGIN
67: IF ((last_hdr_allocated IS NULL) OR
68: (next_hdr_to_use = last_hdr_allocated + id_increment)) THEN
69: SELECT cz_config_hdrs_s.NEXTVAL
70: INTO last_hdr_allocated
71: FROM dual;
72: next_hdr_to_use := last_hdr_allocated;
73: END IF;

Line 88: FROM CZ_CONFIG_HDRS

84: l_config_rev_nbr NUMBER;
85:
86: BEGIN
87: SELECT MAX(CONFIG_REV_NBR) + 1 INTO l_config_rev_nbr
88: FROM CZ_CONFIG_HDRS
89: WHERE CONFIG_HDR_ID = p_config_hdr_id;
90:
91: RETURN l_config_rev_nbr;
92:

Line 143: INSERT INTO CZ_CONFIG_HDRS

139: ,p_copy_mode IN VARCHAR2
140: )
141: IS
142: BEGIN
143: INSERT INTO CZ_CONFIG_HDRS
144: (CONFIG_HDR_ID
145: ,NAME
146: ,CONFIG_REV_NBR
147: ,COMPONENT_ID

Line 225: FROM CZ_CONFIG_HDRS

221: ,MODEL_POST_MIGR_CHG_FLAG
222: ,TO_BE_DELETED_FLAG
223: ,AUTO_COMPLETION_FLAG
224: ,CONFIG_ENGINE_TYPE
225: FROM CZ_CONFIG_HDRS
226: WHERE CONFIG_HDR_ID = p_old_config_hdr_id
227: AND CONFIG_REV_NBR = p_old_config_rev_nbr;
228:
229: EXCEPTION

Line 253: FROM cz_config_hdrs

249: l_instance_hdr_tbl config_hdr_tbl_type;
250:
251: BEGIN
252: SELECT * BULK COLLECT INTO l_instance_hdr_tbl
253: FROM cz_config_hdrs
254: WHERE deleted_flag = '0' AND (config_hdr_id, config_rev_nbr) IN
255: (SELECT instance_hdr_id, instance_rev_nbr
256: FROM cz_config_items
257: WHERE config_hdr_id = p_session_hdr_id AND config_rev_nbr = p_session_rev_nbr

Line 299: INSERT INTO cz_config_hdrs VALUES l_instance_hdr_tbl(i);

295: END IF;
296: END LOOP;
297:
298: FORALL i IN 1..l_instance_hdr_tbl.COUNT
299: INSERT INTO cz_config_hdrs VALUES l_instance_hdr_tbl(i);
300:
301: EXCEPTION
302: WHEN OTHERS THEN
303: RAISE;

Line 1119: l_model_instantiation_type cz_config_hdrs.model_instantiation_type%TYPE;

1115: IS
1116: l_api_version CONSTANT NUMBER := 1.0;
1117: l_api_name CONSTANT VARCHAR2(30) := 'copy_configuration';
1118:
1119: l_model_instantiation_type cz_config_hdrs.model_instantiation_type%TYPE;
1120: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;
1121: l_deleted_flag cz_config_hdrs.DELETED_FLAG%TYPE;
1122:
1123: -- lookup map of new instance hdr recs (id, rev), keyed by old instance_hdr_id

Line 1120: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;

1116: l_api_version CONSTANT NUMBER := 1.0;
1117: l_api_name CONSTANT VARCHAR2(30) := 'copy_configuration';
1118:
1119: l_model_instantiation_type cz_config_hdrs.model_instantiation_type%TYPE;
1120: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;
1121: l_deleted_flag cz_config_hdrs.DELETED_FLAG%TYPE;
1122:
1123: -- lookup map of new instance hdr recs (id, rev), keyed by old instance_hdr_id
1124: l_instance_hdr_map instance_tbl_type;

Line 1121: l_deleted_flag cz_config_hdrs.DELETED_FLAG%TYPE;

1117: l_api_name CONSTANT VARCHAR2(30) := 'copy_configuration';
1118:
1119: l_model_instantiation_type cz_config_hdrs.model_instantiation_type%TYPE;
1120: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;
1121: l_deleted_flag cz_config_hdrs.DELETED_FLAG%TYPE;
1122:
1123: -- lookup map of new instance hdr recs (id, rev), keyed by old instance_hdr_id
1124: l_instance_hdr_map instance_tbl_type;
1125:

Line 1163: FROM cz_config_hdrs

1159:
1160: BEGIN
1161: SELECT model_instantiation_type, component_instance_type, deleted_flag
1162: INTO l_model_instantiation_type, l_component_instance_type, l_deleted_flag
1163: FROM cz_config_hdrs
1164: WHERE config_hdr_id = p_config_hdr_id
1165: AND config_rev_nbr = p_config_rev_nbr;
1166:
1167: EXCEPTION

Line 1180: UPDATE CZ_CONFIG_HDRS SET DELETED_FLAG = '0'

1176: fnd_message.set_name('CZ', 'CZ_CFG_COPY_DELETED_CONFIG');
1177: fnd_msg_pub.add;
1178: RAISE FND_API.G_EXC_ERROR;
1179: ELSIF (p_handle_deleted_flag = '0') THEN
1180: UPDATE CZ_CONFIG_HDRS SET DELETED_FLAG = '0'
1181: WHERE CONFIG_HDR_ID = p_config_hdr_id
1182: AND CONFIG_REV_NBR = p_config_rev_nbr;
1183: END IF;
1184: END IF;

Line 1397: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;

1393: IS
1394: l_api_version CONSTANT NUMBER := 1.0;
1395: l_api_name CONSTANT VARCHAR2(30) := 'verify_configuration';
1396:
1397: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;
1398: l_config_status cz_config_hdrs.config_status%TYPE;
1399: l_dummy INTEGER;
1400:
1401: BEGIN

Line 1398: l_config_status cz_config_hdrs.config_status%TYPE;

1394: l_api_version CONSTANT NUMBER := 1.0;
1395: l_api_name CONSTANT VARCHAR2(30) := 'verify_configuration';
1396:
1397: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;
1398: l_config_status cz_config_hdrs.config_status%TYPE;
1399: l_dummy INTEGER;
1400:
1401: BEGIN
1402: IF (NOT FND_API.compatible_api_call(l_api_version

Line 1413: FROM cz_config_hdrs

1409:
1410: BEGIN
1411: SELECT component_instance_type, config_status
1412: INTO l_component_instance_type, l_config_status
1413: FROM cz_config_hdrs
1414: WHERE config_hdr_id = p_config_hdr_id
1415: AND config_rev_nbr = p_config_rev_nbr
1416: AND deleted_flag = '0';
1417: