117: P_arg100 varchar2(240) := CHR(0);
118:
119:
120: P_errnum number := 0;
121: P_fsegs fnd_dflex.segments_dr;
122:
123:
124: procedure initialize is
125:
122:
123:
124: procedure initialize is
125:
126: flexi fnd_dflex.dflex_dr;
127: fcontexts fnd_dflex.contexts_dr;
128: fcontext fnd_dflex.context_r;
129: prog_app_name varchar2(30);
130: prog_name varchar2(30);
123:
124: procedure initialize is
125:
126: flexi fnd_dflex.dflex_dr;
127: fcontexts fnd_dflex.contexts_dr;
128: fcontext fnd_dflex.context_r;
129: prog_app_name varchar2(30);
130: prog_name varchar2(30);
131:
124: procedure initialize is
125:
126: flexi fnd_dflex.dflex_dr;
127: fcontexts fnd_dflex.contexts_dr;
128: fcontext fnd_dflex.context_r;
129: prog_app_name varchar2(30);
130: prog_name varchar2(30);
131:
132: begin
185: and r.application_id = a.application_id;
186:
187:
188:
189: fnd_dflex.get_flexfield(prog_app_name, '$SRS$.' || prog_name,
190: fcontext.flexfield, flexi);
191: fnd_dflex.get_contexts(fcontext.flexfield, fcontexts);
192: fcontext.context_code := fcontexts.context_code(fcontexts.global_context);
193: fnd_dflex.get_segments(fcontext,P_fsegs, TRUE);
187:
188:
189: fnd_dflex.get_flexfield(prog_app_name, '$SRS$.' || prog_name,
190: fcontext.flexfield, flexi);
191: fnd_dflex.get_contexts(fcontext.flexfield, fcontexts);
192: fcontext.context_code := fcontexts.context_code(fcontexts.global_context);
193: fnd_dflex.get_segments(fcontext,P_fsegs, TRUE);
194:
195: P_ProgName := prog_name;
189: fnd_dflex.get_flexfield(prog_app_name, '$SRS$.' || prog_name,
190: fcontext.flexfield, flexi);
191: fnd_dflex.get_contexts(fcontext.flexfield, fcontexts);
192: fcontext.context_code := fcontexts.context_code(fcontexts.global_context);
193: fnd_dflex.get_segments(fcontext,P_fsegs, TRUE);
194:
195: P_ProgName := prog_name;
196: P_ProgAppName := prog_app_name;
197: