DBA Data[Home] [Help]

APPS.AP_WEB_OA_MAINFLOW_PKG dependencies on AP_EXPENSE_REPORT_LINES

Line 820: FROM AP_EXPENSE_REPORT_LINES_ALL

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

Line 1562: ReportID IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE)

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