APPS.AP_WEB_CREDIT_CARD_WF dependencies on AP_WEB_DB_EXPRPT_PKG

Line 337: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;

333: l_employeeDisplayName wf_users.display_name%type;
334: l_managerId NUMBER;
335: l_managerName wf_users.name%type;
336: l_managerDisplayName wf_users.display_name%type;
337: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
338: l_debugInfo VARCHAR2(200);
339: l_cardProgramID AP_WEB_DB_CCARD_PKG.cardProgs_cardProgID;
340: l_orgId number;
341: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

Line 590: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;

586: l_managerId NUMBER;
587: l_managerName wf_users.name%type;
588: l_managerDisplayName wf_users.display_name%type;
589: l_employeeDisplayName wf_users.display_name%type;
590: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
591: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;
592: l_orgId number;
593: l_debugInfo VARCHAR2(200);
594: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

Line 1178: l_exp_info_rec AP_WEB_DB_EXPRPT_PKG.ExpInfoRec;

1174: l_employeeName wf_users.name%type;
1175: l_employeeDisplayName wf_users.display_name%type;
1176: l_managerName wf_users.name%type;
1177: l_managerDisplayName wf_users.display_name%type;
1178: l_exp_info_rec AP_WEB_DB_EXPRPT_PKG.ExpInfoRec;
1179: l_debugInfo VARCHAR2(200);
1180:
1181: BEGIN
1182: ------------------------------------------------------------

Line 1186: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetReportInfo(p_expenseReportId, l_exp_info_rec)) THEN

1182: ------------------------------------------------------------
1183: l_debugInfo := 'Get employee_Id';
1184: ------------------------------------------------------------
1185:
1186: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetReportInfo(p_expenseReportId, l_exp_info_rec)) THEN
1187: NULL;
1188: END IF;
1189:
1190:

Line 1291: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;

1287: l_itemKey VARCHAR2(100);
1288: l_employeeId number;
1289: l_employeeName wf_users.name%type;
1290: l_employeeDisplayName wf_users.display_name%type;
1291: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
1292: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;
1293: l_sysdate VARCHAR2(30);
1294: l_today DATE;
1295: l_orgId number;