APPS.AP_WEB_AUDIT_PROCESS dependencies on AP_WEB_DB_EXPLINE_PKG

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

872: END IF;
873:
874: IF lb_ignore = false AND NVL(p_ignore_rj_not_req_only_flag, 'N') = 'Y' THEN
875:
876: IF (NOT AP_WEB_DB_EXPLINE_PKG.GetNumReceiptRequiredLines(p_report_header_id, ln_num_rct_req_receipts)) THEN
877: ln_num_rct_req_receipts := 0;
878: END IF;
879:
880: IF (NOT AP_WEB_DB_EXPLINE_PKG.GetNumJustReqdLines(p_report_header_id, ln_num_just_req_receipts)) THEN

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

876: IF (NOT AP_WEB_DB_EXPLINE_PKG.GetNumReceiptRequiredLines(p_report_header_id, ln_num_rct_req_receipts)) THEN
877: ln_num_rct_req_receipts := 0;
878: END IF;
879:
880: IF (NOT AP_WEB_DB_EXPLINE_PKG.GetNumJustReqdLines(p_report_header_id, ln_num_just_req_receipts)) THEN
881: ln_num_just_req_receipts := 0;
882: END IF;
883:
884: IF ( ln_num_rct_req_receipts = 0

Line 1911: l_exp_line_ccid AP_WEB_DB_EXPLINE_PKG.expLines_codeCombID;

1907: rounding_expense_rec rounding_expense_c%ROWTYPE;
1908: lines_rec lines_c%ROWTYPE;
1909: new_report_line_rec AP_EXPENSE_REPORT_LINES_ALL%ROWTYPE;
1910: distribution_rec distribution_c%ROWTYPE;
1911: l_exp_line_ccid AP_WEB_DB_EXPLINE_PKG.expLines_codeCombID;
1912:
1913: ln_total_amount NUMBER;
1914: ln_total_daily_amount NUMBER;
1915: ln_rounding_amount NUMBER;

Line 2006: AP_WEB_DB_EXPLINE_PKG.InsertLine(new_report_line_rec);

2002: new_report_line_rec.creation_date := SYSDATE;
2003: new_report_line_rec.category_code := 'ROUNDING';
2004: new_report_line_rec.justification_required_flag := 'N';
2005:
2006: AP_WEB_DB_EXPLINE_PKG.InsertLine(new_report_line_rec);
2007:
2008: OPEN rounding_line_c(totals_rec.itemization_parent_id, totals_rec.credit_card_trx_id, ln_rounding_expense_id);
2009: FETCH rounding_line_c into rounding_line_rec;
2010: CLOSE rounding_line_c;