APPS.CZ_CONFIG_API_PVT dependencies on CZ_CONFIG_MESSAGES

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

120:
121: BEGIN
122: IF ((last_msg_seq_allocated IS NULL) OR
123: (next_msg_seq_to_use = last_msg_seq_allocated + id_increment)) THEN
124: SELECT cz_config_messages_s.NEXTVAL INTO last_msg_seq_allocated FROM dual;
125: next_msg_seq_to_use := last_msg_seq_allocated;
126: END IF;
127:
128: l_msg_seq := next_msg_seq_to_use;

Line 1024: FOR msg_rec IN (SELECT * FROM cz_config_messages

1020: l_config_item_id NUMBER;
1021: l_message_seq NUMBER;
1022:
1023: BEGIN
1024: FOR msg_rec IN (SELECT * FROM cz_config_messages
1025: WHERE config_hdr_id = p_old_config_hdr_id
1026: AND config_rev_nbr = p_old_config_rev_nbr
1027: AND deleted_flag = '0'
1028: ORDER BY MESSAGE_SEQ)

Line 1050: INSERT INTO CZ_CONFIG_MESSAGES

1046: END IF;
1047:
1048: l_message_seq := get_next_msg_seq;
1049:
1050: INSERT INTO CZ_CONFIG_MESSAGES
1051: (MESSAGE_SEQ,
1052: CONFIG_HDR_ID,
1053: CONFIG_REV_NBR,
1054: CONSTRAINT_TYPE,

Line 1436: FROM cz_config_messages

1432: END IF;
1433:
1434: BEGIN
1435: SELECT 1 INTO l_dummy
1436: FROM cz_config_messages
1437: WHERE config_hdr_id = p_config_hdr_id
1438: AND config_rev_nbr = p_config_rev_nbr
1439: AND deleted_flag = '0'
1440: --vsingava 09th Dec '10. Bug10379808