DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_PROCESS dependencies on AP_WEB_AUDIT_UTILS

Line 658: select AP_WEB_AUDIT_UTILS.is_employee_active(employee_id, org_id) active

654: PROCEDURE process_inactive(p_report_header_id IN NUMBER,
655: p_audit_report OUT NOCOPY BOOLEAN) IS
656:
657: CURSOR report_cur IS
658: select AP_WEB_AUDIT_UTILS.is_employee_active(employee_id, org_id) active
659: from AP_EXPENSE_REPORT_HEADERS_ALL
660: where report_header_id = p_report_header_id;
661:
662: report_rec report_cur%ROWTYPE;

Line 1745: ln_personal_expense_id := AP_WEB_AUDIT_UTILS.get_personal_expense_id;

1741:
1742: BEGIN
1743: IF expense_line_rec.credit_card_trx_id IS NOT NULL THEN
1744:
1745: ln_personal_expense_id := AP_WEB_AUDIT_UTILS.get_personal_expense_id;
1746:
1747: OPEN total_c(expense_line_rec.report_header_id, expense_line_rec.credit_card_trx_id, ln_personal_expense_id);
1748: FETCH total_c into total_rec;
1749: CLOSE total_c;

Line 1926: ln_personal_expense_id := AP_WEB_AUDIT_UTILS.get_seeded_expense_id('PERSONAL');

1922: l_extended_precision NUMBER := 0;
1923: l_min_acct_unit NUMBER := 0;
1924:
1925: BEGIN
1926: ln_personal_expense_id := AP_WEB_AUDIT_UTILS.get_seeded_expense_id('PERSONAL');
1927: ln_rounding_expense_id := AP_WEB_AUDIT_UTILS.get_seeded_expense_id('ROUNDING');
1928:
1929: FOR totals_rec IN totals_c(ln_personal_expense_id, ln_rounding_expense_id) LOOP
1930:

Line 1927: ln_rounding_expense_id := AP_WEB_AUDIT_UTILS.get_seeded_expense_id('ROUNDING');

1923: l_min_acct_unit NUMBER := 0;
1924:
1925: BEGIN
1926: ln_personal_expense_id := AP_WEB_AUDIT_UTILS.get_seeded_expense_id('PERSONAL');
1927: ln_rounding_expense_id := AP_WEB_AUDIT_UTILS.get_seeded_expense_id('ROUNDING');
1928:
1929: FOR totals_rec IN totals_c(ln_personal_expense_id, ln_rounding_expense_id) LOOP
1930:
1931: fnd_currency.get_info(totals_rec.CURRENCY_CODE,l_precision,l_extended_precision,l_min_acct_unit);

Line 1977: l_exp_line_ccid := AP_WEB_AUDIT_UTILS.get_rounding_error_ccid(lines_rec.org_id);

1973:
1974: /**
1975: * Fetch the rounding error account to which the rounding amount is accounted.
1976: */
1977: l_exp_line_ccid := AP_WEB_AUDIT_UTILS.get_rounding_error_ccid(lines_rec.org_id);
1978:
1979: ln_next_dist_line_number := AP_WEB_AUDIT_UTILS.get_next_distribution_line_id(p_report_header_id);
1980:
1981: /**

Line 1979: ln_next_dist_line_number := AP_WEB_AUDIT_UTILS.get_next_distribution_line_id(p_report_header_id);

1975: * Fetch the rounding error account to which the rounding amount is accounted.
1976: */
1977: l_exp_line_ccid := AP_WEB_AUDIT_UTILS.get_rounding_error_ccid(lines_rec.org_id);
1978:
1979: ln_next_dist_line_number := AP_WEB_AUDIT_UTILS.get_next_distribution_line_id(p_report_header_id);
1980:
1981: /**
1982: * Populate the new rounding row with data from the original row and overwriting
1983: * the following data.