DBA Data[Home] [Help]

APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_WEB_DB_EXPTEMPLATE_PKG

Line 1360: l_expense_types_cursor AP_WEB_DB_EXPTEMPLATE_PKG.ExpenseTypesCursor;

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;

Line 1361: l_parameter_id AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;

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;

Line 1362: l_web_FriendlyPrompt AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_webFriendlyPrompt;

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;

Line 1363: l_require_receipt_amount AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_requireReceiptAmt;

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:

Line 1364: l_card_exp_type_lookup_code AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_cardExpTypeLookupCode;

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

Line 1365: l_amount_includes_tax_flag AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_amtInclTaxFlag;

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:

Line 1366: l_justif_req AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_justificationReqdFlag;

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

Line 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,