DBA Data[Home] [Help]

APPS.AP_WEB_DB_EXPDIST_PKG dependencies on AP_EXP_REPORT_DISTS_S

Line 302: AP_EXP_REPORT_DISTS_S.NEXTVAL AS report_distribution_id,

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

Line 803: AP_EXP_REPORT_DISTS_S.NEXTVAL,

799: )
800: SELECT
801: XL.report_header_id,
802: XL.report_line_id,
803: AP_EXP_REPORT_DISTS_S.NEXTVAL,
804: l_sequence_num,
805: SYSDATE,
806: XL.last_updated_by,
807: SYSDATE,

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

964: WHERE XL.report_line_id = p_report_line_id
965: AND XL.report_header_id = XH.report_header_id;
966:
967: -----------------------------------------------------
968: l_debug_info := 'get next AP_EXP_REPORT_DISTS_S';
969: -----------------------------------------------------
970: SELECT AP_EXP_REPORT_DISTS_S.NEXTVAL
971: INTO l_report_distribution_id
972: FROM DUAL;

Line 970: SELECT AP_EXP_REPORT_DISTS_S.NEXTVAL

966:
967: -----------------------------------------------------
968: l_debug_info := 'get next AP_EXP_REPORT_DISTS_S';
969: -----------------------------------------------------
970: SELECT AP_EXP_REPORT_DISTS_S.NEXTVAL
971: INTO l_report_distribution_id
972: FROM DUAL;
973:
974: l_sqlstmt := 'INSERT INTO AP_EXP_REPORT_DISTS ( ';