DBA Data[Home] [Help]

APPS.AP_WEB_OA_MAINFLOW_PKG dependencies on AP_EXPENSE_REPORT_LINES

Line 822: FROM AP_EXPENSE_REPORT_LINES_ALL

818: SUM(DECODE(SIGN(amount),-1,0,amount))
819: INTO
820: l_neg_pos_total,
821: l_pos_total
822: FROM AP_EXPENSE_REPORT_LINES_ALL
823: WHERE REPORT_HEADER_ID = p_report_header_id
824: AND (itemization_parent_id is null OR itemization_parent_id <> -1);
825: EXCEPTION
826: WHEN OTHERS THEN

Line 1564: ReportID IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE)

1560: END;
1561: END updChargesFromDeletedReport;
1562:
1563: PROCEDURE DeleteReport(
1564: ReportID IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE)
1565: IS
1566: l_DebugInfo VARCHAR2(200);
1567: l_count NUMBER;
1568: l_idArray AP_WEB_PARENT_PKG.number_Array;