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

Line 31: ( instance_hdr_id cz_config_hdrs.config_hdr_id%TYPE

27:
28: TYPE NUMBER_TBL_TYPE IS TABLE OF NUMBER INDEX BY VARCHAR2(15);-- Bug 6892148;
29:
30: TYPE instance_rec_type IS RECORD
31: ( instance_hdr_id cz_config_hdrs.config_hdr_id%TYPE
32: ,instance_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE
33: ,txn_flag VARCHAR2(1)
34: );
35:

Line 32: ,instance_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE

28: TYPE NUMBER_TBL_TYPE IS TABLE OF NUMBER INDEX BY VARCHAR2(15);-- Bug 6892148;
29:
30: TYPE instance_rec_type IS RECORD
31: ( instance_hdr_id cz_config_hdrs.config_hdr_id%TYPE
32: ,instance_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE
33: ,txn_flag VARCHAR2(1)
34: );
35:
36: TYPE instance_tbl_type IS TABLE of instance_rec_type INDEX BY PLS_INTEGER;

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

34: );
35:
36: TYPE instance_tbl_type IS TABLE of instance_rec_type INDEX BY PLS_INTEGER;
37:
38: TYPE config_hdr_tbl_type IS TABLE OF cz_config_hdrs%ROWTYPE INDEX BY PLS_INTEGER;
39: TYPE config_item_tbl_type IS TABLE OF cz_config_items%ROWTYPE INDEX BY PLS_INTEGER;
40: TYPE config_input_tbl_type IS TABLE OF cz_config_inputs%ROWTYPE INDEX BY PLS_INTEGER;
41: TYPE config_attr_tbl_type IS TABLE OF cz_config_attributes%ROWTYPE INDEX BY PLS_INTEGER;
42: TYPE config_extattr_tbl_type IS TABLE OF cz_config_ext_attributes%ROWTYPE INDEX BY PLS_INTEGER;

Line 52: SELECT cz_config_hdrs_s.NEXTVAL

48:
49: BEGIN
50: IF ((last_hdr_allocated IS NULL) OR
51: (next_hdr_to_use = last_hdr_allocated + id_increment)) THEN
52: SELECT cz_config_hdrs_s.NEXTVAL
53: INTO last_hdr_allocated
54: FROM dual;
55: next_hdr_to_use := last_hdr_allocated;
56: END IF;

Line 71: FROM CZ_CONFIG_HDRS

67: l_config_rev_nbr NUMBER;
68:
69: BEGIN
70: SELECT MAX(CONFIG_REV_NBR) + 1 INTO l_config_rev_nbr
71: FROM CZ_CONFIG_HDRS
72: WHERE CONFIG_HDR_ID = p_config_hdr_id;
73:
74: RETURN l_config_rev_nbr;
75:

Line 126: INSERT INTO CZ_CONFIG_HDRS

