APPS.AP_WEB_DB_EXPLINE_PKG dependencies on AP_EXPENSE_REPORT_LINES_ALL

Line 916: from ap_expense_report_lines_all

912: select sum(daily_amount *
913: LPAD(to_char((nvl(end_expense_date,start_expense_date) -
914: start_expense_date)+1),4)) violation_total
915: into p_sum_violations
916: from ap_expense_report_lines_all
917: where report_header_id = p_report_header_id
918: and amount >= 0
919: and receipt_missing_flag <> 'Y'
920: and distribution_line_number in (

Line 1556: UPDATE AP_EXPENSE_REPORT_LINES_ALL

1552: LOOP
1553: FETCH ReportLines into l_OrigReportLineID, l_itemization_parent_id;
1554: EXIT WHEN ReportLines%NOTFOUND;
1555:
1556: UPDATE AP_EXPENSE_REPORT_LINES_ALL
1557: SET report_header_id = p_new_expense_report_id,
1558: mileage_rate_adjusted_flag = C_Unchanged,
1559: last_update_date = sysdate,
1560: creation_date = sysdate

Line 1566: UPDATE AP_EXPENSE_REPORT_LINES_ALL

1562:
1563: if (l_itemization_parent_id = -1) then
1564: for i in ItemizationChildLines(l_OrigReportLineID) loop
1565:
1566: UPDATE AP_EXPENSE_REPORT_LINES_ALL
1567: SET report_header_id = p_new_expense_report_id,
1568: mileage_rate_adjusted_flag = C_Unchanged,
1569: last_update_date = sysdate,
1570: creation_date = sysdate

Line 1671: UPDATE AP_EXPENSE_REPORT_LINES_all

1667: FETCH ReportLines into l_OrigReportLineID, l_itemization_parent_id;
1668: EXIT WHEN ReportLines%NOTFOUND;
1669:
1670:
1671: UPDATE AP_EXPENSE_REPORT_LINES_all
1672: SET report_header_id = p_new_expense_report_id,
1673: mileage_rate_adjusted_flag = C_Unchanged,
1674: last_update_date = sysdate,
1675: creation_date = sysdate

Line 1681: UPDATE AP_EXPENSE_REPORT_LINES_ALL

1677:
1678: if (l_itemization_parent_id = -1) then
1679: for i in ItemizationChildLines(l_OrigReportLineID) loop
1680:
1681: UPDATE AP_EXPENSE_REPORT_LINES_ALL
1682: SET report_header_id = p_new_expense_report_id,
1683: mileage_rate_adjusted_flag = C_Unchanged,
1684: last_update_date = sysdate,
1685: creation_date = sysdate

Line 1805: AP_EXPENSE_REPORT_LINES_ALL DL

1801: DT.PREPARER_MODIFIED_FLAG,
1802: DT.AMOUNT,
1803: DT.COST_CENTER
1804: FROM AP_EXP_REPORT_DISTS_ALL DT,
1805: AP_EXPENSE_REPORT_LINES_ALL DL
1806: WHERE DT.REPORT_LINE_ID = p_line_id
1807: AND DT.REPORT_LINE_ID = DL.REPORT_LINE_ID
1808: AND (DL.ITEMIZATION_PARENT_ID IS NULL
1809: OR

Line 4276: PROCEDURE InsertLine(expense_line_rec in AP_EXPENSE_REPORT_LINES_ALL%ROWTYPE) IS

4272: * jrautiai ADJ Fix
4273: * Need the ability to insert a single row, this procedure inserts a row in the
4274: * database, using the data provided in the record given as parameter.
4275: */
4276: PROCEDURE InsertLine(expense_line_rec in AP_EXPENSE_REPORT_LINES_ALL%ROWTYPE) IS
4277: l_debug_info varchar2(240);
4278: BEGIN
4279:
4280: l_debug_info := 'InsertLine';

Line 4282: INSERT INTO AP_EXPENSE_REPORT_LINES_ALL

4278: BEGIN
4279:
4280: l_debug_info := 'InsertLine';
4281:
4282: INSERT INTO AP_EXPENSE_REPORT_LINES_ALL
4283: (REPORT_HEADER_ID,
4284: LAST_UPDATE_DATE,
4285: LAST_UPDATED_BY,
4286: CODE_COMBINATION_ID,

Line 5102: from ap_expense_report_lines_all

5098: BEGIN
5099: l_cc_lines_exist := 'N';
5100:
5101: select 'Y' into l_cc_lines_exist
5102: from ap_expense_report_lines_all
5103: where report_header_id = p_report_header_id
5104: and credit_card_trx_id is not null
5105: and rownum = 1;
5106: