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.113.12010000.5 2008/12/02 07:01:14 meesubra ship $ */
3:
4:
5: --------------------------------------------------------------------------------

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

1810: DL.ITEMIZATION_PARENT_ID <> -1);
1811:
1812: BEGIN
1813:
1814: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'Start InsertCCLine');
1815:
1816: SELECT AP_WEB_DB_AP_INT_PKG.GetExpenseClearingCCID(credit_card_trx_id)
1817: INTO l_clearning_ccid
1818: FROM ap_expense_report_lines erl

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

2054: END LOOP;
2055: CLOSE copy_dist;
2056:
2057:
2058: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end InsertCCLine');
2059:
2060: EXCEPTION
2061: WHEN OTHERS THEN
2062: AP_WEB_DB_UTIL_PKG.RaiseException('InsertCCLine');

Line 2092: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',

2088: AND ITEMIZATION_PARENT_ID = p_source_parent_report_line_id;
2089:
2090: BEGIN
2091:
2092: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',
2093: 'start CopyCCItemizationChildLines');
2094:
2095: FOR i in ReportLines LOOP
2096:

Line 2110: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',

2106: p_distribution_line_number => l_NewReportLineID);
2107:
2108: END LOOP;
2109:
2110: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',
2111: 'end CopyCCItemizationChildLines');
2112:
2113: EXCEPTION
2114: WHEN OTHERS THEN

Line 2529: l_cCardLineCursor AP_WEB_DB_EXPLINE_PKG.CCTrxnCursor;

2525: p_invAmt IN OUT NOCOPY VARCHAR2) IS
2526: --------------------------------------------------------------------------------
2527: l_prepaid_amt expLines_amount;
2528: l_parameterId number;
2529: l_cCardLineCursor AP_WEB_DB_EXPLINE_PKG.CCTrxnCursor;
2530: l_invoiceAmt AP_WEB_DB_AP_INT_PKG.invLines_amount := 0;
2531: l_baseAmt AP_WEB_DB_AP_INT_PKG.invAll_baseAmount;
2532: l_totalCCardAmt NUMBER := 0;
2533: l_prepaidInvId AP_WEB_DB_CCARD_PKG.ccTrxn_companyPrepaidInvID;

Line 2534: l_cCardLineAmt AP_WEB_DB_EXPLINE_PKG.expLines_amount;

2530: l_invoiceAmt AP_WEB_DB_AP_INT_PKG.invLines_amount := 0;
2531: l_baseAmt AP_WEB_DB_AP_INT_PKG.invAll_baseAmount;
2532: l_totalCCardAmt NUMBER := 0;
2533: l_prepaidInvId AP_WEB_DB_CCARD_PKG.ccTrxn_companyPrepaidInvID;
2534: l_cCardLineAmt AP_WEB_DB_EXPLINE_PKG.expLines_amount;
2535: l_cardProgramID NUMBER;
2536: l_Personal VARCHAR2(10);
2537: l_debugInfo VARCHAR2(2000);
2538: l_transaction_date DATE;