122: ,p_copy_mode IN VARCHAR2
123: )
124: IS
125: BEGIN
126: INSERT INTO CZ_CONFIG_HDRS
127: (CONFIG_HDR_ID
128: ,NAME
129: ,CONFIG_REV_NBR
130: ,COMPONENT_ID

Line 208: FROM CZ_CONFIG_HDRS

204: ,MODEL_POST_MIGR_CHG_FLAG
205: ,TO_BE_DELETED_FLAG
206: ,AUTO_COMPLETION_FLAG
207: ,CONFIG_ENGINE_TYPE
208: FROM CZ_CONFIG_HDRS
209: WHERE CONFIG_HDR_ID = p_old_config_hdr_id
210: AND CONFIG_REV_NBR = p_old_config_rev_nbr;
211:
212: EXCEPTION

Line 234: FROM cz_config_hdrs

230: l_instance_hdr_tbl config_hdr_tbl_type;
231:
232: BEGIN
233: SELECT * BULK COLLECT INTO l_instance_hdr_tbl
234: FROM cz_config_hdrs
235: WHERE deleted_flag = '0' AND (config_hdr_id, config_rev_nbr) IN
236: (SELECT instance_hdr_id, instance_rev_nbr
237: FROM cz_config_items
238: WHERE config_hdr_id = p_session_hdr_id AND config_rev_nbr = p_session_rev_nbr

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

276: END IF;
277: END LOOP;
278:
279: FORALL i IN 1..l_instance_hdr_tbl.COUNT
280: INSERT INTO cz_config_hdrs VALUES l_instance_hdr_tbl(i);
281:
282: EXCEPTION
283: WHEN OTHERS THEN
284: RAISE;

Line 1007: l_model_instantiation_type cz_config_hdrs.model_instantiation_type%TYPE;

1003: IS
1004: l_api_version CONSTANT NUMBER := 1.0;
1005: l_api_name CONSTANT VARCHAR2(30) := 'copy_configuration';
1006:
1007: l_model_instantiation_type cz_config_hdrs.model_instantiation_type%TYPE;
1008: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;
1009: l_deleted_flag cz_config_hdrs.DELETED_FLAG%TYPE;
1010:
1011: -- lookup map of new instance hdr recs (id, rev), keyed by old instance_hdr_id

Line 1008: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;

1004: l_api_version CONSTANT NUMBER := 1.0;
1005: l_api_name CONSTANT VARCHAR2(30) := 'copy_configuration';
1006:
1007: l_model_instantiation_type cz_config_hdrs.model_instantiation_type%TYPE;
1008: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;
1009: l_deleted_flag cz_config_hdrs.DELETED_FLAG%TYPE;
1010:
1011: -- lookup map of new instance hdr recs (id, rev), keyed by old instance_hdr_id
1012: l_instance_hdr_map instance_tbl_type;

Line 1009: l_deleted_flag cz_config_hdrs.DELETED_FLAG%TYPE;

1005: l_api_name CONSTANT VARCHAR2(30) := 'copy_configuration';
1006:
1007: l_model_instantiation_type cz_config_hdrs.model_instantiation_type%TYPE;
1008: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;
1009: l_deleted_flag cz_config_hdrs.DELETED_FLAG%TYPE;
1010:
1011: -- lookup map of new instance hdr recs (id, rev), keyed by old instance_hdr_id
1012: l_instance_hdr_map instance_tbl_type;
1013:

Line 1051: FROM cz_config_hdrs

1047:
1048: BEGIN
1049: SELECT model_instantiation_type, component_instance_type, deleted_flag
1050: INTO l_model_instantiation_type, l_component_instance_type, l_deleted_flag
1051: FROM cz_config_hdrs
1052: WHERE config_hdr_id = p_config_hdr_id
1053: AND config_rev_nbr = p_config_rev_nbr;
1054:
1055: EXCEPTION

Line 1068: UPDATE CZ_CONFIG_HDRS SET DELETED_FLAG = '0'

1064: fnd_message.set_name('CZ', 'CZ_CFG_COPY_DELETED_CONFIG');
1065: fnd_msg_pub.add;
1066: RAISE FND_API.G_EXC_ERROR;
1067: ELSIF (p_handle_deleted_flag = '0') THEN
1068: UPDATE CZ_CONFIG_HDRS SET DELETED_FLAG = '0'
1069: WHERE CONFIG_HDR_ID = p_config_hdr_id
1070: AND CONFIG_REV_NBR = p_config_rev_nbr;
1071: END IF;
1072: END IF;

Line 1275: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;

1271: IS
1272: l_api_version CONSTANT NUMBER := 1.0;
1273: l_api_name CONSTANT VARCHAR2(30) := 'verify_configuration';
1274:
1275: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;
1276: l_config_status cz_config_hdrs.config_status%TYPE;
1277: l_dummy INTEGER;
1278:
1279: BEGIN

Line 1276: l_config_status cz_config_hdrs.config_status%TYPE;

1272: l_api_version CONSTANT NUMBER := 1.0;
1273: l_api_name CONSTANT VARCHAR2(30) := 'verify_configuration';
1274:
1275: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;
1276: l_config_status cz_config_hdrs.config_status%TYPE;
1277: l_dummy INTEGER;
1278:
1279: BEGIN
1280: IF (NOT FND_API.compatible_api_call(l_api_version

Line 1291: FROM cz_config_hdrs

1287:
1288: BEGIN
1289: SELECT component_instance_type, config_status
1290: INTO l_component_instance_type, l_config_status
1291: FROM cz_config_hdrs
1292: WHERE config_hdr_id = p_config_hdr_id
1293: AND config_rev_nbr = p_config_rev_nbr
1294: AND deleted_flag = '0';
1295: