APPS.AP_WEB_VALIDATE_UTIL dependencies on AP_WEB_DB_AP_INT_PKG

Line 213: V_SysInfoRec AP_WEB_DB_AP_INT_PKG.APSysInfoRec; -- For PATC: Exchange rate type in AP and Functional currency

209: l_debug_info VARCHAR2(2000);
210:
211: i INTEGER;
212:
213: V_SysInfoRec AP_WEB_DB_AP_INT_PKG.APSysInfoRec; -- For PATC: Exchange rate type in AP and Functional currency
214: V_EndExpenseDate DATE; -- For PATC: Latest receipt date
215: V_DefaultExchangeRate NUMBER; -- For PATC: Exchange rate for func->reimb
216: V_DateTemp DATE; -- For PATC: Scratch variable
217: V_DateFormat VARCHAR2(30);

Line 221: l_vendor_id AP_WEB_DB_AP_INT_PKG.vendors_vendorID;

217: V_DateFormat VARCHAR2(30);
218:
219: l_IsMobileApp boolean;
220: l_DataDefaultedUpdateable BOOLEAN;
221: l_vendor_id AP_WEB_DB_AP_INT_PKG.vendors_vendorID;
222: l_vend_pay_curr AP_WEB_DB_AP_INT_PKG.vendors_paymentCurrCode;
223: l_vend_pay_curr_name AP_WEB_DB_COUNTRY_PKG.curr_name;
224:
225: BEGIN

Line 222: l_vend_pay_curr AP_WEB_DB_AP_INT_PKG.vendors_paymentCurrCode;

218:
219: l_IsMobileApp boolean;
220: l_DataDefaultedUpdateable BOOLEAN;
221: l_vendor_id AP_WEB_DB_AP_INT_PKG.vendors_vendorID;
222: l_vend_pay_curr AP_WEB_DB_AP_INT_PKG.vendors_paymentCurrCode;
223: l_vend_pay_curr_name AP_WEB_DB_COUNTRY_PKG.curr_name;
224:
225: BEGIN
226:

Line 271: IF (NOT AP_WEB_DB_AP_INT_PKG.GetAPSysCurrencySetupInfo(V_SysInfoRec)) THEN

267: -- rate for the last receipt date. The last receipt date will be
268: -- equal to sysdate.
269: L_debug_info := 'Getting functional currency and exchange rate info';
270:
271: IF (NOT AP_WEB_DB_AP_INT_PKG.GetAPSysCurrencySetupInfo(V_SysInfoRec)) THEN
272: NULL;
273: END IF;
274:
275: IF (NOT AP_WEB_DB_AP_INT_PKG.GetVendorInfoOfEmp(p_report_header_info.employee_id,

Line 275: IF (NOT AP_WEB_DB_AP_INT_PKG.GetVendorInfoOfEmp(p_report_header_info.employee_id,

271: IF (NOT AP_WEB_DB_AP_INT_PKG.GetAPSysCurrencySetupInfo(V_SysInfoRec)) THEN
272: NULL;
273: END IF;
274:
275: IF (NOT AP_WEB_DB_AP_INT_PKG.GetVendorInfoOfEmp(p_report_header_info.employee_id,
276: l_vendor_id,
277: l_vend_pay_curr,
278: l_vend_pay_curr_name
279: )) THEN

Line 638: IF (NOT AP_WEB_DB_AP_INT_PKG.CostCenterValid(p_costCenter,

634: --
635: -- Custom validation API returned FALSE; therefore we validate using
636: -- the cursor declared above.
637: --
638: IF (NOT AP_WEB_DB_AP_INT_PKG.CostCenterValid(p_costCenter,
639: l_CostCenterValid,
640: p_employee_id)) THEN
641: NULL;
642: END IF;

Line 804: l_apsys_info_rec AP_WEB_DB_AP_INT_PKG.APSysInfoRec;

800: l_IsMobileApp boolean;
801:
802: -- For bug fix 1865355
803: l_exp_reimb_curr_profile VARCHAR2(1);
804: l_apsys_info_rec AP_WEB_DB_AP_INT_PKG.APSysInfoRec;
805: l_base_currency AP_SYSTEM_PARAMETERS.base_currency_code%TYPE;
806: l_vendor_id NUMBER;
807: l_vend_pay_curr VARCHAR2(15);
808: l_vend_pay_curr_name FND_CURRENCIES_VL.name%TYPE;

Line 1044: IF ( NOT AP_WEB_DB_AP_INT_PKG.GetVendorInfoOfEmp(ExpReportHeaderInfo.employee_id,

1040: p_user_id => p_user_id,
1041: p_resp_id => null,
1042: p_apps_id => null);
1043: IF ( nvl(l_exp_reimb_curr_profile,'Y') = 'N' ) THEN
1044: IF ( NOT AP_WEB_DB_AP_INT_PKG.GetVendorInfoOfEmp(ExpReportHeaderInfo.employee_id,
1045: l_vendor_id,l_vend_pay_curr,l_vend_pay_curr_name) ) THEN
1046: NULL;
1047: END IF;
1048:

Line 1049: IF ( AP_WEB_DB_AP_INT_PKG.GetAPSysCurrencySetupInfo(l_apsys_info_rec) = TRUE ) THEN

1045: l_vendor_id,l_vend_pay_curr,l_vend_pay_curr_name) ) THEN
1046: NULL;
1047: END IF;
1048:
1049: IF ( AP_WEB_DB_AP_INT_PKG.GetAPSysCurrencySetupInfo(l_apsys_info_rec) = TRUE ) THEN
1050: l_base_currency := l_apsys_info_rec.base_currency;
1051: END IF;
1052:
1053: l_default_reimb_curr := nvl(l_vend_pay_curr, l_base_currency);

Line 1099: p_SysInfoRec IN AP_WEB_DB_AP_INT_PKG.APSysInfoRec,

1095: p_userId IN NUMBER,
1096: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
1097: p_report_line_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLineRec,
1098: p_receipt_index IN INTEGER, -- for AddExpError
1099: p_SysInfoRec IN AP_WEB_DB_AP_INT_PKG.APSysInfoRec,
1100: p_DefaultExchangeRate IN NUMBER,
1101: p_EndExpenseDate IN DATE,
1102: p_DateFormat IN VARCHAR2,
1103: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,

Line 2402: V_SysInfoRec AP_WEB_DB_AP_INT_PKG.APSysInfoRec; -- For PATC: Exchange rate type in AP and Functional currency

2398:
2399: l_curr_precision_cursor AP_WEB_DB_COUNTRY_PKG.CurrencyPrecisionCursor;
2400: l_reimbcurr_precision AP_WEB_DB_COUNTRY_PKG.curr_precision;
2401:
2402: V_SysInfoRec AP_WEB_DB_AP_INT_PKG.APSysInfoRec; -- For PATC: Exchange rate type in AP and Functional currency
2403: V_EndExpenseDate DATE; -- For PATC: Latest receipt date
2404: V_DefaultExchangeRate NUMBER; -- For PATC: Exchange rate for func->reimb
2405: -- on latest receipt date
2406: V_DateFormat VARCHAR2(30);