APPS.AP_WEB_AUDIT_PROCESS dependencies on AP_WEB_DB_EXPLINE_PKG

Line 955: IF (NOT AP_WEB_DB_EXPLINE_PKG.GetNumReceiptRequiredLines(p_report_header_id, ln_num_rct_req_receipts)) THEN

951: END IF;
952:
953: IF lb_ignore = false AND NVL(p_ignore_rj_not_req_only_flag, 'N') = 'Y' THEN
954:
955: IF (NOT AP_WEB_DB_EXPLINE_PKG.GetNumReceiptRequiredLines(p_report_header_id, ln_num_rct_req_receipts)) THEN
956: ln_num_rct_req_receipts := 0;
957: END IF;
958:
959: IF (NOT AP_WEB_DB_EXPLINE_PKG.GetNumJustReqdLines(p_report_header_id, ln_num_just_req_receipts)) THEN

Line 959: IF (NOT AP_WEB_DB_EXPLINE_PKG.GetNumJustReqdLines(p_report_header_id, ln_num_just_req_receipts)) THEN

955: IF (NOT AP_WEB_DB_EXPLINE_PKG.GetNumReceiptRequiredLines(p_report_header_id, ln_num_rct_req_receipts)) THEN
956: ln_num_rct_req_receipts := 0;
957: END IF;
958:
959: IF (NOT AP_WEB_DB_EXPLINE_PKG.GetNumJustReqdLines(p_report_header_id, ln_num_just_req_receipts)) THEN
960: ln_num_just_req_receipts := 0;
961: END IF;
962:
963: IF ( ln_num_rct_req_receipts = 0

Line 2028: l_exp_line_ccid AP_WEB_DB_EXPLINE_PKG.expLines_codeCombID;

2024: rounding_expense_rec rounding_expense_c%ROWTYPE;
2025: lines_rec lines_c%ROWTYPE;
2026: new_report_line_rec AP_EXPENSE_REPORT_LINES_ALL%ROWTYPE;
2027: distribution_rec distribution_c%ROWTYPE;
2028: l_exp_line_ccid AP_WEB_DB_EXPLINE_PKG.expLines_codeCombID;
2029:
2030: ln_total_amount NUMBER;
2031: ln_total_daily_amount NUMBER;
2032: ln_rounding_amount NUMBER;

Line 2123: AP_WEB_DB_EXPLINE_PKG.InsertLine(new_report_line_rec);

2119: new_report_line_rec.creation_date := SYSDATE;
2120: new_report_line_rec.category_code := 'ROUNDING';
2121: new_report_line_rec.justification_required_flag := 'N';
2122:
2123: AP_WEB_DB_EXPLINE_PKG.InsertLine(new_report_line_rec);
2124:
2125: OPEN rounding_line_c(totals_rec.itemization_parent_id, totals_rec.credit_card_trx_id, ln_rounding_expense_id);
2126: FETCH rounding_line_c into rounding_line_rec;
2127: CLOSE rounding_line_c;