Line 2567: IF (AP_WEB_DB_EXPLINE_PKG.GetCCardLineCursor(

2563: */
2564: ------------------------------------------------------------------
2565: l_debugInfo := 'Get the credit card report line cursor.';
2566: ----------------------------------------------------------------
2567: IF (AP_WEB_DB_EXPLINE_PKG.GetCCardLineCursor(
2568: p_expReportHeaderId,
2569: l_cCardLineCursor) = TRUE) THEN
2570:
2571:

Line 2790: l_new_report_line_id AP_WEB_DB_EXPLINE_PKG.expLines_report_line_id;

2786: i NUMBER := 1;
2787: l_amount NUMBER;
2788: l_tab_idx NUMBER;
2789: l_report_header_id expLines_headerID := p_mileage_line_array(i).report_header_id;
2790: l_new_report_line_id AP_WEB_DB_EXPLINE_PKG.expLines_report_line_id;
2791:
2792: BEGIN
2793:
2794: l_tab_idx := p_mileage_line_array.FIRST;

Line 3163: AP_WEB_DB_EXPLINE_PKG.C_New,

3159: FLIGHT_NUMBER,
3160: LOCATION_TO_ID,
3161: ITEMIZATION_PARENT_ID,
3162: FLEX_CONCATENATED,
3163: AP_WEB_DB_EXPLINE_PKG.C_New,
3164: FUNC_CURRENCY_AMT,
3165: CATEGORY_CODE,
3166: ADJUSTMENT_REASON_CODE,
3167: LOCATION,

Line 3292: START_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward,

3288: CREATED_BY,
3289: CREATION_DATE)
3290: SELECT OIE_PDM_DAILY_BREAKUPS_S.nextval,
3291: p_to_report_line_id,
3292: START_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward,
3293: END_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward,
3294: AMOUNT,
3295: NUMBER_OF_MEALS,
3296: MEALS_AMOUNT,

Line 3293: END_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward,

3289: CREATION_DATE)
3290: SELECT OIE_PDM_DAILY_BREAKUPS_S.nextval,
3291: p_to_report_line_id,
3292: START_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward,
3293: END_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward,
3294: AMOUNT,
3295: NUMBER_OF_MEALS,
3296: MEALS_AMOUNT,
3297: BREAKFAST_FLAG,

Line 3343: START_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward,

3339: CREATED_BY,
3340: CREATION_DATE)
3341: SELECT OIE_PDM_DESTINATIONS_S.nextval,
3342: p_to_report_line_id,
3343: START_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward,
3344: END_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward,
3345: LOCATION_ID,
3346: SYSDATE,
3347: LAST_UPDATED_BY,

Line 3344: END_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward,

3340: CREATION_DATE)
3341: SELECT OIE_PDM_DESTINATIONS_S.nextval,
3342: p_to_report_line_id,
3343: START_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward,
3344: END_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward,
3345: LOCATION_ID,
3346: SYSDATE,
3347: LAST_UPDATED_BY,
3348: LAST_UPDATE_LOGIN,

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

3390: -- l_display_inverse_profile fnd_profile_option_values.profile_option_value%type;
3391:
3392: -- Bug 7555144 - Changing the order to match with the from and to currencies
3393: CURSOR ReportLines IS
3394: SELECT report_line_id, receipt_currency_code, currency_code, (start_expense_date+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward), receipt_currency_amount
3395: FROM AP_EXPENSE_REPORT_LINES
3396: WHERE REPORT_HEADER_ID = P_source_report_header_id
3397: AND CREDIT_CARD_TRX_ID is null
3398: AND ITEMIZATION_PARENT_ID = p_source_parent_report_line_id;

Line 3411: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',

3407: l_parent_line_rec update_new_parent_line_amt_c%ROWTYPE;
3408:
3409: BEGIN
3410:
3411: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',
3412: 'start CopyItemizationChildLines');
3413: l_lines_total:=0;
3414: -- Find all lines associated with this report
3415: OPEN ReportLines;

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

3614: ATTRIBUTE15,
3615: CURRENCY_CODE,
3616: EXCHANGE_RATE_TYPE,
3617: EXCHANGE_RATE,
3618: (START_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward) as EXCHANGE_DATE,
3619: VAT_CODE,
3620: LINE_TYPE_LOOKUP_CODE,
3621: PROJECT_ACCOUNTING_CONTEXT,
3622: EXPENDITURE_TYPE,

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

3646: GLOBAL_ATTRIBUTE19,
3647: GLOBAL_ATTRIBUTE20,
3648: JUSTIFICATION,
3649: EXPENSE_GROUP,
3650: START_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward AS START_EXPENSE_DATE, -- roll forward 7 days
3651: END_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward AS END_EXPENSE_DATE, -- roll forward 7 days
3652: RECEIPT_CURRENCY_CODE,
3653: 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
3654: DAILY_AMOUNT,

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

