APPS.AP_WEB_CREDIT_CARD_WF dependencies on AP_WEB_DB_EXPRPT_PKG

Line 327: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;

323: l_employeeDisplayName wf_users.display_name%type;
324: l_managerId NUMBER;
325: l_managerName wf_users.name%type;
326: l_managerDisplayName wf_users.display_name%type;
327: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
328: l_debugInfo VARCHAR2(200);
329: l_cardProgramID AP_WEB_DB_CCARD_PKG.cardProgs_cardProgID;
330: l_orgId number;
331: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

Line 546: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;

542: l_managerId NUMBER;
543: l_managerName wf_users.name%type;
544: l_managerDisplayName wf_users.display_name%type;
545: l_employeeDisplayName wf_users.display_name%type;
546: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
547: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;
548: l_orgId number;
549: l_debugInfo VARCHAR2(200);
550: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

Line 1110: l_exp_info_rec AP_WEB_DB_EXPRPT_PKG.ExpInfoRec;

1106: l_employeeName wf_users.name%type;
1107: l_employeeDisplayName wf_users.display_name%type;
1108: l_managerName wf_users.name%type;
1109: l_managerDisplayName wf_users.display_name%type;
1110: l_exp_info_rec AP_WEB_DB_EXPRPT_PKG.ExpInfoRec;
1111: l_debugInfo VARCHAR2(200);
1112:
1113: BEGIN
1114: ------------------------------------------------------------

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

1114: ------------------------------------------------------------
1115: l_debugInfo := 'Get employee_Id';
1116: ------------------------------------------------------------
1117:
1118: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetReportInfo(p_expenseReportId, l_exp_info_rec)) THEN
1119: NULL;
1120: END IF;
1121:
1122:

Line 1223: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;

1219: l_itemKey VARCHAR2(100);
1220: l_employeeId number;
1221: l_employeeName wf_users.name%type;
1222: l_employeeDisplayName wf_users.display_name%type;
1223: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
1224: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;
1225: l_sysdate VARCHAR2(30);
1226: l_today DATE;
1227: l_orgId number;