APPS.AR_CMGT_DNB_TABLE_HANDLER dependencies on AR_CMGT_DNB_ELEMENTS_B

Line 18: INSERT INTO AR_CMGT_DNB_ELEMENTS_B

14: p_return_data_type IN VARCHAR2,
15: p_return_date_format IN VARCHAR2
16: ) AS
17: BEGIN
18: INSERT INTO AR_CMGT_DNB_ELEMENTS_B
19: ( data_element_id,
20: scorable_flag,
21: source_table_name,
22: source_column_name,

Line 89: update ar_cmgt_dnb_elements_b

85: p_return_date_format IN VARCHAR2) AS
86:
87: BEGIN
88:
89: update ar_cmgt_dnb_elements_b
90: set scorable_flag = p_SCORABLE_FLAG,
91: source_table_name = p_source_table_name,
92: source_column_name = p_source_column_name,
93: last_update_date = sysdate,

Line 125: delete from ar_cmgt_dnb_elements_b

121: procedure DELETE_ROW (
122: p_data_element_id in NUMBER
123: ) is
124: begin
125: delete from ar_cmgt_dnb_elements_b
126: where data_element_id = p_data_element_id;
127:
128: if (sql%notfound) then
129: raise no_data_found;

Line 146: from ar_cmgt_dnb_elements_B B

142: begin
143: delete from ar_cmgt_dnb_elements_TL T
144: where not exists
145: (select NULL
146: from ar_cmgt_dnb_elements_B B
147: where B.data_element_id = T.data_element_id
148: );
149:
150: update ar_cmgt_dnb_elements_TL T set (