APPS.AP_WEB_DB_EXPDIST_PKG dependencies on AP_WEB_DB_EXPLINE_PKG

Line 707: c_line_ccid_cursor AP_WEB_DB_EXPLINE_PKG.ExpLineCCIDCursor;

703: p_report_header_id IN expDist_report_header_ID)
704: IS
705: --------------------------------------------------------------------------------
706: l_report_distribution_id expDist_REPORT_DISTRIBUTION_ID;
707: c_line_ccid_cursor AP_WEB_DB_EXPLINE_PKG.ExpLineCCIDCursor;
708: l_report_line_id AP_WEB_DB_EXPLINE_PKG.expLines_report_line_id;
709: l_line_ccid AP_WEB_DB_EXPLINE_PKG.expLines_codeCombID;
710: l_dist_id AP_EXP_REPORT_DISTS.REPORT_DISTRIBUTION_ID%TYPE;
711: l_line_amount NUMBER;

Line 708: l_report_line_id AP_WEB_DB_EXPLINE_PKG.expLines_report_line_id;

704: IS
705: --------------------------------------------------------------------------------
706: l_report_distribution_id expDist_REPORT_DISTRIBUTION_ID;
707: c_line_ccid_cursor AP_WEB_DB_EXPLINE_PKG.ExpLineCCIDCursor;
708: l_report_line_id AP_WEB_DB_EXPLINE_PKG.expLines_report_line_id;
709: l_line_ccid AP_WEB_DB_EXPLINE_PKG.expLines_codeCombID;
710: l_dist_id AP_EXP_REPORT_DISTS.REPORT_DISTRIBUTION_ID%TYPE;
711: l_line_amount NUMBER;
712: BEGIN

Line 709: l_line_ccid AP_WEB_DB_EXPLINE_PKG.expLines_codeCombID;

705: --------------------------------------------------------------------------------
706: l_report_distribution_id expDist_REPORT_DISTRIBUTION_ID;
707: c_line_ccid_cursor AP_WEB_DB_EXPLINE_PKG.ExpLineCCIDCursor;
708: l_report_line_id AP_WEB_DB_EXPLINE_PKG.expLines_report_line_id;
709: l_line_ccid AP_WEB_DB_EXPLINE_PKG.expLines_codeCombID;
710: l_dist_id AP_EXP_REPORT_DISTS.REPORT_DISTRIBUTION_ID%TYPE;
711: l_line_amount NUMBER;
712: BEGIN
713:

Line 714: IF (AP_WEB_DB_EXPLINE_PKG.GetLineCCIDCursor(p_report_header_id, c_line_ccid_cursor)) THEN

710: l_dist_id AP_EXP_REPORT_DISTS.REPORT_DISTRIBUTION_ID%TYPE;
711: l_line_amount NUMBER;
712: BEGIN
713:
714: IF (AP_WEB_DB_EXPLINE_PKG.GetLineCCIDCursor(p_report_header_id, c_line_ccid_cursor)) THEN
715:
716: LOOP
717: FETCH c_line_ccid_cursor INTO l_report_line_id, l_line_ccid, l_line_amount;
718: EXIT WHEN c_line_ccid_cursor%NOTFOUND;

Line 891: l_report_header_id AP_WEB_DB_EXPLINE_PKG.expLines_headerID;

887: l_col_stmt varchar2(5000);
888: l_temp long;
889: l_cursor integer;
890: l_rows integer;
891: l_report_header_id AP_WEB_DB_EXPLINE_PKG.expLines_headerID;
892: l_last_updated_by NUMBER;
893: l_created_by NUMBER;
894: l_report_distribution_id expDist_REPORT_DISTRIBUTION_ID;
895: l_code_combination_id expDist_CODE_COMBINATION_ID;