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_EXPENSE_WF dependencies on AP_EXPENSE_REPORT_LINES

Line 1222: from ap_expense_report_lines

1218: l_debug_info := 'Checking number of credit card lines with errors';
1219: ------------------------------------------------------------
1220: select count(*)
1221: into l_num_lines
1222: from ap_expense_report_lines
1223: where report_header_id = l_report_header_id
1224: and credit_card_trx_id is not null
1225: and ap_validation_error is not null;
1226:

Line 1238: from ap_expense_report_lines

1234: l_debug_info := 'Checking number of cash lines with errors';
1235: ------------------------------------------------------------
1236: select count(*)
1237: into l_num_lines
1238: from ap_expense_report_lines
1239: where report_header_id = l_report_header_id
1240: and credit_card_trx_id is null
1241: and ap_validation_error is not null;
1242:

Line 1654: from ap_expense_report_lines

1650: l_debug_info := 'Get number of line errors';
1651: -----------------------------------------------------------------
1652: select count(*)
1653: into l_num_line_errors
1654: from ap_expense_report_lines
1655: where report_header_id = l_report_header_id
1656: and ap_validation_error is not null;
1657:
1658: ----------------------------------------------------------------

Line 2621: l_debug_info := 'Update ap_expense_report_lines';

2617: NULL;
2618: END IF; /* SetExpenseHeaderInfo */
2619:
2620: ---------------------------------------------------
2621: l_debug_info := 'Update ap_expense_report_lines';
2622: ---------------------------------------------------
2623: -- 7/24: insertion of receipt_required_flag is moved to the submit package.
2624: IF (NOT AP_WEB_DB_EXPLINE_PKG.SetAWTGroupIDAndJustif(p_report_header_id,
2625: l_sys_allow_awt_flag,

Line 4298: ap_expense_report_lines with new report_header_id';

4294:
4295: IF (p_shortpay_type = 'POLICY') THEN
4296: --------------------------------------------------------------------
4297: l_debug_info := 'Insert the lines that cannot be paid into
4298: ap_expense_report_lines with new report_header_id';
4299: --------------------------------------------------------------------
4300:
4301: IF (AP_WEB_DB_EXPLINE_PKG.AddPolicyShortPaidExpLines(p_new_expense_report_id, p_orig_expense_report_id)) THEN
4302: NULL;

Line 4325: ap_expense_report_lines with new report_header_id for

4321: ELSE
4322:
4323: --------------------------------------------------------------------
4324: l_debug_info := 'Insert the lines that cannot be paid into
4325: ap_expense_report_lines with new report_header_id for
4326: missing receipts shortpay';
4327: --------------------------------------------------------------------
4328: IF (AP_WEB_DB_EXPLINE_PKG.AddUnverifiedShortpaidLines(
4329: p_new_expense_report_id, p_orig_expense_report_id)) THEN

Line 5272: update ap_expense_report_lines

5268: l_debug_info := 'Reset Receipt Verified Flag to N';
5269: ----------------------------------------------------------
5270: -- Bug 4094871
5271: begin
5272: update ap_expense_report_lines
5273: set receipt_verified_flag = l_No
5274: where report_header_id = l_report_header_id;
5275: exception
5276: when others then null;

Line 5629: update ap_expense_report_lines

5625: ----------------------------------------------------------
5626: l_debug_info := 'Reset Receipt Missing Flag';
5627: ----------------------------------------------------------
5628: -- Bug 4075372
5629: update ap_expense_report_lines
5630: set receipt_missing_flag = l_No
5631: where report_header_id = l_report_header_id;
5632:
5633: ------------------------------------------------------------

Line 5918: ap_expense_report_lines with new report_header_id';

5914: END IF;
5915:
5916: ------------------------------------------------------------------
5917: l_debug_info := 'Insert the lines for the credit card company into
5918: ap_expense_report_lines with new report_header_id';
5919: ------------------------------------------------------------------
5920: IF (NOT AP_WEB_DB_EXPLINE_PKG.AddCCReportLines(l_report_header_id,
5921: l_new_report_id)) THEN
5922: NULL;

Line 10451: update ap_expense_report_lines

10447: l_debug_info := 'Reset Receipt Verified Flag to N';
10448: ----------------------------------------------------------
10449: -- Bug 4094871
10450: begin
10451: update ap_expense_report_lines
10452: set receipt_verified_flag = l_No
10453: where report_header_id = l_report_header_id;
10454: exception
10455: when others then null;

Line 10886: p_rep_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE)

10882: | none |
10883: *----------------------------------------------------------------------------*/
10884:
10885: PROCEDURE WithdrawExpenseRep(
10886: p_rep_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE)
10887: IS
10888: l_itemkey wf_items.item_key%TYPE;
10889: l_itemtype wf_items.item_type%TYPE := 'APEXP';
10890: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;

Line 11060: update ap_expense_report_lines

11056: l_debug_info := 'Reset Receipt Verified Flag to N';
11057: ----------------------------------------------------------
11058: -- Bug 4094871
11059: begin
11060: update ap_expense_report_lines
11061: set receipt_verified_flag = l_No
11062: where report_header_id = p_rep_header_id;
11063: exception
11064: when others then null;

Line 11258: l_flex_concatenated AP_EXPENSE_REPORT_LINES.flex_concatenated%TYPE;

11254: := -1;
11255:
11256: l_document long;
11257:
11258: l_flex_concatenated AP_EXPENSE_REPORT_LINES.flex_concatenated%TYPE;
11259: l_line_accounting_enabled VARCHAR2(30);
11260: l_line_accounting_defined BOOLEAN;
11261: l_policy_violation_value VARCHAR2(50);
11262: l_policy_violation_defined BOOLEAN;

Line 11264: l_mrate_adjusted_flag AP_EXPENSE_REPORT_LINES.mileage_rate_adjusted_flag%TYPE;

11260: l_line_accounting_defined BOOLEAN;
11261: l_policy_violation_value VARCHAR2(50);
11262: l_policy_violation_defined BOOLEAN;
11263: l_n_resp_id Number;
11264: l_mrate_adjusted_flag AP_EXPENSE_REPORT_LINES.mileage_rate_adjusted_flag%TYPE;
11265: l_mileage_note VARCHAR2(2000);
11266: l_notification_type VARCHAR2(10);
11267: l_print_violation VARCHAR2(1) := 'N';
11268: l_merchant_name AP_EXPENSE_REPORT_LINES.merchant_name%TYPE;

Line 11268: l_merchant_name AP_EXPENSE_REPORT_LINES.merchant_name%TYPE;

11264: l_mrate_adjusted_flag AP_EXPENSE_REPORT_LINES.mileage_rate_adjusted_flag%TYPE;
11265: l_mileage_note VARCHAR2(2000);
11266: l_notification_type VARCHAR2(10);
11267: l_print_violation VARCHAR2(1) := 'N';
11268: l_merchant_name AP_EXPENSE_REPORT_LINES.merchant_name%TYPE;
11269: l_co_merchant_count NUMBER;
11270:
11271: l_num_both_personal_lines NUMBER := 0; --Bug 2944363
11272: l_payment VARCHAR2(10);--Bug 2944363

Line 12236: FROM ap_expense_report_lines xl

12232: l_debug_info := 'Construct Mileage Note';
12233: ------------------------------------------------------------
12234: SELECT count(*)
12235: INTO l_modified_count
12236: FROM ap_expense_report_lines xl
12237: WHERE xl.report_header_id = l_report_header_id
12238: AND xl.mileage_rate_adjusted_flag = AP_WEB_DB_EXPLINE_PKG.C_Modified;
12239:
12240: /* If the system adjusted the mileage rate by adding new lines

Line 12249: FROM ap_expense_report_lines xl

12245: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_MRATE_MODIFIED_NOTE');
12246: ELSE
12247: SELECT count(*)
12248: INTO l_new_count
12249: FROM ap_expense_report_lines xl
12250: WHERE xl.report_header_id = l_report_header_id
12251: AND (xl.mileage_rate_adjusted_flag = AP_WEB_DB_EXPLINE_PKG.C_New
12252: OR xl.mileage_rate_adjusted_flag = AP_WEB_DB_EXPLINE_PKG.C_Split);
12253:

Line 12348: FROM ap_expense_report_lines XL,

12344: l_end_expense_date,
12345: l_web_parameter_id,
12346: l_policy_id,
12347: l_currency_preference
12348: FROM ap_expense_report_lines XL,
12349: AP_EXPENSE_REPORT_HEADERS XH,
12350: AP_EXPENSE_REPORT_PARAMS XP,
12351: AP_POL_HEADERS SH
12352: WHERE XH.report_header_id = p_report_header_id

Line 12522: from ap_expense_report_lines

12518: select nvl(sum(mileage_rate),0)
12519: into l_addon_rate_sum
12520: from oie_addon_mileage_rates
12521: where report_line_id = (select report_line_id
12522: from ap_expense_report_lines
12523: where report_header_id = p_report_header_id
12524: and distribution_line_number = p_dist_line_number
12525: and rownum = 1);
12526: return l_addon_rate_sum;

Line 12654: p_new_dist_number IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,

12650:
12651: -------------------------------------------------------------------------------
12652: PROCEDURE addToMileageArray(
12653: p_index IN NUMBER,
12654: p_new_dist_number IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
12655: p_trip_dist IN AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE,
12656: p_daily_distance IN AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE,
12657: p_rate IN AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE,
12658: p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,

Line 12655: p_trip_dist IN AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE,

12651: -------------------------------------------------------------------------------
12652: PROCEDURE addToMileageArray(
12653: p_index IN NUMBER,
12654: p_new_dist_number IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
12655: p_trip_dist IN AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE,
12656: p_daily_distance IN AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE,
12657: p_rate IN AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE,
12658: p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
12659: p_from_index IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,

Line 12656: p_daily_distance IN AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE,

12652: PROCEDURE addToMileageArray(
12653: p_index IN NUMBER,
12654: p_new_dist_number IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
12655: p_trip_dist IN AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE,
12656: p_daily_distance IN AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE,
12657: p_rate IN AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE,
12658: p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
12659: p_from_index IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
12660: p_mileage_line_array IN OUT NOCOPY AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array) IS

Line 12657: p_rate IN AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE,

12653: p_index IN NUMBER,
12654: p_new_dist_number IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
12655: p_trip_dist IN AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE,
12656: p_daily_distance IN AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE,
12657: p_rate IN AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE,
12658: p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
12659: p_from_index IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
12660: p_mileage_line_array IN OUT NOCOPY AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array) IS
12661: -------------------------------------------------------------------------------

Line 12658: p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,

12654: p_new_dist_number IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
12655: p_trip_dist IN AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE,
12656: p_daily_distance IN AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE,
12657: p_rate IN AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE,
12658: p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
12659: p_from_index IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
12660: p_mileage_line_array IN OUT NOCOPY AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array) IS
12661: -------------------------------------------------------------------------------
12662: l_debug_info VARCHAR2(200);

Line 12659: p_from_index IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,

12655: p_trip_dist IN AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE,
12656: p_daily_distance IN AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE,
12657: p_rate IN AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE,
12658: p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
12659: p_from_index IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
12660: p_mileage_line_array IN OUT NOCOPY AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array) IS
12661: -------------------------------------------------------------------------------
12662: l_debug_info VARCHAR2(200);
12663:

Line 12873: FROM AP_EXPENSE_REPORT_LINES

12869: --------------------------------------------
12870:
12871: SELECT max(distribution_line_number) + 1
12872: INTO l_next_dist_number
12873: FROM AP_EXPENSE_REPORT_LINES
12874: WHERE report_header_id = p_mileage_line_array(p_ml_index).report_header_id;
12875:
12876: --------------------------------------------
12877: l_debug_info := 'Find the trip distance';

Line 12891: in ap_expense_report_lines. -Akita */

12887: /* The rate from the schedule line array is the rate stored in
12888: ap_pol_headers. The unit of measure will be according to
12889: ap_pol_headers. However, when calculating the rate for the
12890: lines, we need to get convert the rate according to the UOM
12891: in ap_expense_report_lines. -Akita */
12892: l_new_rate := getRate(
12893: p_sh_distance_uom => p_sh_distance_uom,
12894: p_sh_currency_code => p_sh_currency_code,
12895: p_mileage_line => p_mileage_line_array(p_ml_index),

Line 14876: UPDATE AP_EXPENSE_REPORT_LINES

14872: UPDATE AP_EXPENSE_REPORT_HEADERS
14873: SET DESCRIPTION= AP_WEB_UTILITIES_PKG.RtrimMultiByteSpaces(description)
14874: WHERE REPORT_HEADER_ID = p_report_header_id;
14875:
14876: UPDATE AP_EXPENSE_REPORT_LINES
14877: SET JUSTIFICATION = AP_WEB_UTILITIES_PKG.RtrimMultiByteSpaces(justification),
14878: SUBMITTED_AMOUNT = AMOUNT
14879: WHERE REPORT_HEADER_ID = p_report_header_id;
14880:

Line 14979: l_total ap_expense_report_lines.amount%type;

14975: l_report_header_id ap_expense_report_headers.report_header_id%type;
14976: l_preparer_id ap_expense_report_headers.employee_id%type;
14977: l_employee_id ap_expense_report_headers.employee_id%type;
14978: l_document_number ap_expense_report_headers.invoice_num%type;
14979: l_total ap_expense_report_lines.amount%type;
14980: l_new_total ap_expense_report_lines.amount%type;
14981: l_reimb_curr ap_expense_report_headers.default_currency_code%type;
14982: l_cost_center ap_expense_report_headers.flex_concatenated%type;
14983: l_purpose ap_expense_report_headers.description%type;

Line 14980: l_new_total ap_expense_report_lines.amount%type;

14976: l_preparer_id ap_expense_report_headers.employee_id%type;
14977: l_employee_id ap_expense_report_headers.employee_id%type;
14978: l_document_number ap_expense_report_headers.invoice_num%type;
14979: l_total ap_expense_report_lines.amount%type;
14980: l_new_total ap_expense_report_lines.amount%type;
14981: l_reimb_curr ap_expense_report_headers.default_currency_code%type;
14982: l_cost_center ap_expense_report_headers.flex_concatenated%type;
14983: l_purpose ap_expense_report_headers.description%type;
14984: l_approver_id ap_expense_report_headers.override_approver_id%type;

Line 15024: from ap_expense_report_lines aerl

15020: select sum(aerl.amount),
15021: sum(decode(sign(aerl.amount),-1,0,aerl.amount))
15022: into l_total,
15023: l_new_total
15024: from ap_expense_report_lines aerl
15025: where aerl.report_header_id = l_report_header_id
15026: and (itemization_parent_id is null OR itemization_parent_id <> -1);
15027:
15028: StartExpenseReportProcess(