APPS.AR_CMGT_DP_TABLE_HANDLER dependencies on AR_CMGT_DATA_POINTS_B

Line 26: INSERT INTO AR_CMGT_DATA_POINTS_B

22: p_data_point_sub_category IN VARCHAR2,
23: p_data_point_code IN VARCHAR2
24: ) AS
25: BEGIN
26: INSERT INTO AR_CMGT_DATA_POINTS_B
27: ( data_point_id,
28: data_point_category,
29: user_defined_flag,
30: scorable_flag,

Line 124: INSERT INTO AR_CMGT_DATA_POINTS_B

120: p_return_date_format IN VARCHAR2)
121: IS
122: BEGIN
123:
124: INSERT INTO AR_CMGT_DATA_POINTS_B
125: ( data_point_id,
126: data_point_sub_category,
127: data_point_category,
128: user_defined_flag,

Line 224: update ar_cmgt_data_points_b

220: p_data_point_code IN VARCHAR2) AS
221:
222: BEGIN
223:
224: update ar_cmgt_data_points_b
225: set data_point_category = p_data_point_category,
226: user_defined_flag = p_USER_DEFINED_FLAG,
227: scorable_flag = p_SCORABLE_FLAG,
228: display_on_checklist_flag = p_DISPLAY_ON_CHECKLIST,

Line 283: update ar_cmgt_data_points_b

279: p_last_updated_by IN NUMBER,
280: p_last_update_login IN NUMBER )
281: IS
282: BEGIN
283: update ar_cmgt_data_points_b
284: set scorable_flag = p_SCORABLE_FLAG,
285: last_update_date = sysdate,
286: application_id = p_application_id,
287: data_point_sub_category = p_data_point_sub_category,

Line 323: delete from ar_cmgt_data_points_b

319: procedure DELETE_ROW (
320: p_data_point_id in NUMBER
321: ) is
322: begin
323: delete from ar_cmgt_data_points_b
324: where data_point_id = p_data_point_id;
325:
326: if (sql%notfound) then
327: raise no_data_found;

Line 344: from AR_CMGT_DATA_POINTS_B B

340: begin
341: delete from AR_CMGT_DATA_POINTS_TL T
342: where not exists
343: (select NULL
344: from AR_CMGT_DATA_POINTS_B B
345: where B.DATA_POINT_ID = T.DATA_POINT_ID
346: );
347:
348: update AR_CMGT_DATA_POINTS_TL T set (

Line 509: where data_point_id = (SELECT data_point_id from ar_cmgt_data_points_b

505: data_point_name = p_data_point_name,
506: source_lang = userenv('LANG'),
507: last_update_date = sysdate,
508: last_updated_by = decode(P_OWNER, 'SEED', 1, 0)
509: where data_point_id = (SELECT data_point_id from ar_cmgt_data_points_b
510: where data_point_code = p_data_point_code
511: and application_id = p_application_id )
512: and application_id = p_application_id
513: and userenv('LANG') in (language, source_lang);

Line 550: FROM ar_cmgt_data_points_b

546: THEN
547: BEGIN
548: SELECT data_point_id
549: INTO l_parent_data_point_id
550: FROM ar_cmgt_data_points_b
551: WHERE data_point_code = p_parent_data_point_code
552: AND application_id = p_application_id;
553:
554: EXCEPTION

Line 562: FROM ar_cmgt_data_points_b

558: END IF;
559: BEGIN
560: SELECT DATA_POINT_ID
561: INTO l_data_point_id
562: FROM ar_cmgt_data_points_b
563: WHERE data_point_code = p_data_point_code
564: AND application_id = p_application_id;
565:
566: update_adp_row(