1 PACKAGE AP_WEB_PARENT_PKG AUTHID CURRENT_USER AS
2 /* $Header: apwxexps.pls 120.5 2006/05/04 07:23:47 sbalaji ship $ */
3
4 -- chiho: bug fix for 1143452:
5 TYPE ExpenditureType_Array IS TABLE OF AP_EXPENSE_REPORT_PARAMS.pa_expenditure_type%TYPE
6 INDEX BY BINARY_INTEGER;
7
8 TYPE String5_Array IS TABLE OF VARCHAR2(5)
9 INDEX BY BINARY_INTEGER;
10 TYPE String15_Array IS TABLE OF VARCHAR2(15)
11 INDEX BY BINARY_INTEGER;
12 TYPE MiniString_Array IS TABLE OF VARCHAR2(25)
13 INDEX BY BINARY_INTEGER;
14 TYPE MedString_Array IS TABLE OF VARCHAR2(80)
15 INDEX BY BINARY_INTEGER;
16 TYPE BigString_Array IS TABLE OF VARCHAR2(240)
17 INDEX BY BINARY_INTEGER;
18 TYPE Number_Array IS TABLE OF NUMBER
19 INDEX BY BINARY_INTEGER;
20 TYPE Boolean_Array IS TABLE OF BOOLEAN
21 INDEX BY BINARY_INTEGER;
22
23
24 PROCEDURE String2PLSQL_Header( V_line in out nocopy long,
25 P_IsSessionProjectEnabled in VARCHAR2,
26 ExpReportHeaderInfo out nocopy AP_WEB_DFLEX_PKG.ExpReportHeaderRec);
27
28 PROCEDURE String2PLSQL_Receipts(P_IsSessionTaxEnabled IN VARCHAR2,
29 P_IsSessionProjectEnabled IN VARCHAR2,
30 receipt_error_Array in out nocopy AP_WEB_UTILITIES_PKG.Receipt_Error_Stack,
31 V_Line in out nocopy long,
32 ExpReportHeaderInfo in out nocopy AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
33 ExpReportLinesInfo out nocopy AP_WEB_DFLEX_PKG.ExpReportLines_A,
34 Custom1_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
35 Custom2_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
36 Custom3_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
37 Custom4_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
38 Custom5_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
39 Custom6_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
40 Custom7_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
41 Custom8_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
42 Custom9_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
43 Custom10_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
44 Custom11_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
45 Custom12_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
46 Custom13_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
47 Custom14_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
48 Custom15_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A);
49
50 PROCEDURE String2PLSQL(P_IsSessionTaxEnabled IN VARCHAR2,
51 P_IsSessionProjectEnabled IN VARCHAR2,
52 receipt_error_Array in out nocopy AP_WEB_UTILITIES_PKG.Receipt_Error_Stack,
53 ParseThis in long,
54 ExpReportHeaderInfo out nocopy AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
55 ExpReportLinesInfo out nocopy AP_WEB_DFLEX_PKG.ExpReportLines_A,
56 Custom1_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
57 Custom2_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
58 Custom3_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
59 Custom4_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
60 Custom5_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
61 Custom6_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
62 Custom7_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
63 Custom8_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
64 Custom9_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
65 Custom10_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
66 Custom11_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
67 Custom12_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
68 Custom13_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
69 Custom14_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A,
70 Custom15_Array in out nocopy AP_WEB_DFLEX_PKG.CustomFields_A);
71
72
73
74 PROCEDURE MapCustomArrayToColumn(
75 P_Index IN NUMBER,
76 ExpReportHeaderInfo IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
77 ExpReportLinesInfo IN AP_WEB_DFLEX_PKG.ExpReportLines_A,
78 Custom1_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
79 Custom2_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
80 Custom3_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
81 Custom4_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
82 Custom5_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
83 Custom6_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
84 Custom7_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
85 Custom8_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
86 Custom9_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
87 Custom10_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
88 Custom11_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
89 Custom12_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
90 Custom13_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
91 Custom14_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
92 Custom15_Array IN AP_WEB_DFLEX_PKG.CustomFields_A,
93 AttributeCol_Array IN OUT NOCOPY BigString_Array);
94
95 END AP_WEB_PARENT_PKG;