APPS.AP_WEB_AME_PKG dependencies on AP_EXPENSE_REPORT_LINES

Line 213: FUNCTION getTotalPerCostCenter(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,

209: | RETURNS
210: | Total Reimbursable Amount
211: *----------------------------------------------------------------------------*/
212: -------------------------------------------------------------------------
213: FUNCTION getTotalPerCostCenter(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
214: p_line_number IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE) RETURN NUMBER
215: -------------------------------------------------------------------------
216: IS
217: l_line_item_total NUMBER := 0;

Line 214: p_line_number IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE) RETURN NUMBER

210: | Total Reimbursable Amount
211: *----------------------------------------------------------------------------*/
212: -------------------------------------------------------------------------
213: FUNCTION getTotalPerCostCenter(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
214: p_line_number IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE) RETURN NUMBER
215: -------------------------------------------------------------------------
216: IS
217: l_line_item_total NUMBER := 0;
218:

Line 227: FROM AP_EXPENSE_REPORT_LINES_ALL

223: -- If project is enabled, then get the total reimbursable amount for the same project number. Otherwise, if line-level-accounting is enabled, get the total reimbursable amount for the same cost center
224:
225: SELECT SUM(AMOUNT)
226: INTO l_line_item_total
227: FROM AP_EXPENSE_REPORT_LINES_ALL
228: WHERE REPORT_HEADER_ID = p_report_header_id
229: AND FLEX_CONCATENATED = (
230: SELECT FLEX_CONCATENATED
231: FROM AP_EXPENSE_REPORT_LINES_ALL

Line 231: FROM AP_EXPENSE_REPORT_LINES_ALL

227: FROM AP_EXPENSE_REPORT_LINES_ALL
228: WHERE REPORT_HEADER_ID = p_report_header_id
229: AND FLEX_CONCATENATED = (
230: SELECT FLEX_CONCATENATED
231: FROM AP_EXPENSE_REPORT_LINES_ALL
232: WHERE REPORT_HEADER_ID = p_report_header_id
233: AND DISTRIBUTION_LINE_NUMBER = p_line_number
234: )
235: AND itemization_parent_id <> -1;

Line 263: FUNCTION getCostCenterOwner(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,

259: | RETURNS
260: | Total Reimbursable Amount
261: *----------------------------------------------------------------------------*/
262: -------------------------------------------------------------------------
263: FUNCTION getCostCenterOwner(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
264: p_cost_center IN AP_EXPENSE_REPORT_LINES.FLEX_CONCATENATED%TYPE) RETURN VARCHAR2
265: -------------------------------------------------------------------------
266: IS
267: l_debug_info VARCHAR2(200);

Line 264: p_cost_center IN AP_EXPENSE_REPORT_LINES.FLEX_CONCATENATED%TYPE) RETURN VARCHAR2

260: | Total Reimbursable Amount
261: *----------------------------------------------------------------------------*/
262: -------------------------------------------------------------------------
263: FUNCTION getCostCenterOwner(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
264: p_cost_center IN AP_EXPENSE_REPORT_LINES.FLEX_CONCATENATED%TYPE) RETURN VARCHAR2
265: -------------------------------------------------------------------------
266: IS
267: l_debug_info VARCHAR2(200);
268: l_segment_name FND_SEGMENT_ATTRIBUTE_VALUES.application_column_name%TYPE := NULL;

Line 313: AP_EXPENSE_REPORT_LINES_ALL LINES

309: HR_ORGANIZATION_INFORMATION HOIP,
310: HR_ORGANIZATION_INFORMATION HOIC,
311: HR_ORGANIZATION_INFORMATION HOI,
312: PER_WORKFORCE_CURRENT_X PP,
313: AP_EXPENSE_REPORT_LINES_ALL LINES
314: WHERE ENABLED_FLAG = ''Y''
315: AND GLCC.' || l_segment_name || ' = :costCenter
316: AND LINES.REPORT_HEADER_ID = :reportHeaderId
317: AND CHART_OF_ACCOUNTS_ID = :charOfAccountsId

Line 395: FUNCTION getViolationPercentage(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE) RETURN NUMBER

391: | RETURNS
392: | Violation percentage
393: *----------------------------------------------------------------------------*/
394: -------------------------------------------------------------------------
395: FUNCTION getViolationPercentage(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE) RETURN NUMBER
396: -------------------------------------------------------------------------
397: IS
398: l_debug_info VARCHAR2(200);
399: l_violationTotal NUMBER := 0;

Line 559: from ap_expense_report_lines_all

555: where report_header_id = p_report_header_id;
556: elsif (p_item_class = C_LINE_ITEM) then
557: select sum(amount)
558: into p_amount
559: from ap_expense_report_lines_all
560: where report_header_id = p_report_header_id
561: and distribution_line_number = p_item_id;
562: -- and report_line_id = p_item_id;
563: elsif (p_item_class = C_PROJECT) then

Line 850: from ap_expense_report_lines_all xl

846: -- 5417790: include only itemization child lines in the cursor as we
847: -- display only the child lines in the notification.
848: cursor c1(p_report_header_id in number) is
849: select report_line_id, nvl(amount,0) amount, distribution_line_number, itemization_parent_id
850: from ap_expense_report_lines_all xl
851: where xl.report_header_id = p_report_header_id
852: and (xl.itemization_parent_id is null or xl.itemization_parent_id <> -1);
853:
854: l_debug_info VARCHAR2(200);

Line 896: from ap_expense_report_lines_all

892: oie_ame_notif_gt gt
893: where xd.report_header_id = p_report_header_id
894: and xd.report_line_id in (
895: select report_line_id
896: from ap_expense_report_lines_all
897: where report_header_id = p_report_header_id
898: and itemization_parent_id = i.report_line_id)
899: and ( (xd.cost_center = gt.item_id
900: and