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_EXPLINE_PKG dependencies on AP_WEB_DB_EXPLINE_PKG

Line 1: PACKAGE BODY AP_WEB_DB_EXPLINE_PKG AS

1: PACKAGE BODY AP_WEB_DB_EXPLINE_PKG AS
2: /* $Header: apwdbelb.pls 120.138.12020000.3 2013/03/05 10:05:43 preshukl ship $ */
3:
4:
5: --------------------------------------------------------------------------------

Line 2058: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'Start InsertCCLine');

2054: DL.ITEMIZATION_PARENT_ID <> -1);
2055:
2056: BEGIN
2057:
2058: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'Start InsertCCLine');
2059:
2060: SELECT AP_WEB_DB_AP_INT_PKG.GetExpenseClearingCCID(credit_card_trx_id)
2061: INTO l_clearning_ccid
2062: FROM ap_expense_report_lines erl

Line 2307: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end InsertCCLine');

2303: AP_WEB_DB_EXPRPT_PKG.CopyAttachments(p_report_line_id,
2304: p_new_report_line_id,
2305: 'OIE_LINE_ATTACHMENTS');
2306:
2307: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end InsertCCLine');
2308:
2309: EXCEPTION
2310: WHEN OTHERS THEN
2311: AP_WEB_DB_UTIL_PKG.RaiseException('InsertCCLine');

Line 2341: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',

2337: AND ITEMIZATION_PARENT_ID = p_source_parent_report_line_id;
2338:
2339: BEGIN
2340:
2341: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',
2342: 'start CopyCCItemizationChildLines');
2343:
2344: FOR i in ReportLines LOOP
2345:

Line 2359: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',

2355: p_distribution_line_number => l_NewReportLineID);
2356:
2357: END LOOP;
2358:
2359: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',
2360: 'end CopyCCItemizationChildLines');
2361:
2362: EXCEPTION
2363: WHEN OTHERS THEN

Line 2786: l_cCardLineCursor AP_WEB_DB_EXPLINE_PKG.CCTrxnCursor;

2782: p_invAmt IN OUT NOCOPY VARCHAR2) IS
2783: --------------------------------------------------------------------------------
2784: l_prepaid_amt expLines_amount;
2785: l_parameterId number;
2786: l_cCardLineCursor AP_WEB_DB_EXPLINE_PKG.CCTrxnCursor;
2787: l_invoiceAmt AP_WEB_DB_AP_INT_PKG.invLines_amount := 0;
2788: l_baseAmt AP_WEB_DB_AP_INT_PKG.invAll_baseAmount;
2789: l_totalCCardAmt NUMBER := 0;
2790: l_prepaidInvId AP_WEB_DB_CCARD_PKG.ccTrxn_companyPrepaidInvID;

Line 2791: l_cCardLineAmt AP_WEB_DB_EXPLINE_PKG.expLines_amount;

2787: l_invoiceAmt AP_WEB_DB_AP_INT_PKG.invLines_amount := 0;
2788: l_baseAmt AP_WEB_DB_AP_INT_PKG.invAll_baseAmount;
2789: l_totalCCardAmt NUMBER := 0;
2790: l_prepaidInvId AP_WEB_DB_CCARD_PKG.ccTrxn_companyPrepaidInvID;
2791: l_cCardLineAmt AP_WEB_DB_EXPLINE_PKG.expLines_amount;
2792: l_cardProgramID NUMBER;
2793: l_Personal VARCHAR2(10);
2794: l_debugInfo VARCHAR2(2000);
2795: l_transaction_date DATE;

