1 PACKAGE EDR_ATTACHMENTS_GRP AS
2 /* $Header: EDRGATCS.pls 120.2.12000000.1 2007/01/18 05:53:21 appldev ship $ */
3
4 -- Bug 4381237: Start
5
6 PROCEDURE copy_attachments(X_from_entity_name IN VARCHAR2,
7 X_from_pk1_value IN VARCHAR2,
8 X_from_pk2_value IN VARCHAR2 DEFAULT NULL,
9 X_from_pk3_value IN VARCHAR2 DEFAULT NULL,
10 X_from_pk4_value IN VARCHAR2 DEFAULT NULL,
11 X_from_pk5_value IN VARCHAR2 DEFAULT NULL,
12 X_to_entity_name IN VARCHAR2,
13 X_to_pk1_value IN VARCHAR2,
14 X_to_pk2_value IN VARCHAR2 DEFAULT NULL,
15 X_to_pk3_value IN VARCHAR2 DEFAULT NULL,
16 X_to_pk4_value IN VARCHAR2 DEFAULT NULL,
17 X_to_pk5_value IN VARCHAR2 DEFAULT NULL,
18 X_created_by IN NUMBER DEFAULT NULL,
19 X_last_update_login IN NUMBER DEFAULT NULL,
20 X_program_application_id IN NUMBER DEFAULT NULL,
21 X_program_id IN NUMBER DEFAULT NULL,
22 X_request_id IN NUMBER DEFAULT NULL,
23 X_automatically_added_flag IN VARCHAR2 DEFAULT NULL,
24 X_from_category_id IN NUMBER DEFAULT NULL,
25 X_to_category_id IN NUMBER DEFAULT NULL);
26
27 PROCEDURE copy_one_attachment(X_from_entity_name IN VARCHAR2,
28 X_from_pk1_value IN VARCHAR2,
29 X_from_pk2_value IN VARCHAR2 DEFAULT NULL,
30 X_from_pk3_value IN VARCHAR2 DEFAULT NULL,
31 X_from_pk4_value IN VARCHAR2 DEFAULT NULL,
32 X_from_pk5_value IN VARCHAR2 DEFAULT NULL,
33 X_to_entity_name IN VARCHAR2,
34 X_to_pk1_value IN VARCHAR2,
35 X_to_pk2_value IN VARCHAR2 DEFAULT NULL,
36 X_to_pk3_value IN VARCHAR2 DEFAULT NULL,
37 X_to_pk4_value IN VARCHAR2 DEFAULT NULL,
38 X_to_pk5_value IN VARCHAR2 DEFAULT NULL,
39 X_document_id IN NUMBER,
40 X_created_by IN NUMBER DEFAULT NULL,
41 X_last_update_login IN NUMBER DEFAULT NULL,
42 X_program_application_id IN NUMBER DEFAULT NULL,
43 X_program_id IN NUMBER DEFAULT NULL,
44 X_request_id IN NUMBER DEFAULT NULL,
45 X_automatically_added_flag IN VARCHAR2 DEFAULT NULL,
46 X_from_category_id IN NUMBER DEFAULT NULL,
47 X_to_category_id IN NUMBER DEFAULT NULL);
48
49 -- Bug 4381237: End
50
51 --Bug 3893101: Start
52 --Create new record type to store attachment details
53 TYPE ERES_ATTACHMENT_REC_TYPE IS RECORD
54 ( ENTITY_NAME VARCHAR2(240),
55 PK1_VALUE VARCHAR2(100),
56 PK2_VALUE VARCHAR2(100),
57 PK3_VALUE VARCHAR2(100),
58 PK4_VALUE VARCHAR2(100),
59 PK5_VALUE VARCHAR2(100),
60 CATEGORY VARCHAR2(100)
61 );
62
63 --This would be a table of the above record type.
64
65 TYPE ERES_ATTACHMENT_TBL_TYPE IS TABLE OF ERES_ATTACHMENT_REC_TYPE INDEX BY BINARY_INTEGER;
66
67 --Bug 3893101: End
68
69
70 PROCEDURE ATTACH_ERP_AUT( p_entity_name VARCHAR2,
71 p_pk1_value VARCHAR2,
72 p_pk2_value VARCHAR2,
73 p_pk3_value VARCHAR2,
74 p_pk4_value VARCHAR2,
75 p_pk5_value VARCHAR2,
76 p_category VARCHAR2,
77 p_target_value VARCHAR2
78 );
79
80 PROCEDURE ATTACH_ERP (p_entity_name VARCHAR2,
81 p_pk1_value VARCHAR2,
82 p_pk2_value VARCHAR2,
83 p_pk3_value VARCHAR2,
84 p_pk4_value VARCHAR2,
85 p_pk5_value VARCHAR2,
86 p_category VARCHAR2
87 );
88
89
90
91 PROCEDURE EVENT_POST_OP(p_file_id VARCHAR2);
92
93 PROCEDURE GET_CATEGORY_NAME (P_CATEGORY_NAME IN VARCHAR2,
94 P_DISPLAY_NAME in out nocopy VARCHAR2);
95
96 PROCEDURE GET_DESC_FLEX_ALL_PROMPTS(P_APPLICATION_ID IN VARCHAR2,
97 P_DESC_FLEX_DEF_NAME IN VARCHAR2,
98 P_DESC_FLEX_CONTEXT IN VARCHAR2,
99 P_PROMPT_TYPE IN VARCHAR2,
100 P_COLUMN1_NAME IN VARCHAR2,
101 P_COLUMN2_NAME IN VARCHAR2,
102 P_COLUMN3_NAME IN VARCHAR2,
103 P_COLUMN4_NAME IN VARCHAR2,
104 P_COLUMN5_NAME IN VARCHAR2,
105 P_COLUMN6_NAME IN VARCHAR2,
106 P_COLUMN7_NAME IN VARCHAR2,
107 P_COLUMN8_NAME IN VARCHAR2,
108 P_COLUMN9_NAME IN VARCHAR2,
109 P_COLUMN10_NAME IN VARCHAR2,
110 P_COLUMN1_PROMPT out nocopy VARCHAR2,
111 P_COLUMN2_PROMPT out nocopy VARCHAR2,
112 P_COLUMN3_PROMPT out nocopy VARCHAR2,
113 P_COLUMN4_PROMPT out nocopy VARCHAR2,
114 P_COLUMN5_PROMPT out nocopy VARCHAR2,
115 P_COLUMN6_PROMPT out nocopy VARCHAR2,
116 P_COLUMN7_PROMPT out nocopy VARCHAR2,
117 P_COLUMN8_PROMPT out nocopy VARCHAR2,
118 P_COLUMN9_PROMPT out nocopy VARCHAR2,
119 P_COLUMN10_PROMPT out nocopy VARCHAR2);
120
121 -- Bug 4501520 :rvsingh :start
122 PROCEDURE GET_DESC_FLEX_ALL_VALUES(P_APPLICATION_ID IN VARCHAR2,
123 P_DESC_FLEX_DEF_NAME IN VARCHAR2,
124 P_DESC_FLEX_CONTEXT IN VARCHAR2,
125 P_COLUMN1_NAME IN VARCHAR2,
126 P_COLUMN2_NAME IN VARCHAR2,
127 P_COLUMN3_NAME IN VARCHAR2,
128 P_COLUMN4_NAME IN VARCHAR2,
129 P_COLUMN5_NAME IN VARCHAR2,
130 P_COLUMN6_NAME IN VARCHAR2,
131 P_COLUMN7_NAME IN VARCHAR2,
132 P_COLUMN8_NAME IN VARCHAR2,
133 P_COLUMN9_NAME IN VARCHAR2,
134 P_COLUMN10_NAME IN VARCHAR2,
135 P_COLUMN1_ID_VAL IN VARCHAR2,
136 P_COLUMN2_ID_VAL IN VARCHAR2,
137 P_COLUMN3_ID_VAL IN VARCHAR2,
138 P_COLUMN4_ID_VAL IN VARCHAR2,
139 P_COLUMN5_ID_VAL IN VARCHAR2,
140 P_COLUMN6_ID_VAL IN VARCHAR2,
141 P_COLUMN7_ID_VAL IN VARCHAR2,
142 P_COLUMN8_ID_VAL IN VARCHAR2,
143 P_COLUMN9_ID_VAL IN VARCHAR2,
144 P_COLUMN10_ID_VAL IN VARCHAR2,
145 P_COLUMN1_VAL out nocopy VARCHAR2,
146 P_COLUMN2_VAL out nocopy VARCHAR2,
147 P_COLUMN3_VAL out nocopy VARCHAR2,
148 P_COLUMN4_VAL out nocopy VARCHAR2,
149 P_COLUMN5_VAL out nocopy VARCHAR2,
150 P_COLUMN6_VAL out nocopy VARCHAR2,
151 P_COLUMN7_VAL out nocopy VARCHAR2,
152 P_COLUMN8_VAL out nocopy VARCHAR2,
153 P_COLUMN9_VAL out nocopy VARCHAR2,
154 P_COLUMN10_VAL out nocopy VARCHAR2);
155
156 -- Bug 4501520 :rvsingh :end
157
158 PROCEDURE ATTACH_FILE (p_document_id VARCHAR2);
159
160 PROCEDURE ATTACH_FILE_AUT (p_document_id in VARCHAR2, p_target_value in VARCHAR2);
161
162 --Bug 3893101: Start
163 --This function would parse a given attachment String.
164 FUNCTION PARSE_ATTACHMENT_STRING(P_ATTACHMENT_STRING IN VARCHAR2)
165 RETURN ERES_ATTACHMENT_TBL_TYPE;
166
167 --This function would take an attachment String and create the
168 --attachment as per the attribute values defined.
169 PROCEDURE ADD_ERP_ATTACH(P_ATTACHMENT_STRING IN VARCHAR2);
170
171 --Bug 3893101: End
172
173 END EDR_ATTACHMENTS_GRP;