3647: GLOBAL_ATTRIBUTE20,
3648: JUSTIFICATION,
3649: EXPENSE_GROUP,
3650: START_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward AS START_EXPENSE_DATE, -- roll forward 7 days
3651: END_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward AS END_EXPENSE_DATE, -- roll forward 7 days
3652: RECEIPT_CURRENCY_CODE,
3653: 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
3654: DAILY_AMOUNT,
3655: RECEIPT_CURRENCY_AMOUNT,

Line 3761: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',

3757: WHERE CURRENT OF update_new_parent_line_amt_c;
3758:
3759: CLOSE update_new_parent_line_amt_c;
3760:
3761: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',
3762: 'end CopyItemizationChildLines');
3763:
3764: END CopyItemizationChildLines;
3765:

Line 3797: 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

3793: l_itemization_parent_id AP_EXPENSE_REPORT_LINES.itemization_parent_id%type;
3794:
3795: -- Bug 7555144 - Changing the Order to match with the from and to currencies
3796: CURSOR ReportLines IS
3797: 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
3798: FROM AP_EXPENSE_REPORT_LINES
3799: WHERE REPORT_HEADER_ID = P_source_report_header_id
3800: AND CREDIT_CARD_TRX_ID is null
3801: AND (ITEMIZATION_PARENT_ID is null

Line 3807: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',

3803: ITEMIZATION_PARENT_ID = -1);
3804:
3805: BEGIN
3806:
3807: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',
3808: 'start DuplicateLines');
3809:
3810: -- Find all lines associated with this report
3811: OPEN ReportLines;

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

4009: ATTRIBUTE15,
4010: CURRENCY_CODE,
4011: EXCHANGE_RATE_TYPE,
4012: EXCHANGE_RATE, -- Bug 6689280 (sodash)
4013: START_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward AS EXCHANGE_DATE, -- bug 6689280 (sodash)
4014: VAT_CODE,
4015: LINE_TYPE_LOOKUP_CODE,
4016: PROJECT_ACCOUNTING_CONTEXT,
4017: EXPENDITURE_TYPE,

Line 4020: AP_WEB_DB_EXPLINE_PKG.C_InitialDistLineNumber+DISTRIBUTION_LINE_NUMBER,

4016: PROJECT_ACCOUNTING_CONTEXT,
4017: EXPENDITURE_TYPE,
4018: EXPENDITURE_ITEM_DATE,
4019: PA_QUANTITY,
4020: AP_WEB_DB_EXPLINE_PKG.C_InitialDistLineNumber+DISTRIBUTION_LINE_NUMBER,
4021: ORG_ID,
4022: GLOBAL_ATTRIBUTE_CATEGORY,
4023: GLOBAL_ATTRIBUTE1,
4024: GLOBAL_ATTRIBUTE2,

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

4041: GLOBAL_ATTRIBUTE19,
4042: GLOBAL_ATTRIBUTE20,
4043: JUSTIFICATION,
4044: EXPENSE_GROUP,
4045: START_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward AS START_EXPENSE_DATE, -- roll forward 7 days
4046: END_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward AS END_EXPENSE_DATE, -- roll forward 7 days
4047: RECEIPT_CURRENCY_CODE,
4048: 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
4049: DAILY_AMOUNT,

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

4042: GLOBAL_ATTRIBUTE20,
4043: JUSTIFICATION,
4044: EXPENSE_GROUP,
4045: START_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward AS START_EXPENSE_DATE, -- roll forward 7 days
4046: END_EXPENSE_DATE+AP_WEB_DB_EXPLINE_PKG.C_NumDaysRollForward AS END_EXPENSE_DATE, -- roll forward 7 days
4047: RECEIPT_CURRENCY_CODE,
4048: 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
4049: DAILY_AMOUNT,
4050: RECEIPT_CURRENCY_AMOUNT,