Line 2824: IF (AP_WEB_DB_EXPLINE_PKG.GetCCardLineCursor(

2820: */
2821: ------------------------------------------------------------------
2822: l_debugInfo := 'Get the credit card report line cursor.';
2823: ----------------------------------------------------------------
2824: IF (AP_WEB_DB_EXPLINE_PKG.GetCCardLineCursor(
2825: p_expReportHeaderId,
2826: l_cCardLineCursor) = TRUE) THEN
2827:
2828:

Line 3060: l_new_report_line_id AP_WEB_DB_EXPLINE_PKG.expLines_report_line_id;

3056: i NUMBER := 1;
3057: l_amount NUMBER;
3058: l_tab_idx NUMBER;
3059: l_report_header_id expLines_headerID := p_mileage_line_array(i).report_header_id;
3060: l_new_report_line_id AP_WEB_DB_EXPLINE_PKG.expLines_report_line_id;
3061: l_parent_line_number NUMBER;
3062: l_currency_code VARCHAR2(10);
3063:
3064: BEGIN

Line 3448: AP_WEB_DB_EXPLINE_PKG.C_New,

3444: FLIGHT_NUMBER,
3445: LOCATION_TO_ID,
3446: ITEMIZATION_PARENT_ID,
3447: FLEX_CONCATENATED,
3448: AP_WEB_DB_EXPLINE_PKG.C_New,
3449: FUNC_CURRENCY_AMT,
3450: CATEGORY_CODE,
3451: ADJUSTMENT_REASON_CODE,
3452: LOCATION,

Line 3577: START_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward,

3573: CREATED_BY,
3574: CREATION_DATE)
3575: SELECT OIE_PDM_DAILY_BREAKUPS_S.nextval,
3576: p_to_report_line_id,
3577: START_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward,
3578: END_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward,
3579: AMOUNT,
3580: NUMBER_OF_MEALS,
3581: MEALS_AMOUNT,

Line 3578: END_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward,

3574: CREATION_DATE)
3575: SELECT OIE_PDM_DAILY_BREAKUPS_S.nextval,
3576: p_to_report_line_id,
3577: START_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward,
3578: END_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward,
3579: AMOUNT,
3580: NUMBER_OF_MEALS,
3581: MEALS_AMOUNT,
3582: BREAKFAST_FLAG,

Line 3628: START_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward,

3624: CREATED_BY,
3625: CREATION_DATE)
3626: SELECT OIE_PDM_DESTINATIONS_S.nextval,
3627: p_to_report_line_id,
3628: START_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward,
3629: END_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward,
3630: LOCATION_ID,
3631: SYSDATE,
3632: LAST_UPDATED_BY,

Line 3629: END_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward,

3625: CREATION_DATE)
3626: SELECT OIE_PDM_DESTINATIONS_S.nextval,
3627: p_to_report_line_id,
3628: START_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward,
3629: END_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward,
3630: LOCATION_ID,
3631: SYSDATE,
3632: LAST_UPDATED_BY,
3633: LAST_UPDATE_LOGIN,

Line 3681: SELECT report_line_id, receipt_currency_code, currency_code, (start_expense_date+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward), receipt_currency_amount

3677: -- l_display_inverse_profile fnd_profile_option_values.profile_option_value%type;
3678:
3679: -- Bug 7555144 - Changing the order to match with the from and to currencies
3680: CURSOR ReportLines IS
3681: SELECT report_line_id, receipt_currency_code, currency_code, (start_expense_date+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward), receipt_currency_amount
3682: FROM AP_EXPENSE_REPORT_LINES
3683: WHERE REPORT_HEADER_ID = P_source_report_header_id
3684: AND CREDIT_CARD_TRX_ID is null
3685: AND ITEMIZATION_PARENT_ID = p_source_parent_report_line_id;

Line 3698: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',

3694: l_parent_line_rec update_new_parent_line_amt_c%ROWTYPE;
3695:
3696: BEGIN
3697:
3698: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',
3699: 'start CopyItemizationChildLines');
3700: l_lines_total:=0;
3701: -- Find all lines associated with this report
3702: OPEN ReportLines;

Line 3914: (START_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward) as EXCHANGE_DATE,

3910: ATTRIBUTE15,
3911: CURRENCY_CODE,
3912: EXCHANGE_RATE_TYPE,
3913: EXCHANGE_RATE,
3914: (START_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward) as EXCHANGE_DATE,
3915: VAT_CODE,
3916: LINE_TYPE_LOOKUP_CODE,
3917: PROJECT_ACCOUNTING_CONTEXT,
3918: EXPENDITURE_TYPE,

Line 3946: START_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward AS START_EXPENSE_DATE, -- roll forward 7 days

3942: GLOBAL_ATTRIBUTE19,
3943: GLOBAL_ATTRIBUTE20,
3944: JUSTIFICATION,
3945: EXPENSE_GROUP,
3946: START_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward AS START_EXPENSE_DATE, -- roll forward 7 days
3947: END_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward AS END_EXPENSE_DATE, -- roll forward 7 days
3948: RECEIPT_CURRENCY_CODE,
3949: l_Receipt_Conversion_Rate, -- Bug 6689280 (sodash) reclculating the receipt conversion rate. Prior to it, It was getting set to null when the receipt currency and the reimbursement currency didn't match
3950: DAILY_AMOUNT,

Line 3947: END_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward AS END_EXPENSE_DATE, -- roll forward 7 days

