eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_WEB_DB_EXPTEMPLATE_PKG

Line 1318: l_expense_types_cursor AP_WEB_DB_EXPTEMPLATE_PKG.ExpenseTypesCursor;

1314: ) RETURN VARCHAR2 IS
1315: --------------------------------------------------------------------------------
1316: l_cost_center varchar2(200);
1317: l_cc_exist varchar2(1) := 'N';
1318: l_expense_types_cursor AP_WEB_DB_EXPTEMPLATE_PKG.ExpenseTypesCursor;
1319: l_parameter_id AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1320: l_web_FriendlyPrompt AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_webFriendlyPrompt;
1321: l_require_receipt_amount AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_requireReceiptAmt;
1322: l_card_exp_type_lookup_code AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_cardExpTypeLookupCode;

Line 1319: l_parameter_id AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;

1315: --------------------------------------------------------------------------------
1316: l_cost_center varchar2(200);
1317: l_cc_exist varchar2(1) := 'N';
1318: l_expense_types_cursor AP_WEB_DB_EXPTEMPLATE_PKG.ExpenseTypesCursor;
1319: l_parameter_id AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1320: l_web_FriendlyPrompt AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_webFriendlyPrompt;
1321: l_require_receipt_amount AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_requireReceiptAmt;
1322: l_card_exp_type_lookup_code AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_cardExpTypeLookupCode;
1323: l_amount_includes_tax_flag AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_amtInclTaxFlag;

Line 1320: l_web_FriendlyPrompt AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_webFriendlyPrompt;

1316: l_cost_center varchar2(200);
1317: l_cc_exist varchar2(1) := 'N';
1318: l_expense_types_cursor AP_WEB_DB_EXPTEMPLATE_PKG.ExpenseTypesCursor;
1319: l_parameter_id AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1320: l_web_FriendlyPrompt AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_webFriendlyPrompt;
1321: l_require_receipt_amount AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_requireReceiptAmt;
1322: l_card_exp_type_lookup_code AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_cardExpTypeLookupCode;
1323: l_amount_includes_tax_flag AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_amtInclTaxFlag;
1324: l_justif_req AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_justificationReqdFlag;

Line 1321: l_require_receipt_amount AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_requireReceiptAmt;

1317: l_cc_exist varchar2(1) := 'N';
1318: l_expense_types_cursor AP_WEB_DB_EXPTEMPLATE_PKG.ExpenseTypesCursor;
1319: l_parameter_id AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1320: l_web_FriendlyPrompt AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_webFriendlyPrompt;
1321: l_require_receipt_amount AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_requireReceiptAmt;
1322: l_card_exp_type_lookup_code AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_cardExpTypeLookupCode;
1323: l_amount_includes_tax_flag AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_amtInclTaxFlag;
1324: l_justif_req AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_justificationReqdFlag;
1325:

Line 1322: l_card_exp_type_lookup_code AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_cardExpTypeLookupCode;

1318: l_expense_types_cursor AP_WEB_DB_EXPTEMPLATE_PKG.ExpenseTypesCursor;
1319: l_parameter_id AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1320: l_web_FriendlyPrompt AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_webFriendlyPrompt;
1321: l_require_receipt_amount AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_requireReceiptAmt;
1322: l_card_exp_type_lookup_code AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_cardExpTypeLookupCode;
1323: l_amount_includes_tax_flag AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_amtInclTaxFlag;
1324: l_justif_req AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_justificationReqdFlag;
1325:
1326: BEGIN

Line 1323: l_amount_includes_tax_flag AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_amtInclTaxFlag;

1319: l_parameter_id AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1320: l_web_FriendlyPrompt AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_webFriendlyPrompt;
1321: l_require_receipt_amount AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_requireReceiptAmt;
1322: l_card_exp_type_lookup_code AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_cardExpTypeLookupCode;
1323: l_amount_includes_tax_flag AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_amtInclTaxFlag;
1324: l_justif_req AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_justificationReqdFlag;
1325:
1326: BEGIN
1327:

Line 1324: l_justif_req AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_justificationReqdFlag;

1320: l_web_FriendlyPrompt AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_webFriendlyPrompt;
1321: l_require_receipt_amount AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_requireReceiptAmt;
1322: l_card_exp_type_lookup_code AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_cardExpTypeLookupCode;
1323: l_amount_includes_tax_flag AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_amtInclTaxFlag;
1324: l_justif_req AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_justificationReqdFlag;
1325:
1326: BEGIN
1327:
1328: IF (AP_WEB_DB_EXPTEMPLATE_PKG.GetExpTypesCursor(p_expense_report_id, l_expense_types_cursor)) THEN

Line 1328: IF (AP_WEB_DB_EXPTEMPLATE_PKG.GetExpTypesCursor(p_expense_report_id, l_expense_types_cursor)) THEN

1324: l_justif_req AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_justificationReqdFlag;
1325:
1326: BEGIN
1327:
1328: IF (AP_WEB_DB_EXPTEMPLATE_PKG.GetExpTypesCursor(p_expense_report_id, l_expense_types_cursor)) THEN
1329: LOOP
1330: FETCH l_expense_types_cursor
1331: INTO l_parameter_id, l_web_FriendlyPrompt,
1332: l_require_receipt_amount,