APPS.AP_BANK_CHARGE_PKG dependencies on IBY_HOOK_DOCS_IN_PMT_T

Line 1365: iby_hook_docs_in_pmt_t IBY

1361:
1362: SELECT AISC.transfer_priority
1363: INTO p_transfer_priority
1364: FROM ap_inv_selection_criteria_ALL AISC,
1365: iby_hook_docs_in_pmt_t IBY
1366: WHERE IBY.CALLING_APP_DOC_UNIQUE_REF1 = AISC.CHECKRUN_ID
1367: and rownum=1;
1368:
1369:

Line 1424: FROM iby_hook_docs_in_pmt_t

1420:
1421: SELECT sum(decode(dont_pay_flag, 'Y', 0,
1422: document_amount + nvl(PAYMENT_CURR_DISCOUNT_TAKEN,0)))
1423: INTO p_amount_due
1424: FROM iby_hook_docs_in_pmt_t
1425: WHERE payment_id= p_selected_check_id;
1426:
1427:
1428: RETURN (TRUE);

Line 1478: FROM iby_hook_docs_in_pmt_t

1474:
1475: CURSOR adjustment_for_rounding_error (c_selected_check_id NUMBER,
1476: c_rounding_error NUMBER) IS
1477: SELECT PAYMENT_CURR_DISCOUNT_TAKEN
1478: FROM iby_hook_docs_in_pmt_t
1479: WHERE payment_id = c_selected_check_id
1480: AND ABS(document_amount) >= ABS(c_rounding_error)
1481: ORDER BY PAYMENT_CURR_DISCOUNT_TAKEN desc;
1482:

Line 1870: l_debug_info := 'Update iby_hook_docs_in_pmt_t';

1866: -- bank_charge_amount
1867: -- 2, Subtract the proportion of the bank_charge_amount from
1868: -- payment_amount and proposed_payment_amount
1869: ----------------------------------------------------------
1870: l_debug_info := 'Update iby_hook_docs_in_pmt_t';
1871: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1872: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1873: END IF;
1874:

Line 1876: UPDATE iby_hook_docs_in_pmt_t

1872: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1873: END IF;
1874:
1875:
1876: UPDATE iby_hook_docs_in_pmt_t
1877: SET PAYMENT_CURR_DISCOUNT_TAKEN = decode(l_amt_due, 0, 0,
1878: decode(l_min_account_unit,
1879: null, round(l_best_bank_charge *
1880: (document_amount/l_amt_due),

Line 1939: FROM iby_hook_docs_in_pmt_t

1935: -- to set-off the rounding error.
1936:
1937: SELECT max(ABS(PAYMENT_CURR_DISCOUNT_TAKEN))
1938: INTO l_max_discount_amount
1939: FROM iby_hook_docs_in_pmt_t
1940: WHERE payment_id = l_selected_check_id
1941: AND ABS(document_amount) >= ABS(l_rounding_error);
1942:
1943:

Line 1947: UPDATE iby_hook_docs_in_pmt_t

1943:
1944:
1945: IF (l_max_discount_amount >= l_rounding_error) THEN
1946:
1947: UPDATE iby_hook_docs_in_pmt_t
1948: SET PAYMENT_CURR_DISCOUNT_TAKEN = PAYMENT_CURR_DISCOUNT_TAKEN - l_rounding_error,
1949: document_amount = document_amount + l_rounding_error
1950: WHERE payment_id = l_selected_check_id
1951: AND ABS(PAYMENT_CURR_DISCOUNT_TAKEN) = l_max_discount_amount

Line 1981: UPDATE iby_hook_docs_in_pmt_t

1977: amount equal to zero. */
1978:
1979: IF (l_max_discount_amount <= l_rem_rounding_error_amount) THEN
1980:
1981: UPDATE iby_hook_docs_in_pmt_t
1982: SET PAYMENT_CURR_DISCOUNT_TAKEN = PAYMENT_CURR_DISCOUNT_TAKEN - l_max_discount_amount,
1983: document_amount = document_amount + l_max_discount_amount
1984: WHERE payment_id = l_selected_check_id
1985: AND ABS(PAYMENT_CURR_DISCOUNT_TAKEN) = l_max_discount_amount

Line 2000: UPDATE iby_hook_docs_in_pmt_t

1996:
1997: /* The Remaining Rounding Error is less than the maximum discount amount. So now use the remaining
1998: rounding error amount as the adjustment amount. */
1999:
2000: UPDATE iby_hook_docs_in_pmt_t
2001: SET PAYMENT_CURR_DISCOUNT_TAKEN = PAYMENT_CURR_DISCOUNT_TAKEN -
2002: l_rem_rounding_error_amount,
2003: document_amount = document_amount + l_rem_rounding_error_amount
2004: WHERE payment_id = l_selected_check_id