APPS.CZ_CONFIG_API_PUB dependencies on CZ_CONFIG_MESSAGES

Line 107: SELECT cz_config_messages_s.NEXTVAL INTO last_msg_seq_allocated FROM dual;

103:
104: BEGIN
105: IF ((last_msg_seq_allocated IS NULL) OR
106: (next_msg_seq_to_use = last_msg_seq_allocated + id_increment)) THEN
107: SELECT cz_config_messages_s.NEXTVAL INTO last_msg_seq_allocated FROM dual;
108: next_msg_seq_to_use := last_msg_seq_allocated;
109: END IF;
110:
111: l_msg_seq := next_msg_seq_to_use;

Line 914: FOR msg_rec IN (SELECT * FROM cz_config_messages

910: l_config_item_id NUMBER;
911: l_message_seq NUMBER;
912:
913: BEGIN
914: FOR msg_rec IN (SELECT * FROM cz_config_messages
915: WHERE config_hdr_id = p_old_config_hdr_id
916: AND config_rev_nbr = p_old_config_rev_nbr
917: AND deleted_flag = '0'
918: ORDER BY MESSAGE_SEQ)

Line 940: INSERT INTO CZ_CONFIG_MESSAGES

936: END IF;
937:
938: l_message_seq := get_next_msg_seq;
939:
940: INSERT INTO CZ_CONFIG_MESSAGES
941: (MESSAGE_SEQ,
942: CONFIG_HDR_ID,
943: CONFIG_REV_NBR,
944: CONSTRAINT_TYPE,

Line 1314: FROM cz_config_messages

1310: END IF;
1311:
1312: BEGIN
1313: SELECT 1 INTO l_dummy
1314: FROM cz_config_messages
1315: WHERE config_hdr_id = p_config_hdr_id
1316: AND config_rev_nbr = p_config_rev_nbr
1317: AND deleted_flag = '0'
1318: AND ROWNUM < 2;