APPS.AP_BANK_CHARGE_PKG dependencies on IBY_HOOK_DOCS_IN_PMT_T

Line 1463: iby_hook_docs_in_pmt_t IBY

1459: /* Commented for bug#12769134 Start
1460: SELECT AISC.transfer_priority
1461: INTO p_transfer_priority
1462: FROM ap_inv_selection_criteria_ALL AISC,
1463: iby_hook_docs_in_pmt_t IBY
1464: WHERE IBY.CALLING_APP_DOC_UNIQUE_REF1 = AISC.CHECKRUN_ID
1465: and rownum=1;
1466: Commented for bug#12769134 End */
1467:

Line 1474: FROM IBY_HOOK_DOCS_IN_PMT_T IBY

1470: INTO p_transfer_priority
1471: FROM AP_INV_SELECTION_CRITERIA_ALL AISC
1472: WHERE EXISTS
1473: ( SELECT 1
1474: FROM IBY_HOOK_DOCS_IN_PMT_T IBY
1475: WHERE IBY.CALLING_APP_DOC_UNIQUE_REF1 = AISC.CHECKRUN_ID
1476: );
1477: /* Added for bug#12769134 End */
1478:

Line 1533: FROM iby_hook_docs_in_pmt_t

1529:
1530: SELECT sum(decode(dont_pay_flag, 'Y', 0,
1531: document_amount + nvl(PAYMENT_CURR_DISCOUNT_TAKEN,0)))
1532: INTO p_amount_due
1533: FROM iby_hook_docs_in_pmt_t
1534: WHERE payment_id= p_selected_check_id;
1535:
1536:
1537: RETURN (TRUE);

Line 1587: FROM iby_hook_docs_in_pmt_t

1583:
1584: CURSOR adjustment_for_rounding_error (c_selected_check_id NUMBER,
1585: c_rounding_error NUMBER) IS
1586: SELECT PAYMENT_CURR_DISCOUNT_TAKEN
1587: FROM iby_hook_docs_in_pmt_t
1588: WHERE payment_id = c_selected_check_id
1589: AND ABS(document_amount) >= ABS(c_rounding_error)
1590: ORDER BY PAYMENT_CURR_DISCOUNT_TAKEN desc;
1591:

Line 1985: l_debug_info := 'Update iby_hook_docs_in_pmt_t';

1981: -- bank_charge_amount
1982: -- 2, Subtract the proportion of the bank_charge_amount from
1983: -- payment_amount and proposed_payment_amount
1984: ----------------------------------------------------------
1985: l_debug_info := 'Update iby_hook_docs_in_pmt_t';
1986: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1987: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1988: END IF;
1989:

Line 1991: UPDATE iby_hook_docs_in_pmt_t

1987: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1988: END IF;
1989:
1990:
1991: UPDATE iby_hook_docs_in_pmt_t
1992: SET PAYMENT_CURR_DISCOUNT_TAKEN = decode(l_amt_due, 0, 0,
1993: decode(l_min_account_unit,
1994: null, round(l_best_bank_charge *
1995: (document_amount/l_amt_due),

Line 2034: FROM iby_hook_docs_in_pmt_t

2030:
2031: /*Bug7394744 Changed query to make sure rounding amount is calculated properly*/
2032: SELECT l_amt_due - l_best_bank_charge - SUM(document_amount)
2033: INTO l_rounding_error
2034: FROM iby_hook_docs_in_pmt_t
2035: WHERE payment_id = l_selected_check_id;
2036:
2037:
2038: ---------------------------------------------------------

Line 2055: FROM iby_hook_docs_in_pmt_t

2051: -- to set-off the rounding error.
2052:
2053: SELECT max(ABS(PAYMENT_CURR_DISCOUNT_TAKEN))
2054: INTO l_max_discount_amount
2055: FROM iby_hook_docs_in_pmt_t
2056: WHERE payment_id = l_selected_check_id
2057: AND ABS(document_amount) >= ABS(l_rounding_error);
2058:
2059:

Line 2063: UPDATE iby_hook_docs_in_pmt_t

2059:
2060:
2061: IF (l_max_discount_amount >= l_rounding_error) THEN
2062:
2063: UPDATE iby_hook_docs_in_pmt_t
2064: SET PAYMENT_CURR_DISCOUNT_TAKEN = PAYMENT_CURR_DISCOUNT_TAKEN - l_rounding_error,
2065: document_amount = document_amount + l_rounding_error
2066: WHERE payment_id = l_selected_check_id
2067: AND ABS(PAYMENT_CURR_DISCOUNT_TAKEN) = l_max_discount_amount

Line 2097: UPDATE iby_hook_docs_in_pmt_t

2093: amount equal to zero. */
2094:
2095: IF (l_max_discount_amount <= l_rem_rounding_error_amount) THEN
2096:
2097: UPDATE iby_hook_docs_in_pmt_t
2098: SET PAYMENT_CURR_DISCOUNT_TAKEN = PAYMENT_CURR_DISCOUNT_TAKEN - l_max_discount_amount,
2099: document_amount = document_amount + l_max_discount_amount
2100: WHERE payment_id = l_selected_check_id
2101: AND ABS(PAYMENT_CURR_DISCOUNT_TAKEN) = l_max_discount_amount

Line 2116: UPDATE iby_hook_docs_in_pmt_t

2112:
2113: /* The Remaining Rounding Error is less than the maximum discount amount. So now use the remaining
2114: rounding error amount as the adjustment amount. */
2115:
2116: UPDATE iby_hook_docs_in_pmt_t
2117: SET PAYMENT_CURR_DISCOUNT_TAKEN = PAYMENT_CURR_DISCOUNT_TAKEN -
2118: l_rem_rounding_error_amount,
2119: document_amount = document_amount + l_rem_rounding_error_amount
2120: WHERE payment_id = l_selected_check_id