APPS.AR_CMGT_CONTROLS dependencies on AR_CMGT_CF_DTLS_S
Line 79: SELECT ar_cmgt_cf_dtls_s.nextval
75: x_errmsg := 'Incorrect Date Format for Data Point Id :'||p_data_point_id;
76: return;
77: END;
78: 79: SELECT ar_cmgt_cf_dtls_s.nextval 80: INTO p_case_folder_detail_id
81: FROM dual;
82:
83: INSERT INTO ar_cmgt_cf_dtls
Line 737: SELECT ar_cmgt_cf_dtls_s.NEXTVAL
733: FOR select_dtls_rec IN select_dtls
734: LOOP
735: BEGIN
736: 737: SELECT ar_cmgt_cf_dtls_s.NEXTVAL 738: INTO l_seq_num
739: FROM dual;
740:
741: --store the parent_rec_id and corrosponding seq_num_id