DBA Data[Home] [Help]

APPS.AP_WEB_OA_MAINFLOW_PKG dependencies on AP_WEB_DB_AP_INT_PKG

Line 114: l_bSOBResult := AP_WEB_DB_AP_INT_PKG.GetSOB(p_set_of_books_id);

110: -- Default foreign currency flag
111: p_default_foreign_curr_flag := l_userPrefs.default_foreign_curr_flag;
112:
113: -- Set of books
114: l_bSOBResult := AP_WEB_DB_AP_INT_PKG.GetSOB(p_set_of_books_id);
115:
116: IF (GMS_OIE_INT_PKG.IsGrantsEnabled()) THEN
117: p_is_grants_enabled := 'Y';
118: ELSE

Line 918: l_vendor_id AP_WEB_DB_AP_INT_PKG.vendors_vendorID;

914: p_userId OUT NOCOPY VARCHAR2
915: ) IS
916: -------------------------------------------------------------------
917: l_debug_info VARCHAR2(1000);
918: l_vendor_id AP_WEB_DB_AP_INT_PKG.vendors_vendorID;
919: l_vend_pay_curr AP_WEB_DB_AP_INT_PKG.vendors_paymentCurrCode;
920: l_vend_pay_curr_name AP_WEB_DB_COUNTRY_PKG.curr_name;
921: l_SysInfoRec AP_WEB_DB_AP_INT_PKG.APSysInfoRec;
922: l_base_currency AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;

Line 919: l_vend_pay_curr AP_WEB_DB_AP_INT_PKG.vendors_paymentCurrCode;

915: ) IS
916: -------------------------------------------------------------------
917: l_debug_info VARCHAR2(1000);
918: l_vendor_id AP_WEB_DB_AP_INT_PKG.vendors_vendorID;
919: l_vend_pay_curr AP_WEB_DB_AP_INT_PKG.vendors_paymentCurrCode;
920: l_vend_pay_curr_name AP_WEB_DB_COUNTRY_PKG.curr_name;
921: l_SysInfoRec AP_WEB_DB_AP_INT_PKG.APSysInfoRec;
922: l_base_currency AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
923: l_sys_multi_curr_flag AP_WEB_DB_AP_INT_PKG.apSetUp_multiCurrencyFlag;

Line 921: l_SysInfoRec AP_WEB_DB_AP_INT_PKG.APSysInfoRec;

917: l_debug_info VARCHAR2(1000);
918: l_vendor_id AP_WEB_DB_AP_INT_PKG.vendors_vendorID;
919: l_vend_pay_curr AP_WEB_DB_AP_INT_PKG.vendors_paymentCurrCode;
920: l_vend_pay_curr_name AP_WEB_DB_COUNTRY_PKG.curr_name;
921: l_SysInfoRec AP_WEB_DB_AP_INT_PKG.APSysInfoRec;
922: l_base_currency AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
923: l_sys_multi_curr_flag AP_WEB_DB_AP_INT_PKG.apSetUp_multiCurrencyFlag;
924: l_base_curr_name AP_WEB_DB_COUNTRY_PKG.curr_name;
925: l_has VARCHAR2(1);

Line 922: l_base_currency AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;

918: l_vendor_id AP_WEB_DB_AP_INT_PKG.vendors_vendorID;
919: l_vend_pay_curr AP_WEB_DB_AP_INT_PKG.vendors_paymentCurrCode;
920: l_vend_pay_curr_name AP_WEB_DB_COUNTRY_PKG.curr_name;
921: l_SysInfoRec AP_WEB_DB_AP_INT_PKG.APSysInfoRec;
922: l_base_currency AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
923: l_sys_multi_curr_flag AP_WEB_DB_AP_INT_PKG.apSetUp_multiCurrencyFlag;
924: l_base_curr_name AP_WEB_DB_COUNTRY_PKG.curr_name;
925: l_has VARCHAR2(1);
926: l_cCardEnabled VARCHAR2(1);

Line 923: l_sys_multi_curr_flag AP_WEB_DB_AP_INT_PKG.apSetUp_multiCurrencyFlag;

919: l_vend_pay_curr AP_WEB_DB_AP_INT_PKG.vendors_paymentCurrCode;
920: l_vend_pay_curr_name AP_WEB_DB_COUNTRY_PKG.curr_name;
921: l_SysInfoRec AP_WEB_DB_AP_INT_PKG.APSysInfoRec;
922: l_base_currency AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
923: l_sys_multi_curr_flag AP_WEB_DB_AP_INT_PKG.apSetUp_multiCurrencyFlag;
924: l_base_curr_name AP_WEB_DB_COUNTRY_PKG.curr_name;
925: l_has VARCHAR2(1);
926: l_cCardEnabled VARCHAR2(1);
927: l_userId NUMBER;

Line 971: IF (NOT AP_WEB_DB_AP_INT_PKG.GetVendorInfoOfEmp(p_employee_id,

967:
968:
969: l_debug_info := 'vendor id';
970: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);
971: IF (NOT AP_WEB_DB_AP_INT_PKG.GetVendorInfoOfEmp(p_employee_id,
972: l_vendor_id,
973: l_vend_pay_curr,
974: l_vend_pay_curr_name
975: )) THEN

Line 983: IF (AP_WEB_DB_AP_INT_PKG.GetAPSysCurrencySetupInfo(l_SysInfoRec)) THEN

979: END IF;
980:
981: l_debug_info := 'Select currency information';
982: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);
983: IF (AP_WEB_DB_AP_INT_PKG.GetAPSysCurrencySetupInfo(l_SysInfoRec)) THEN
984: l_base_currency := l_SysInfoRec.base_currency;
985: l_sys_multi_curr_flag := l_SysInfoRec.sys_multi_curr_flag;
986: l_base_curr_name := l_SysInfoRec.base_curr_name;
987: END IF;

Line 1145: l_SysInfoRec AP_WEB_DB_AP_INT_PKG.APSysInfoRec;

1141: *----------------------------------------------------------------------------*/
1142: PROCEDURE GetFunctionalCurrencyInfo(p_currencyCode out nocopy varchar2,
1143: p_currencyType out nocopy varchar2)
1144: IS
1145: l_SysInfoRec AP_WEB_DB_AP_INT_PKG.APSysInfoRec;
1146: BEGIN
1147:
1148: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
1149: 'start GetFunctionalCurrencyInfo');

Line 1153: IF (AP_WEB_DB_AP_INT_PKG.GetAPSysCurrencySetupInfo(l_SysInfoRec)) THEN

1149: 'start GetFunctionalCurrencyInfo');
1150: p_currencyCode := null;
1151: p_currencyType := null;
1152:
1153: IF (AP_WEB_DB_AP_INT_PKG.GetAPSysCurrencySetupInfo(l_SysInfoRec)) THEN
1154: p_currencyType := l_SysInfoRec.default_exchange_rate_type;
1155: p_currencyCode := l_SysInfoRec.base_currency;
1156: END IF; /* GetAPSysCurrencySetupInfo */
1157: