1356: ) RETURN VARCHAR2 IS
1357: --------------------------------------------------------------------------------
1358: l_cost_center varchar2(200);
1359: l_cc_exist varchar2(1) := 'N';
1360: l_expense_types_cursor AP_WEB_DB_EXPTEMPLATE_PKG.ExpenseTypesCursor;
1361: l_parameter_id AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1362: l_web_FriendlyPrompt AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_webFriendlyPrompt;
1363: l_require_receipt_amount AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_requireReceiptAmt;
1364: l_card_exp_type_lookup_code AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_cardExpTypeLookupCode;
1357: --------------------------------------------------------------------------------
1358: l_cost_center varchar2(200);
1359: l_cc_exist varchar2(1) := 'N';
1360: l_expense_types_cursor AP_WEB_DB_EXPTEMPLATE_PKG.ExpenseTypesCursor;
1361: l_parameter_id AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1362: l_web_FriendlyPrompt AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_webFriendlyPrompt;
1363: l_require_receipt_amount AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_requireReceiptAmt;
1364: l_card_exp_type_lookup_code AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_cardExpTypeLookupCode;
1365: l_amount_includes_tax_flag AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_amtInclTaxFlag;
1358: l_cost_center varchar2(200);
1359: l_cc_exist varchar2(1) := 'N';
1360: l_expense_types_cursor AP_WEB_DB_EXPTEMPLATE_PKG.ExpenseTypesCursor;
1361: l_parameter_id AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1362: l_web_FriendlyPrompt AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_webFriendlyPrompt;
1363: l_require_receipt_amount AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_requireReceiptAmt;
1364: l_card_exp_type_lookup_code AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_cardExpTypeLookupCode;
1365: l_amount_includes_tax_flag AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_amtInclTaxFlag;
1366: l_justif_req AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_justificationReqdFlag;
1359: l_cc_exist varchar2(1) := 'N';
1360: l_expense_types_cursor AP_WEB_DB_EXPTEMPLATE_PKG.ExpenseTypesCursor;
1361: l_parameter_id AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1362: l_web_FriendlyPrompt AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_webFriendlyPrompt;
1363: l_require_receipt_amount AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_requireReceiptAmt;
1364: l_card_exp_type_lookup_code AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_cardExpTypeLookupCode;
1365: l_amount_includes_tax_flag AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_amtInclTaxFlag;
1366: l_justif_req AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_justificationReqdFlag;
1367:
1360: l_expense_types_cursor AP_WEB_DB_EXPTEMPLATE_PKG.ExpenseTypesCursor;
1361: l_parameter_id AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1362: l_web_FriendlyPrompt AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_webFriendlyPrompt;
1363: l_require_receipt_amount AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_requireReceiptAmt;
1364: l_card_exp_type_lookup_code AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_cardExpTypeLookupCode;
1365: l_amount_includes_tax_flag AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_amtInclTaxFlag;
1366: l_justif_req AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_justificationReqdFlag;
1367:
1368: BEGIN
1361: l_parameter_id AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1362: l_web_FriendlyPrompt AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_webFriendlyPrompt;
1363: l_require_receipt_amount AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_requireReceiptAmt;
1364: l_card_exp_type_lookup_code AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_cardExpTypeLookupCode;
1365: l_amount_includes_tax_flag AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_amtInclTaxFlag;
1366: l_justif_req AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_justificationReqdFlag;
1367:
1368: BEGIN
1369:
1362: l_web_FriendlyPrompt AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_webFriendlyPrompt;
1363: l_require_receipt_amount AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_requireReceiptAmt;
1364: l_card_exp_type_lookup_code AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_cardExpTypeLookupCode;
1365: l_amount_includes_tax_flag AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_amtInclTaxFlag;
1366: l_justif_req AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_justificationReqdFlag;
1367:
1368: BEGIN
1369:
1370: IF (AP_WEB_DB_EXPTEMPLATE_PKG.GetExpTypesCursor(p_expense_report_id, l_expense_types_cursor)) THEN
1366: l_justif_req AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_justificationReqdFlag;
1367:
1368: BEGIN
1369:
1370: IF (AP_WEB_DB_EXPTEMPLATE_PKG.GetExpTypesCursor(p_expense_report_id, l_expense_types_cursor)) THEN
1371: LOOP
1372: FETCH l_expense_types_cursor
1373: INTO l_parameter_id, l_web_FriendlyPrompt,
1374: l_require_receipt_amount,