APPS.AP_WEB_DB_VIOLATIONS_PKG dependencies on AP_POL_VIOLATIONS

Line 12: FROM ap_pol_violations

8: l_debug_info VARCHAR2(200);
9:
10: BEGIN
11: DELETE
12: FROM ap_pol_violations
13: WHERE report_header_id = p_report_header_id;
14:
15: EXCEPTION
16: WHEN OTHERS THEN

Line 30: UPDATE ap_pol_violations

26: --------------------------------------------------------------------------------
27: BEGIN
28: -- set the report_header_id for the line
29:
30: UPDATE ap_pol_violations
31: SET report_header_id = p_newReportHeaderID
32: WHERE report_header_id = p_ReportHeaderID
33: AND distribution_line_number IN(
34: SELECT distribution_line_number

Line 57: UPDATE ap_pol_violations

53: l_debug_info VARCHAR2(200);
54:
55: BEGIN
56:
57: UPDATE ap_pol_violations
58: SET report_header_id = p_new_report_header_id
59: WHERE distribution_line_number IN
60: (select distribution_line_number
61: from ap_expense_report_lines

Line 92: UPDATE ap_pol_violations

88: -------------------------------------------------------------------------------
89: l_debug_info VARCHAR2(200);
90:
91: BEGIN
92: UPDATE ap_pol_violations
93: SET report_header_id = p_new_report_header_id
94: WHERE distribution_line_number IN
95: (select distribution_line_number
96: from ap_expense_report_lines

Line 133: UPDATE ap_pol_violations

129: -------------------------------------------------------------------------------
130: l_debug_info VARCHAR2(200);
131:
132: BEGIN
133: UPDATE ap_pol_violations
134: SET report_header_id = p_new_report_header_id
135: WHERE distribution_line_number IN
136: (SELECT distribution_line_number
137: FROM ap_expense_report_lines

Line 164: DELETE FROM ap_pol_violations_all

160:
161: FND_PROFILE.GET('AP_WEB_REPNUM_PREFIX', l_report_prefix);
162: l_report_header_id := l_report_prefix || To_Char(p_report_header_id);
163:
164: DELETE FROM ap_pol_violations_all
165: WHERE dup_report_header_id = l_report_header_id;
166:
167: EXCEPTION
168: WHEN OTHERS THEN