3943: GLOBAL_ATTRIBUTE20,
3944: JUSTIFICATION,
3945: EXPENSE_GROUP,
3946: START_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward AS START_EXPENSE_DATE, -- roll forward 7 days
3947: END_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward AS END_EXPENSE_DATE, -- roll forward 7 days
3948: RECEIPT_CURRENCY_CODE,
3949: l_Receipt_Conversion_Rate, -- Bug 6689280 (sodash) reclculating the receipt conversion rate. Prior to it, It was getting set to null when the receipt currency and the reimbursement currency didn't match
3950: DAILY_AMOUNT,
3951: RECEIPT_CURRENCY_AMOUNT,

Line 4059: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',

4055: WHERE CURRENT OF update_new_parent_line_amt_c;
4056:
4057: CLOSE update_new_parent_line_amt_c;
4058:
4059: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',
4060: 'end CopyItemizationChildLines');
4061:
4062: END CopyItemizationChildLines;
4063:

Line 4097: SELECT report_line_id, itemization_parent_id, receipt_currency_code, currency_code, (start_expense_date+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward), receipt_currency_amount

4093: l_exchange_rate_allowance NUMBER;
4094:
4095: -- Bug 7555144 - Changing the Order to match with the from and to currencies
4096: CURSOR ReportLines IS
4097: SELECT report_line_id, itemization_parent_id, receipt_currency_code, currency_code, (start_expense_date+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward), receipt_currency_amount
4098: FROM AP_EXPENSE_REPORT_LINES
4099: WHERE REPORT_HEADER_ID = P_source_report_header_id
4100: AND CREDIT_CARD_TRX_ID is null
4101: AND (ITEMIZATION_PARENT_ID is null

Line 4107: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',

4103: ITEMIZATION_PARENT_ID = -1);
4104:
4105: BEGIN
4106:
4107: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',
4108: 'start DuplicateLines');
4109:
4110: -- Find all lines associated with this report
4111: OPEN ReportLines;

Line 4325: START_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward AS EXCHANGE_DATE, -- bug 6689280 (sodash)

4321: ATTRIBUTE15,
4322: CURRENCY_CODE,
4323: EXCHANGE_RATE_TYPE,
4324: EXCHANGE_RATE, -- Bug 6689280 (sodash)
4325: START_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward AS EXCHANGE_DATE, -- bug 6689280 (sodash)
4326: VAT_CODE,
4327: LINE_TYPE_LOOKUP_CODE,
4328: PROJECT_ACCOUNTING_CONTEXT,
4329: EXPENDITURE_TYPE,

Line 4332: AP_WEB_DB_EXPLINE_PKG.C_InitialDistLineNumber+DISTRIBUTION_LINE_NUMBER,

4328: PROJECT_ACCOUNTING_CONTEXT,
4329: EXPENDITURE_TYPE,
4330: EXPENDITURE_ITEM_DATE,
4331: PA_QUANTITY,
4332: AP_WEB_DB_EXPLINE_PKG.C_InitialDistLineNumber+DISTRIBUTION_LINE_NUMBER,
4333: ORG_ID,
4334: GLOBAL_ATTRIBUTE_CATEGORY,
4335: GLOBAL_ATTRIBUTE1,
4336: GLOBAL_ATTRIBUTE2,

Line 4357: START_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward AS START_EXPENSE_DATE, -- roll forward 7 days

4353: GLOBAL_ATTRIBUTE19,
4354: GLOBAL_ATTRIBUTE20,
4355: JUSTIFICATION,
4356: EXPENSE_GROUP,
4357: START_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward AS START_EXPENSE_DATE, -- roll forward 7 days
4358: END_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward AS END_EXPENSE_DATE, -- roll forward 7 days
4359: RECEIPT_CURRENCY_CODE,
4360: l_Receipt_Conversion_Rate, -- Bug 6689280 (sodash) reclculating the receipt conversion rate. Prior to it, It was getting set to null when the receipt currency and the reimbursement currency didn't match
4361: DAILY_AMOUNT,

Line 4358: END_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward AS END_EXPENSE_DATE, -- roll forward 7 days

4354: GLOBAL_ATTRIBUTE20,
4355: JUSTIFICATION,
4356: EXPENSE_GROUP,
4357: START_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward AS START_EXPENSE_DATE, -- roll forward 7 days
4358: END_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward AS END_EXPENSE_DATE, -- roll forward 7 days
4359: RECEIPT_CURRENCY_CODE,
4360: l_Receipt_Conversion_Rate, -- Bug 6689280 (sodash) reclculating the receipt conversion rate. Prior to it, It was getting set to null when the receipt currency and the reimbursement currency didn't match
4361: DAILY_AMOUNT,
4362: RECEIPT_CURRENCY_AMOUNT,

