APPS.AP_WEB_DB_EXPDIST_PKG dependencies on AP_EXP_REPORT_DISTS_S

Line 303: AP_EXP_REPORT_DISTS_S.NEXTVAL AS report_distribution_id,

299: )
300: SELECT
301: p_target_report_header_id AS report_header_id,
302: p_target_report_line_id AS report_line_id,
303: AP_EXP_REPORT_DISTS_S.NEXTVAL AS report_distribution_id,
304: org_id,
305: sequence_num,
306: SYSDATE AS last_update_date,
307: nvl(p_user_id,last_updated_by) AS last_updated_by,

Line 811: AP_EXP_REPORT_DISTS_S.NEXTVAL,

807: )
808: SELECT
809: XL.report_header_id,
810: XL.report_line_id,
811: AP_EXP_REPORT_DISTS_S.NEXTVAL,
812: l_sequence_num,
813: SYSDATE,
814: XL.last_updated_by,
815: SYSDATE,

Line 1000: l_debug_info := 'get next AP_EXP_REPORT_DISTS_S';

996: WHERE XL.report_line_id = p_report_line_id
997: AND XL.report_header_id = XH.report_header_id;
998:
999: -----------------------------------------------------
1000: l_debug_info := 'get next AP_EXP_REPORT_DISTS_S';
1001: -----------------------------------------------------
1002: SELECT AP_EXP_REPORT_DISTS_S.NEXTVAL
1003: INTO l_report_distribution_id
1004: FROM DUAL;

Line 1002: SELECT AP_EXP_REPORT_DISTS_S.NEXTVAL

998:
999: -----------------------------------------------------
1000: l_debug_info := 'get next AP_EXP_REPORT_DISTS_S';
1001: -----------------------------------------------------
1002: SELECT AP_EXP_REPORT_DISTS_S.NEXTVAL
1003: INTO l_report_distribution_id
1004: FROM DUAL;
1005:
1006: l_sqlstmt := 'INSERT INTO AP_EXP_REPORT_DISTS ( ';