13:
14: PROCEDURE CheckForReceiptWarnings (p_receipt_errors IN AP_WEB_UTILITIES_PKG.receipt_error_stack);
15:
16: Procedure OAInsertTempData(
17: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
18: p_report_lines_info IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
19: p_receipt_errors IN AP_WEB_UTILITIES_PKG.receipt_error_stack,
20: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
21: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
14: PROCEDURE CheckForReceiptWarnings (p_receipt_errors IN AP_WEB_UTILITIES_PKG.receipt_error_stack);
15:
16: Procedure OAInsertTempData(
17: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
18: p_report_lines_info IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
19: p_receipt_errors IN AP_WEB_UTILITIES_PKG.receipt_error_stack,
20: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
21: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
22: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
16: Procedure OAInsertTempData(
17: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
18: p_report_lines_info IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
19: p_receipt_errors IN AP_WEB_UTILITIES_PKG.receipt_error_stack,
20: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
21: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
22: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
23: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
24: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
17: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
18: p_report_lines_info IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
19: p_receipt_errors IN AP_WEB_UTILITIES_PKG.receipt_error_stack,
20: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
21: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
22: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
23: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
24: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
25: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
18: p_report_lines_info IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
19: p_receipt_errors IN AP_WEB_UTILITIES_PKG.receipt_error_stack,
20: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
21: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
22: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
23: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
24: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
25: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
26: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
19: p_receipt_errors IN AP_WEB_UTILITIES_PKG.receipt_error_stack,
20: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
21: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
22: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
23: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
24: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
25: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
26: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
27: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
20: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
21: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
22: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
23: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
24: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
25: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
26: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
27: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
28: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
21: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
22: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
23: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
24: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
25: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
26: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
27: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
28: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
29: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
22: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
23: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
24: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
25: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
26: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
27: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
28: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
29: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
30: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
23: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
24: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
25: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
26: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
27: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
28: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
29: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
30: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
31: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
24: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
25: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
26: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
27: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
28: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
29: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
30: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
31: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
32: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
25: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
26: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
27: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
28: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
29: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
30: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
31: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
32: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
33: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
26: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
27: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
28: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
29: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
30: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
31: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
32: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
33: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
34: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A);
27: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
28: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
29: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
30: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
31: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
32: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
33: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
34: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A);
35:
28: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
29: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
30: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
31: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
32: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
33: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
34: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A);
35:
36: PROCEDURE ValidateRequiredProjectTask(
29: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
30: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
31: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
32: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
33: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
34: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A);
35:
36: PROCEDURE ValidateRequiredProjectTask(
37: p_employee_id IN NUMBER, -- bug 2242176, employee's id
30: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
31: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
32: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
33: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
34: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A);
35:
36: PROCEDURE ValidateRequiredProjectTask(
37: p_employee_id IN NUMBER, -- bug 2242176, employee's id
38: p_user_id IN NUMBER, -- bug 2242176, employee's user id
35:
36: PROCEDURE ValidateRequiredProjectTask(
37: p_employee_id IN NUMBER, -- bug 2242176, employee's id
38: p_user_id IN NUMBER, -- bug 2242176, employee's user id
39: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
40: p_report_lines_info IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
41: p_receipts_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack);
42:
43: PROCEDURE CheckForMileagePerDiemPolicy(
36: PROCEDURE ValidateRequiredProjectTask(
37: p_employee_id IN NUMBER, -- bug 2242176, employee's id
38: p_user_id IN NUMBER, -- bug 2242176, employee's user id
39: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
40: p_report_lines_info IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
41: p_receipts_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack);
42:
43: PROCEDURE CheckForMileagePerDiemPolicy(
44: p_user_id IN NUMBER,
41: p_receipts_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack);
42:
43: PROCEDURE CheckForMileagePerDiemPolicy(
44: p_user_id IN NUMBER,
45: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
46: p_report_lines_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
47: p_header_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError,
48: p_receipts_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack);
49:
42:
43: PROCEDURE CheckForMileagePerDiemPolicy(
44: p_user_id IN NUMBER,
45: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
46: p_report_lines_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
47: p_header_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError,
48: p_receipts_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack);
49:
50: PROCEDURE ValidateHeaderDFF(
48: p_receipts_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack);
49:
50: PROCEDURE ValidateHeaderDFF(
51: p_user_id IN NUMBER,
52: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
53: p_header_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError);
54:
55:
56: /*
97: l_employee_num PER_WORKFORCE_X.employee_number%TYPE ;
98: l_cost_center VARCHAR2(150);
99:
100: l_IsSessionProjectEnabled VARCHAR2(1);
101: Custom1_Array AP_WEB_DFLEX_PKG.CustomFields_A;
102: Custom2_Array AP_WEB_DFLEX_PKG.CustomFields_A;
103: Custom3_Array AP_WEB_DFLEX_PKG.CustomFields_A;
104: Custom4_Array AP_WEB_DFLEX_PKG.CustomFields_A;
105: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
98: l_cost_center VARCHAR2(150);
99:
100: l_IsSessionProjectEnabled VARCHAR2(1);
101: Custom1_Array AP_WEB_DFLEX_PKG.CustomFields_A;
102: Custom2_Array AP_WEB_DFLEX_PKG.CustomFields_A;
103: Custom3_Array AP_WEB_DFLEX_PKG.CustomFields_A;
104: Custom4_Array AP_WEB_DFLEX_PKG.CustomFields_A;
105: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
106: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
99:
100: l_IsSessionProjectEnabled VARCHAR2(1);
101: Custom1_Array AP_WEB_DFLEX_PKG.CustomFields_A;
102: Custom2_Array AP_WEB_DFLEX_PKG.CustomFields_A;
103: Custom3_Array AP_WEB_DFLEX_PKG.CustomFields_A;
104: Custom4_Array AP_WEB_DFLEX_PKG.CustomFields_A;
105: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
106: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
107: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
100: l_IsSessionProjectEnabled VARCHAR2(1);
101: Custom1_Array AP_WEB_DFLEX_PKG.CustomFields_A;
102: Custom2_Array AP_WEB_DFLEX_PKG.CustomFields_A;
103: Custom3_Array AP_WEB_DFLEX_PKG.CustomFields_A;
104: Custom4_Array AP_WEB_DFLEX_PKG.CustomFields_A;
105: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
106: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
107: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
108: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
101: Custom1_Array AP_WEB_DFLEX_PKG.CustomFields_A;
102: Custom2_Array AP_WEB_DFLEX_PKG.CustomFields_A;
103: Custom3_Array AP_WEB_DFLEX_PKG.CustomFields_A;
104: Custom4_Array AP_WEB_DFLEX_PKG.CustomFields_A;
105: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
106: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
107: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
108: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
109: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
102: Custom2_Array AP_WEB_DFLEX_PKG.CustomFields_A;
103: Custom3_Array AP_WEB_DFLEX_PKG.CustomFields_A;
104: Custom4_Array AP_WEB_DFLEX_PKG.CustomFields_A;
105: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
106: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
107: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
108: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
109: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
110: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
103: Custom3_Array AP_WEB_DFLEX_PKG.CustomFields_A;
104: Custom4_Array AP_WEB_DFLEX_PKG.CustomFields_A;
105: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
106: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
107: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
108: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
109: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
110: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
111: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
104: Custom4_Array AP_WEB_DFLEX_PKG.CustomFields_A;
105: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
106: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
107: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
108: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
109: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
110: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
111: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
112: Custom12_Array AP_WEB_DFLEX_PKG.CustomFields_A;
105: Custom5_Array AP_WEB_DFLEX_PKG.CustomFields_A;
106: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
107: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
108: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
109: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
110: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
111: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
112: Custom12_Array AP_WEB_DFLEX_PKG.CustomFields_A;
113: Custom13_Array AP_WEB_DFLEX_PKG.CustomFields_A;
106: Custom6_Array AP_WEB_DFLEX_PKG.CustomFields_A;
107: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
108: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
109: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
110: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
111: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
112: Custom12_Array AP_WEB_DFLEX_PKG.CustomFields_A;
113: Custom13_Array AP_WEB_DFLEX_PKG.CustomFields_A;
114: Custom14_Array AP_WEB_DFLEX_PKG.CustomFields_A;
107: Custom7_Array AP_WEB_DFLEX_PKG.CustomFields_A;
108: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
109: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
110: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
111: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
112: Custom12_Array AP_WEB_DFLEX_PKG.CustomFields_A;
113: Custom13_Array AP_WEB_DFLEX_PKG.CustomFields_A;
114: Custom14_Array AP_WEB_DFLEX_PKG.CustomFields_A;
115: Custom15_Array AP_WEB_DFLEX_PKG.CustomFields_A;
108: Custom8_Array AP_WEB_DFLEX_PKG.CustomFields_A;
109: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
110: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
111: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
112: Custom12_Array AP_WEB_DFLEX_PKG.CustomFields_A;
113: Custom13_Array AP_WEB_DFLEX_PKG.CustomFields_A;
114: Custom14_Array AP_WEB_DFLEX_PKG.CustomFields_A;
115: Custom15_Array AP_WEB_DFLEX_PKG.CustomFields_A;
116: l_has_core_field_errors BOOLEAN;
109: Custom9_Array AP_WEB_DFLEX_PKG.CustomFields_A;
110: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
111: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
112: Custom12_Array AP_WEB_DFLEX_PKG.CustomFields_A;
113: Custom13_Array AP_WEB_DFLEX_PKG.CustomFields_A;
114: Custom14_Array AP_WEB_DFLEX_PKG.CustomFields_A;
115: Custom15_Array AP_WEB_DFLEX_PKG.CustomFields_A;
116: l_has_core_field_errors BOOLEAN;
117: l_has_custom_field_errors BOOLEAN;
110: Custom10_Array AP_WEB_DFLEX_PKG.CustomFields_A;
111: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
112: Custom12_Array AP_WEB_DFLEX_PKG.CustomFields_A;
113: Custom13_Array AP_WEB_DFLEX_PKG.CustomFields_A;
114: Custom14_Array AP_WEB_DFLEX_PKG.CustomFields_A;
115: Custom15_Array AP_WEB_DFLEX_PKG.CustomFields_A;
116: l_has_core_field_errors BOOLEAN;
117: l_has_custom_field_errors BOOLEAN;
118: l_report_header_info AP_WEB_DFLEX_PKG.ExpReportHeaderRec;
111: Custom11_Array AP_WEB_DFLEX_PKG.CustomFields_A;
112: Custom12_Array AP_WEB_DFLEX_PKG.CustomFields_A;
113: Custom13_Array AP_WEB_DFLEX_PKG.CustomFields_A;
114: Custom14_Array AP_WEB_DFLEX_PKG.CustomFields_A;
115: Custom15_Array AP_WEB_DFLEX_PKG.CustomFields_A;
116: l_has_core_field_errors BOOLEAN;
117: l_has_custom_field_errors BOOLEAN;
118: l_report_header_info AP_WEB_DFLEX_PKG.ExpReportHeaderRec;
119: l_report_lines_info AP_WEB_DFLEX_PKG.ExpReportLines_A;
114: Custom14_Array AP_WEB_DFLEX_PKG.CustomFields_A;
115: Custom15_Array AP_WEB_DFLEX_PKG.CustomFields_A;
116: l_has_core_field_errors BOOLEAN;
117: l_has_custom_field_errors BOOLEAN;
118: l_report_header_info AP_WEB_DFLEX_PKG.ExpReportHeaderRec;
119: l_report_lines_info AP_WEB_DFLEX_PKG.ExpReportLines_A;
120: l_temp_errors AP_WEB_DISC_PKG.Setup_error_stack;
121:
122: l_DataDefaultedUpdateable BOOLEAN;
115: Custom15_Array AP_WEB_DFLEX_PKG.CustomFields_A;
116: l_has_core_field_errors BOOLEAN;
117: l_has_custom_field_errors BOOLEAN;
118: l_report_header_info AP_WEB_DFLEX_PKG.ExpReportHeaderRec;
119: l_report_lines_info AP_WEB_DFLEX_PKG.ExpReportLines_A;
120: l_temp_errors AP_WEB_DISC_PKG.Setup_error_stack;
121:
122: l_DataDefaultedUpdateable BOOLEAN;
123: l_emp_id AP_WEB_DB_HR_INT_PKG.empCurrent_employeeID;
427: JMARY
428: Purpose
429: Procedure called by OAExpReport to insert into the Temporary Tables .
430: Input
431: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
432: p_report_lines_info IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
433: p_receipt_errors IN AP_WEB_UTILITIES_PKG.receipt_error_stack,
434: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
435: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
428: Purpose
429: Procedure called by OAExpReport to insert into the Temporary Tables .
430: Input
431: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
432: p_report_lines_info IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
433: p_receipt_errors IN AP_WEB_UTILITIES_PKG.receipt_error_stack,
434: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
435: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
436: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
430: Input
431: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
432: p_report_lines_info IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
433: p_receipt_errors IN AP_WEB_UTILITIES_PKG.receipt_error_stack,
434: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
435: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
436: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
437: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
438: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
431: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
432: p_report_lines_info IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
433: p_receipt_errors IN AP_WEB_UTILITIES_PKG.receipt_error_stack,
434: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
435: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
436: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
437: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
438: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
439: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
432: p_report_lines_info IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
433: p_receipt_errors IN AP_WEB_UTILITIES_PKG.receipt_error_stack,
434: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
435: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
436: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
437: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
438: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
439: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
440: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
433: p_receipt_errors IN AP_WEB_UTILITIES_PKG.receipt_error_stack,
434: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
435: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
436: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
437: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
438: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
439: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
440: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
441: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
434: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
435: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
436: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
437: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
438: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
439: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
440: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
441: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
442: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
435: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
436: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
437: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
438: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
439: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
440: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
441: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
442: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
443: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
436: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
437: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
438: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
439: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
440: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
441: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
442: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
443: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
444: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
437: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
438: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
439: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
440: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
441: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
442: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
443: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
444: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
445: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
438: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
439: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
440: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
441: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
442: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
443: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
444: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
445: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
446: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
439: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
440: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
441: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
442: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
443: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
444: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
445: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
446: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
447: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
440: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
441: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
442: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
443: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
444: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
445: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
446: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
447: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
448: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A
441: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
442: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
443: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
444: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
445: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
446: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
447: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
448: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A
449: Output
442: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
443: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
444: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
445: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
446: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
447: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
448: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A
449: Output
450: p_error_type
443: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
444: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
445: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
446: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
447: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
448: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A
449: Output
450: p_error_type
451: p_return_status
444: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
445: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
446: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
447: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
448: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A
449: Output
450: p_error_type
451: p_return_status
452: p_msg_count
459: 01-DEC-2000
460: */
461:
462: Procedure OAInsertTempData(
463: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
464: p_report_lines_info IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
465: p_receipt_errors IN AP_WEB_UTILITIES_PKG.receipt_error_stack,
466: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
467: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
460: */
461:
462: Procedure OAInsertTempData(
463: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
464: p_report_lines_info IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
465: p_receipt_errors IN AP_WEB_UTILITIES_PKG.receipt_error_stack,
466: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
467: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
468: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
462: Procedure OAInsertTempData(
463: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
464: p_report_lines_info IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
465: p_receipt_errors IN AP_WEB_UTILITIES_PKG.receipt_error_stack,
466: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
467: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
468: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
469: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
470: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
463: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
464: p_report_lines_info IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
465: p_receipt_errors IN AP_WEB_UTILITIES_PKG.receipt_error_stack,
466: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
467: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
468: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
469: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
470: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
471: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
464: p_report_lines_info IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
465: p_receipt_errors IN AP_WEB_UTILITIES_PKG.receipt_error_stack,
466: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
467: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
468: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
469: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
470: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
471: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
472: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
465: p_receipt_errors IN AP_WEB_UTILITIES_PKG.receipt_error_stack,
466: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
467: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
468: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
469: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
470: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
471: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
472: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
473: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
466: Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
467: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
468: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
469: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
470: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
471: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
472: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
473: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
474: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
467: Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
468: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
469: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
470: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
471: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
472: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
473: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
474: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
475: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
468: Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
469: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
470: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
471: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
472: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
473: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
474: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
475: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
476: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
469: Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
470: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
471: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
472: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
473: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
474: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
475: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
476: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
477: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
470: Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
471: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
472: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
473: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
474: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
475: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
476: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
477: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
478: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
471: Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
472: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
473: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
474: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
475: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
476: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
477: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
478: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
479: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
472: Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
473: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
474: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
475: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
476: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
477: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
478: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
479: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
480: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A) IS
473: Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
474: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
475: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
476: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
477: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
478: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
479: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
480: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A) IS
481:
474: Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
475: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
476: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
477: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
478: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
479: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
480: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A) IS
481:
482: l_debug_info varchar2(1000);
475: Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
476: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
477: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
478: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
479: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
480: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A) IS
481:
482: l_debug_info varchar2(1000);
483: P_AttributeCol AP_WEB_PARENT_PKG.BigString_Array;
476: Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
477: Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
478: Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
479: Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
480: Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A) IS
481:
482: l_debug_info varchar2(1000);
483: P_AttributeCol AP_WEB_PARENT_PKG.BigString_Array;
484: l_item_description AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_prompt;
767: END CheckForReceiptWarnings;
768:
769: -- Bug: 6619166, Project and Task Not Validated in Disconnected Expense Entry Skip to Review.
770: PROCEDURE ValidateProjectTransaction(
771: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
772: p_report_lines_info IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
773: p_base_curr_code IN AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode,
774: p_acct_raw_cost IN NUMBER,
775: p_def_exchng_rate_type IN VARCHAR2,
768:
769: -- Bug: 6619166, Project and Task Not Validated in Disconnected Expense Entry Skip to Review.
770: PROCEDURE ValidateProjectTransaction(
771: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
772: p_report_lines_info IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
773: p_base_curr_code IN AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode,
774: p_acct_raw_cost IN NUMBER,
775: p_def_exchng_rate_type IN VARCHAR2,
776: p_default_exchange_rate IN NUMBER,
846: */
847: PROCEDURE ValidateRequiredProjectTask(
848: p_employee_id IN NUMBER,
849: p_user_id IN NUMBER,
850: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
851: p_report_lines_info IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
852: p_receipts_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack) IS
853:
854: l_errors AP_WEB_UTILITIES_PKG.expError;
847: PROCEDURE ValidateRequiredProjectTask(
848: p_employee_id IN NUMBER,
849: p_user_id IN NUMBER,
850: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
851: p_report_lines_info IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
852: p_receipts_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack) IS
853:
854: l_errors AP_WEB_UTILITIES_PKG.expError;
855: l_receipt_count BINARY_INTEGER;
978: IF (l_return_error_message is not null) THEN
979:
980: AP_WEB_UTILITIES_PKG.AddExpError(l_errors,
981: l_return_error_message,
982: AP_WEB_DFLEX_PKG.C_CustValidResMsgTypeError,
983: 'PATC',
984: rec_count,
985: AP_WEB_UTILITIES_PKG.C_PATCMessageCategory, AP_WEB_UTILITIES_PKG.IsMobileApp);
986: AP_WEB_UTILITIES_PKG.MergeErrors(l_errors, p_receipts_errors);
1021: lv_msg_type,
1022: l_return_error_message,
1023: lv_procedure_billable_flag);
1024:
1025: if (l_return_error_message IS NOT NULL AND lv_msg_type = AP_WEB_DFLEX_PKG.C_CustValidResMsgTypeError) then
1026: AP_WEB_UTILITIES_PKG.AddExpError(l_errors,
1027: l_return_error_message,
1028: lv_msg_type,
1029: 'PATC',
1082: lv_msg_type,
1083: l_return_error_message,
1084: lv_procedure_billable_flag);
1085:
1086: if (l_return_error_message IS NOT NULL AND lv_msg_type = AP_WEB_DFLEX_PKG.C_CustValidResMsgTypeError) then
1087: AP_WEB_UTILITIES_PKG.AddExpError(l_errors,
1088: l_return_error_message,
1089: lv_msg_type,
1090: 'PATC',
1398: ------------------------------------------------------
1399: l_debug_info := 'Verify that the OIE:Enable Tax profile option is set to Yes';
1400: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_DISC_PKG', l_debug_info);
1401: ------------------------------------------------------
1402: AP_WEB_DFLEX_PKG.IsSessionTaxEnabled(l_is_tax_enabled);
1403: IF (l_is_tax_enabled = C_Yes) THEN
1404: -- This query returns rows if any VAT merchant fields are required in this org
1405: SELECT 1
1406: INTO v_numRows
1539: */
1540:
1541: PROCEDURE CheckForMileagePerDiemPolicy(
1542: p_user_id IN NUMBER,
1543: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
1544: p_report_lines_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
1545: p_header_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError,
1546: p_receipts_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack) IS
1547:
1540:
1541: PROCEDURE CheckForMileagePerDiemPolicy(
1542: p_user_id IN NUMBER,
1543: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
1544: p_report_lines_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
1545: p_header_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError,
1546: p_receipts_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack) IS
1547:
1548: l_receipt_count BINARY_INTEGER;
1551: rec_count NUMBER := 1; /* receipt count */
1552:
1553: l_MPD_present BOOLEAN := false; -- Keeps track whether the report contains Mileage / Per Diem header exceptions
1554: l_foreign_currency_present BOOLEAN := false; -- Keeps track whether foreign currencies exist.
1555: l_reimbursement_currency_code AP_WEB_DFLEX_PKG.expLines_currCode;
1556: l_receipt_required_amount AP_EXPENSE_REPORT_PARAMS.require_receipt_amount%TYPE;
1557: l_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
1558:
1559: BEGIN
1638: */
1639:
1640: PROCEDURE ValidateHeaderDFF(
1641: p_user_id IN NUMBER,
1642: p_report_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
1643: p_header_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError) IS
1644:
1645: l_DFFEnabled VARCHAR2(1);
1646: