APPS.EDR_XDOC_UTIL_PKG dependencies on EDR_ERESPARAMETERS_T

Line 18: DELETE FROM EDR_ERESPARAMETERS_T

14: PRAGMA AUTONOMOUS_TRANSACTION;
15:
16: BEGIN
17:
18: DELETE FROM EDR_ERESPARAMETERS_T
19: WHERE PARENT_ID = P_ERECORD_ID
20: AND PARENT_TYPE = 'EDR_XDOC_PARAMS';
21:
22: COMMIT;

Line 96: INSERT INTO EDR_ERESPARAMETERS_T(PARAM_ID,

92:
93: end if;
94:
95:
96: INSERT INTO EDR_ERESPARAMETERS_T(PARAM_ID,
97: PARENT_ID,
98: PARENT_TYPE,
99: PARAM_NAME,
100: PARAM_VALUE)

Line 102: VALUES(EDR_ERESPARAMETERS_T_S.NEXTVAL,

98: PARENT_TYPE,
99: PARAM_NAME,
100: PARAM_VALUE)
101:
102: VALUES(EDR_ERESPARAMETERS_T_S.NEXTVAL,
103: P_ERECORD_ID,
104: 'EDR_XDOC_PARAMS',
105: 'NLS_DATE_FORMAT',
106: L_NLS_DATE_FORMAT);

Line 108: INSERT INTO EDR_ERESPARAMETERS_T(PARAM_ID,

104: 'EDR_XDOC_PARAMS',
105: 'NLS_DATE_FORMAT',
106: L_NLS_DATE_FORMAT);
107:
108: INSERT INTO EDR_ERESPARAMETERS_T(PARAM_ID,
109: PARENT_ID,
110: PARENT_TYPE,
111: PARAM_NAME,
112: PARAM_VALUE)

Line 114: VALUES(EDR_ERESPARAMETERS_T_S.NEXTVAL,

110: PARENT_TYPE,
111: PARAM_NAME,
112: PARAM_VALUE)
113:
114: VALUES(EDR_ERESPARAMETERS_T_S.NEXTVAL,
115: P_ERECORD_ID,
116: 'EDR_XDOC_PARAMS',
117: 'NLS_DATE_LANGUAGE',
118: L_NLS_DATE_LANGUAGE);

Line 120: INSERT INTO EDR_ERESPARAMETERS_T(PARAM_ID,

116: 'EDR_XDOC_PARAMS',
117: 'NLS_DATE_LANGUAGE',
118: L_NLS_DATE_LANGUAGE);
119:
120: INSERT INTO EDR_ERESPARAMETERS_T(PARAM_ID,
121: PARENT_ID,
122: PARENT_TYPE,
123: PARAM_NAME,
124: PARAM_VALUE)

Line 126: VALUES(EDR_ERESPARAMETERS_T_S.NEXTVAL,

122: PARENT_TYPE,
123: PARAM_NAME,
124: PARAM_VALUE)
125:
126: VALUES(EDR_ERESPARAMETERS_T_S.NEXTVAL,
127: P_ERECORD_ID,
128: 'EDR_XDOC_PARAMS',
129: 'NLS_LANGUAGE',
130: L_NLS_LANGUAGE);

Line 132: INSERT INTO EDR_ERESPARAMETERS_T(PARAM_ID,

128: 'EDR_XDOC_PARAMS',
129: 'NLS_LANGUAGE',
130: L_NLS_LANGUAGE);
131:
132: INSERT INTO EDR_ERESPARAMETERS_T(PARAM_ID,
133: PARENT_ID,
134: PARENT_TYPE,
135: PARAM_NAME,
136: PARAM_VALUE)

Line 138: VALUES(EDR_ERESPARAMETERS_T_S.NEXTVAL,

134: PARENT_TYPE,
135: PARAM_NAME,
136: PARAM_VALUE)
137:
138: VALUES(EDR_ERESPARAMETERS_T_S.NEXTVAL,
139: P_ERECORD_ID,
140: 'EDR_XDOC_PARAMS',
141: 'NLS_NUMERIC_CHARACTERS',
142: L_NLS_NUMERIC_CHARACTERS);

Line 144: INSERT INTO EDR_ERESPARAMETERS_T(PARAM_ID,

140: 'EDR_XDOC_PARAMS',
141: 'NLS_NUMERIC_CHARACTERS',
142: L_NLS_NUMERIC_CHARACTERS);
143:
144: INSERT INTO EDR_ERESPARAMETERS_T(PARAM_ID,
145: PARENT_ID,
146: PARENT_TYPE,
147: PARAM_NAME,
148: PARAM_VALUE)

Line 150: VALUES(EDR_ERESPARAMETERS_T_S.NEXTVAL,

146: PARENT_TYPE,
147: PARAM_NAME,
148: PARAM_VALUE)
149:
150: VALUES(EDR_ERESPARAMETERS_T_S.NEXTVAL,
151: P_ERECORD_ID,
152: 'EDR_XDOC_PARAMS',
153: 'NLS_SORT',
154: L_NLS_SORT);

Line 156: INSERT INTO EDR_ERESPARAMETERS_T(PARAM_ID,

152: 'EDR_XDOC_PARAMS',
153: 'NLS_SORT',
154: L_NLS_SORT);
155:
156: INSERT INTO EDR_ERESPARAMETERS_T(PARAM_ID,
157: PARENT_ID,
158: PARENT_TYPE,
159: PARAM_NAME,
160: PARAM_VALUE)

Line 162: VALUES(EDR_ERESPARAMETERS_T_S.NEXTVAL,

158: PARENT_TYPE,
159: PARAM_NAME,
160: PARAM_VALUE)
161:
162: VALUES(EDR_ERESPARAMETERS_T_S.NEXTVAL,
163: P_ERECORD_ID,
164: 'EDR_XDOC_PARAMS',
165: 'NLS_TERRITORY',
166: L_NLS_TERRITORY);

Line 168: INSERT INTO EDR_ERESPARAMETERS_T(PARAM_ID,

164: 'EDR_XDOC_PARAMS',
165: 'NLS_TERRITORY',
166: L_NLS_TERRITORY);
167:
168: INSERT INTO EDR_ERESPARAMETERS_T(PARAM_ID,
169: PARENT_ID,
170: PARENT_TYPE,
171: PARAM_NAME,
172: PARAM_VALUE)

Line 174: VALUES(EDR_ERESPARAMETERS_T_S.NEXTVAL,

170: PARENT_TYPE,
171: PARAM_NAME,
172: PARAM_VALUE)
173:
174: VALUES(EDR_ERESPARAMETERS_T_S.NEXTVAL,
175: P_ERECORD_ID,
176: 'EDR_XDOC_PARAMS',
177: 'CURRENT_LANG',
178: L_CURRENT_LANG);

Line 179: INSERT INTO EDR_ERESPARAMETERS_T(PARAM_ID,

175: P_ERECORD_ID,
176: 'EDR_XDOC_PARAMS',
177: 'CURRENT_LANG',
178: L_CURRENT_LANG);
179: INSERT INTO EDR_ERESPARAMETERS_T(PARAM_ID,
180: PARENT_ID,
181: PARENT_TYPE,
182: PARAM_NAME,
183: PARAM_VALUE)

Line 185: VALUES(EDR_ERESPARAMETERS_T_S.NEXTVAL,

181: PARENT_TYPE,
182: PARAM_NAME,
183: PARAM_VALUE)
184:
185: VALUES(EDR_ERESPARAMETERS_T_S.NEXTVAL,
186: P_ERECORD_ID,
187: 'EDR_XDOC_PARAMS',
188: 'USER_ID',
189: TO_CHAR(L_USER_ID));

Line 191: INSERT INTO EDR_ERESPARAMETERS_T(PARAM_ID,

187: 'EDR_XDOC_PARAMS',
188: 'USER_ID',
189: TO_CHAR(L_USER_ID));
190:
191: INSERT INTO EDR_ERESPARAMETERS_T(PARAM_ID,
192: PARENT_ID,
193: PARENT_TYPE,
194: PARAM_NAME,
195: PARAM_VALUE)

Line 197: VALUES(EDR_ERESPARAMETERS_T_S.NEXTVAL,

193: PARENT_TYPE,
194: PARAM_NAME,
195: PARAM_VALUE)
196:
197: VALUES(EDR_ERESPARAMETERS_T_S.NEXTVAL,
198: P_ERECORD_ID,
199: 'EDR_XDOC_PARAMS',
200: 'RESP_ID',
201: TO_CHAR(L_RESP_ID));

Line 203: INSERT INTO EDR_ERESPARAMETERS_T(PARAM_ID,

199: 'EDR_XDOC_PARAMS',
200: 'RESP_ID',
201: TO_CHAR(L_RESP_ID));
202:
203: INSERT INTO EDR_ERESPARAMETERS_T(PARAM_ID,
204: PARENT_ID,
205: PARENT_TYPE,
206: PARAM_NAME,
207: PARAM_VALUE)

Line 209: VALUES(EDR_ERESPARAMETERS_T_S.NEXTVAL,

205: PARENT_TYPE,
206: PARAM_NAME,
207: PARAM_VALUE)
208:
209: VALUES(EDR_ERESPARAMETERS_T_S.NEXTVAL,
210: P_ERECORD_ID,
211: 'EDR_XDOC_PARAMS',
212: 'RESP_APPL_ID',
213: TO_CHAR(L_RESP_APPL_ID));

Line 215: INSERT INTO EDR_ERESPARAMETERS_T(PARAM_ID,

211: 'EDR_XDOC_PARAMS',
212: 'RESP_APPL_ID',
213: TO_CHAR(L_RESP_APPL_ID));
214:
215: INSERT INTO EDR_ERESPARAMETERS_T(PARAM_ID,
216: PARENT_ID,
217: PARENT_TYPE,
218: PARAM_NAME,
219: PARAM_VALUE)

Line 221: VALUES(EDR_ERESPARAMETERS_T_S.NEXTVAL,

217: PARENT_TYPE,
218: PARAM_NAME,
219: PARAM_VALUE)
220:
221: VALUES(EDR_ERESPARAMETERS_T_S.NEXTVAL,
222: P_ERECORD_ID,
223: 'EDR_XDOC_PARAMS',
224: 'SECURITY_GROUP_ID',
225: TO_CHAR(L_SECURITY_GROUP_ID));