Line 4153: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',

4149: END LOOP;
4150:
4151: CLOSE ReportLines;
4152:
4153: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',
4154: 'end DuplicateLines');
4155:
4156: END DuplicateLines;
4157:

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

4160: p_report_header_id IN expLines_headerID) IS
4161: -------------------------------------------------------------------
4162: BEGIN
4163:
4164: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'start ResetAPValidationErrors');
4165:
4166: UPDATE ap_expense_report_lines
4167: SET ap_validation_error = ''
4168: WHERE report_header_id = p_report_header_id;

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

4166: UPDATE ap_expense_report_lines
4167: SET ap_validation_error = ''
4168: WHERE report_header_id = p_report_header_id;
4169:
4170: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end ResetAPValidationErrors');
4171:
4172: EXCEPTION
4173: WHEN NO_DATA_FOUND THEN
4174: AP_WEB_DB_UTIL_PKG.RaiseException('ResetAPValidationErrors');

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

4186: p_ap_validation_error IN expLines_APValidationError) IS
4187: -------------------------------------------------------------------
4188: BEGIN
4189:
4190: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'start UpdateAPValidationError');
4191:
4192: /* Bug 3637166 : Doing a substrb before updation */
4193:
4194: UPDATE ap_expense_report_lines

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

4195: SET ap_validation_error = substrb(ap_validation_error||p_ap_validation_error,1,240)
4196: WHERE report_header_id = p_report_header_id
4197: AND distribution_line_number = p_dist_line_number;
4198:
4199: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end UpdateAPValidationError');
4200:
4201: EXCEPTION
4202: WHEN NO_DATA_FOUND THEN
4203: AP_WEB_DB_UTIL_PKG.RaiseException('UpdateAPValidationError');

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

4213: p_report_header_id IN expLines_headerID) IS
4214: -------------------------------------------------------------------
4215: BEGIN
4216:
4217: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'start resetAPflags');
4218:
4219: UPDATE ap_expense_report_lines
4220: SET receipt_verified_flag = null,
4221: policy_shortpay_flag = null,

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

4226: SET audit_code = null, -- Bug 4019412
4227: report_submitted_date = null
4228: WHERE report_header_id = p_report_header_id;
4229:
4230: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end resetAPflags');
4231:
4232: EXCEPTION
4233: WHEN NO_DATA_FOUND THEN
4234: AP_WEB_DB_UTIL_PKG.RaiseException('resetAPflags');

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

4648: * depending on the scenario.
4649: */
4650: IF (p_payment_due_from = AP_WEB_EXPENSE_WF.C_CompanyPay) THEN
4651:
4652: IF (NOT AP_WEB_DB_EXPLINE_PKG.GetPersonalTotalOfExpRpt(p_report_header_id, l_personal_total)) THEN
4653: l_personal_total := 0;
4654: END IF;
4655: /**
4656: * For company pay the amount due employee is the total of cash lines subtracted with the personal

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

5062: p_report_header_id IN expLines_headerID) IS
5063: -------------------------------------------------------------------
5064: BEGIN
5065:
5066: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'start resetApplyAdvances');
5067:
5068: -- bug : 4001778/3654956
5069: UPDATE ap_expense_report_headers_all
5070: SET maximum_amount_to_apply = null,

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

5077: prepay_gl_date = null,
5078: advances_justification = null
5079: WHERE report_header_id = p_report_header_id;
5080:
5081: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end resetApplyAdvances');
5082:
5083: EXCEPTION
5084: WHEN NO_DATA_FOUND THEN
5085: AP_WEB_DB_UTIL_PKG.RaiseException('resetApplyAdvances');

Line 5115: END AP_WEB_DB_EXPLINE_PKG;

5111: RETURN l_cc_lines_exist;
5112:
5113: END ReportInclsCCardLines;
5114:
5115: END AP_WEB_DB_EXPLINE_PKG;