APPS.IBY_PAYGROUP_PUB dependencies on IBY_PAYMENT_METHODS_VL

Line 20245: l_maturity_days_offset IBY_PAYMENT_METHODS_VL.maturity_date_offset_days%TYPE;

20241: IS
20242: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
20243: '.performMaturityDateCalculation';
20244: l_maturity_days_tab pmtMethodMaturityDaysTab;
20245: l_maturity_days_offset IBY_PAYMENT_METHODS_VL.maturity_date_offset_days%TYPE;
20246: l_maturity_date_set_flag BOOLEAN := FALSE;
20247: l_temp_discount_date DATE := NULL;
20248: l_temp_due_date DATE := NULL;
20249:

Line 20699: IBY_PAYMENT_METHODS_VL

20695: SELECT
20696: payment_method_code,
20697: maturity_date_offset_days
20698: FROM
20699: IBY_PAYMENT_METHODS_VL
20700: WHERE
20701: support_bills_payable_flag = 'Y'
20702: ;
20703:

Line 20752: l_maturity_days_offset IBY_PAYMENT_METHODS_VL.maturity_date_offset_days%TYPE;

20748: IS
20749: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
20750: '.performMaturityDateCalculation';
20751: --l_maturity_days_tab pmtMethodMaturityDaysTab;
20752: l_maturity_days_offset IBY_PAYMENT_METHODS_VL.maturity_date_offset_days%TYPE;
20753: l_maturity_date_set_flag BOOLEAN := FALSE;
20754: l_temp_discount_date DATE := NULL;
20755: l_temp_due_date DATE := NULL;
20756:

Line 21117: l_maturity_days_offset IBY_PAYMENT_METHODS_VL.maturity_date_offset_days%TYPE

21113: p_pmt_method_code IN IBY_PAYMENTS_ALL.payment_method_code%TYPE,
21114: p_maturityDaysTab IN pmtMethodMaturityDaysTab
21115: ) RETURN NUMBER
21116: IS
21117: l_maturity_days_offset IBY_PAYMENT_METHODS_VL.maturity_date_offset_days%TYPE
21118: := -1;
21119: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
21120: '.getMaturityDaysForPmtMethod';
21121: BEGIN

Line 21185: l_maturity_days_offset IBY_PAYMENT_METHODS_VL.maturity_date_offset_days%TYPE := -1;

21181: p_pmt_method_code IN IBY_PAYMENTS_ALL.payment_method_code%TYPE
21182: -- p_maturityDaysTab IN pmtMethodMaturityDaysTab
21183: ) RETURN NUMBER
21184: IS
21185: l_maturity_days_offset IBY_PAYMENT_METHODS_VL.maturity_date_offset_days%TYPE := -1;
21186: --l_payment_method_code IBY_PAYMENT_METHODS_VL.payment_method_code%TYPE;
21187: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
21188: '.getMaturityDaysForPmtMethod';
21189: BEGIN

Line 21186: --l_payment_method_code IBY_PAYMENT_METHODS_VL.payment_method_code%TYPE;

21182: -- p_maturityDaysTab IN pmtMethodMaturityDaysTab
21183: ) RETURN NUMBER
21184: IS
21185: l_maturity_days_offset IBY_PAYMENT_METHODS_VL.maturity_date_offset_days%TYPE := -1;
21186: --l_payment_method_code IBY_PAYMENT_METHODS_VL.payment_method_code%TYPE;
21187: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
21188: '.getMaturityDaysForPmtMethod';
21189: BEGIN
21190: IF(maturity_date_tbl.EXISTS(p_pmt_method_code)) THEN

Line 21202: FROM IBY_PAYMENT_METHODS_VL

21198: print_debuginfo(l_module_name, 'Getting the data from DB For Payment Method Code ' || p_pmt_method_code);
21199: END IF;
21200: SELECT maturity_date_offset_days
21201: INTO l_maturity_days_offset
21202: FROM IBY_PAYMENT_METHODS_VL
21203: WHERE support_bills_payable_flag = 'Y'
21204: AND payment_method_code = p_pmt_method_code;
21205: EXCEPTION
21206: WHEN NO_DATA_FOUND THEN