Line 4467: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',

4463: END LOOP;
4464:
4465: CLOSE ReportLines;
4466:
4467: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',
4468: 'end DuplicateLines');
4469:
4470: END DuplicateLines;
4471:

Line 4478: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'start ResetAPValidationErrors');

4474: p_report_header_id IN expLines_headerID) IS
4475: -------------------------------------------------------------------
4476: BEGIN
4477:
4478: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'start ResetAPValidationErrors');
4479:
4480: UPDATE ap_expense_report_lines
4481: SET ap_validation_error = ''
4482: WHERE report_header_id = p_report_header_id;

Line 4484: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end ResetAPValidationErrors');

4480: UPDATE ap_expense_report_lines
4481: SET ap_validation_error = ''
4482: WHERE report_header_id = p_report_header_id;
4483:
4484: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end ResetAPValidationErrors');
4485:
4486: EXCEPTION
4487: WHEN NO_DATA_FOUND THEN
4488: AP_WEB_DB_UTIL_PKG.RaiseException('ResetAPValidationErrors');

Line 4504: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'start UpdateAPValidationError');

4500: p_ap_validation_error IN expLines_APValidationError) IS
4501: -------------------------------------------------------------------
4502: BEGIN
4503:
4504: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'start UpdateAPValidationError');
4505:
4506: /* Bug 3637166 : Doing a substrb before updation */
4507:
4508: UPDATE ap_expense_report_lines

Line 4513: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end UpdateAPValidationError');

4509: SET ap_validation_error = substrb(ap_validation_error||p_ap_validation_error,1,240)
4510: WHERE report_header_id = p_report_header_id
4511: AND distribution_line_number = p_dist_line_number;
4512:
4513: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end UpdateAPValidationError');
4514:
4515: EXCEPTION
4516: WHEN NO_DATA_FOUND THEN
4517: AP_WEB_DB_UTIL_PKG.RaiseException('UpdateAPValidationError');

Line 4531: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'start resetAPflags');

4527: p_report_header_id IN expLines_headerID) IS
4528: -------------------------------------------------------------------
4529: BEGIN
4530:
4531: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'start resetAPflags');
4532:
4533: UPDATE ap_expense_report_lines
4534: SET receipt_verified_flag = null,
4535: policy_shortpay_flag = null,

Line 4544: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end resetAPflags');

4540: SET audit_code = null, -- Bug 4019412
4541: report_submitted_date = null
4542: WHERE report_header_id = p_report_header_id;
4543:
4544: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end resetAPflags');
4545:
4546: EXCEPTION
4547: WHEN NO_DATA_FOUND THEN
4548: AP_WEB_DB_UTIL_PKG.RaiseException('resetAPflags');

Line 4966: IF (NOT AP_WEB_DB_EXPLINE_PKG.GetPersonalTotalOfExpRpt(p_report_header_id, l_personal_total)) THEN

4962: * depending on the scenario.
4963: */
4964: IF (p_payment_due_from = AP_WEB_EXPENSE_WF.C_CompanyPay) THEN
4965:
4966: IF (NOT AP_WEB_DB_EXPLINE_PKG.GetPersonalTotalOfExpRpt(p_report_header_id, l_personal_total)) THEN
4967: l_personal_total := 0;
4968: END IF;
4969: /**
4970: * For company pay the amount due employee is the total of cash lines subtracted with the personal

Line 5382: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'start resetApplyAdvances');

5378: p_report_header_id IN expLines_headerID) IS
5379: -------------------------------------------------------------------
5380: BEGIN
5381:
5382: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'start resetApplyAdvances');
5383:
5384: -- bug : 4001778/3654956
5385: UPDATE ap_expense_report_headers_all
5386: SET maximum_amount_to_apply = null,

Line 5397: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end resetApplyAdvances');

5393: prepay_gl_date = null,
5394: advances_justification = null
5395: WHERE report_header_id = p_report_header_id;
5396:
5397: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end resetApplyAdvances');
5398:
5399: EXCEPTION
5400: WHEN NO_DATA_FOUND THEN
5401: AP_WEB_DB_UTIL_PKG.RaiseException('resetApplyAdvances');

Line 5519: END AP_WEB_DB_EXPLINE_PKG;

5515: return FALSE;
5516:
5517: END GetNumBothShortpaidLines;
5518:
5519: END AP_WEB_DB_EXPLINE_PKG;