DBA Data[Home] [Help]

APPS.FND_FLEX_DESCVAL dependencies on FND_FLEX_SERVER

Line 45: /* FND_FLEX_SERVER4.descval_engine() supports this functionality and was */

41:
42:
43: /* ------------------------------------------------------------------------ */
44: /* The following functions use ROWID and so were not released. The */
45: /* FND_FLEX_SERVER4.descval_engine() supports this functionality and was */
46: /* tested, but these cover functions were not. */
47: /* ------------------------------------------------------------------------ */
48:
49: /* ------------------------------------------------------------------------ */

Line 146: value_vals FND_FLEX_SERVER1.ValueArray;

142: -- PRIVATE GLOBAL VARIABLES
143: --
144:
145: nvalidated NUMBER;
146: value_vals FND_FLEX_SERVER1.ValueArray;
147: value_svals FND_FLEX_SERVER1.ValueArray;
148: value_ids FND_FLEX_SERVER1.ValueIdArray;
149: value_descs FND_FLEX_SERVER1.ValueDescArray;
150: value_desclens FND_FLEX_SERVER1.NumberArray;

Line 147: value_svals FND_FLEX_SERVER1.ValueArray;

143: --
144:
145: nvalidated NUMBER;
146: value_vals FND_FLEX_SERVER1.ValueArray;
147: value_svals FND_FLEX_SERVER1.ValueArray;
148: value_ids FND_FLEX_SERVER1.ValueIdArray;
149: value_descs FND_FLEX_SERVER1.ValueDescArray;
150: value_desclens FND_FLEX_SERVER1.NumberArray;
151: seg_cols FND_FLEX_SERVER1.TabColArray;

Line 148: value_ids FND_FLEX_SERVER1.ValueIdArray;

144:
145: nvalidated NUMBER;
146: value_vals FND_FLEX_SERVER1.ValueArray;
147: value_svals FND_FLEX_SERVER1.ValueArray;
148: value_ids FND_FLEX_SERVER1.ValueIdArray;
149: value_descs FND_FLEX_SERVER1.ValueDescArray;
150: value_desclens FND_FLEX_SERVER1.NumberArray;
151: seg_cols FND_FLEX_SERVER1.TabColArray;
152: seg_coltypes FND_FLEX_SERVER1.CharArray;

Line 149: value_descs FND_FLEX_SERVER1.ValueDescArray;

145: nvalidated NUMBER;
146: value_vals FND_FLEX_SERVER1.ValueArray;
147: value_svals FND_FLEX_SERVER1.ValueArray;
148: value_ids FND_FLEX_SERVER1.ValueIdArray;
149: value_descs FND_FLEX_SERVER1.ValueDescArray;
150: value_desclens FND_FLEX_SERVER1.NumberArray;
151: seg_cols FND_FLEX_SERVER1.TabColArray;
152: seg_coltypes FND_FLEX_SERVER1.CharArray;
153: segtypes FND_FLEX_SERVER1.SegFormats;

Line 150: value_desclens FND_FLEX_SERVER1.NumberArray;

146: value_vals FND_FLEX_SERVER1.ValueArray;
147: value_svals FND_FLEX_SERVER1.ValueArray;
148: value_ids FND_FLEX_SERVER1.ValueIdArray;
149: value_descs FND_FLEX_SERVER1.ValueDescArray;
150: value_desclens FND_FLEX_SERVER1.NumberArray;
151: seg_cols FND_FLEX_SERVER1.TabColArray;
152: seg_coltypes FND_FLEX_SERVER1.CharArray;
153: segtypes FND_FLEX_SERVER1.SegFormats;
154: disp_segs FND_FLEX_SERVER1.DisplayedSegs;

Line 151: seg_cols FND_FLEX_SERVER1.TabColArray;

147: value_svals FND_FLEX_SERVER1.ValueArray;
148: value_ids FND_FLEX_SERVER1.ValueIdArray;
149: value_descs FND_FLEX_SERVER1.ValueDescArray;
150: value_desclens FND_FLEX_SERVER1.NumberArray;
151: seg_cols FND_FLEX_SERVER1.TabColArray;
152: seg_coltypes FND_FLEX_SERVER1.CharArray;
153: segtypes FND_FLEX_SERVER1.SegFormats;
154: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
155: delim VARCHAR2(1);

Line 152: seg_coltypes FND_FLEX_SERVER1.CharArray;

148: value_ids FND_FLEX_SERVER1.ValueIdArray;
149: value_descs FND_FLEX_SERVER1.ValueDescArray;
150: value_desclens FND_FLEX_SERVER1.NumberArray;
151: seg_cols FND_FLEX_SERVER1.TabColArray;
152: seg_coltypes FND_FLEX_SERVER1.CharArray;
153: segtypes FND_FLEX_SERVER1.SegFormats;
154: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
155: delim VARCHAR2(1);
156: err_segn NUMBER;

Line 153: segtypes FND_FLEX_SERVER1.SegFormats;

149: value_descs FND_FLEX_SERVER1.ValueDescArray;
150: value_desclens FND_FLEX_SERVER1.NumberArray;
151: seg_cols FND_FLEX_SERVER1.TabColArray;
152: seg_coltypes FND_FLEX_SERVER1.CharArray;
153: segtypes FND_FLEX_SERVER1.SegFormats;
154: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
155: delim VARCHAR2(1);
156: err_segn NUMBER;
157: err_msg VARCHAR2(2000);

Line 154: disp_segs FND_FLEX_SERVER1.DisplayedSegs;

150: value_desclens FND_FLEX_SERVER1.NumberArray;
151: seg_cols FND_FLEX_SERVER1.TabColArray;
152: seg_coltypes FND_FLEX_SERVER1.CharArray;
153: segtypes FND_FLEX_SERVER1.SegFormats;
154: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
155: delim VARCHAR2(1);
156: err_segn NUMBER;
157: err_msg VARCHAR2(2000);
158: err_text VARCHAR2(2000);

Line 171: g_coldef FND_FLEX_SERVER1.ColumnDefinitions;

167: sta_serious_err BOOLEAN;
168:
169: -- Segment column names and values input
170: --
171: g_coldef FND_FLEX_SERVER1.ColumnDefinitions;
172:
173: /* ----------------------------------------------------------------------- */
174: /* THIS PACKAGE IS STILL UNDER DEVELOPMENT */
175: /* The functions herein are not be supported in any way and will */

Line 194: dummy_coldef FND_FLEX_SERVER1.ColumnDefinitions;

190: uresp_id NUMBER;
191: userid NUMBER;
192: valid_stat NUMBER;
193:
194: dummy_coldef FND_FLEX_SERVER1.ColumnDefinitions;
195:
196: BEGIN
197:
198: -- Initialize everything including all global variables and set user

Line 202: FND_FLEX_SERVER4.descval_engine(user_apid => resp_apid,

198: -- Initialize everything including all global variables and set user
199: -- Isvalid is initialized to FALSE, serious_error initialized to TRUE.
200: --
201: if(init_all(NULL, NULL, NULL, resp_apid, uresp_id, userid)) then
202: FND_FLEX_SERVER4.descval_engine(user_apid => resp_apid,
203: user_resp => uresp_id,
204: userid => userid,
205: flex_app_sname => appl_short_name,
206: desc_flex_name => desc_flex_name,

Line 263: dummy_coldef FND_FLEX_SERVER1.ColumnDefinitions;

259: uresp_id NUMBER;
260: userid NUMBER;
261: valid_stat NUMBER;
262:
263: dummy_coldef FND_FLEX_SERVER1.ColumnDefinitions;
264:
265: BEGIN
266:
267: -- Initialize everything including all global variables and set user

Line 272: FND_FLEX_SERVER4.descval_engine(user_apid => resp_apid,

268: -- Isvalid is initialized to FALSE, serious_error initialized to TRUE.
269: --
270: if(init_all(resp_appl_id, resp_id, NULL,
271: resp_apid, uresp_id, userid)) then
272: FND_FLEX_SERVER4.descval_engine(user_apid => resp_apid,
273: user_resp => uresp_id,
274: userid => userid,
275: flex_app_sname => appl_short_name,
276: desc_flex_name => desc_flex_name,

Line 334: dummy_coldef FND_FLEX_SERVER1.ColumnDefinitions;

330: valid_stat NUMBER;
331:
332: api_mode VARCHAR2(1);
333:
334: dummy_coldef FND_FLEX_SERVER1.ColumnDefinitions;
335:
336: BEGIN
337:
338: api_mode := check_api_mode(values_or_ids);

Line 346: FND_FLEX_SERVER4.descval_engine(user_apid => resp_apid,

342: --
343:
344: if(init_all(resp_appl_id, resp_id, NULL,
345: resp_apid, uresp_id, userid)) then
346: FND_FLEX_SERVER4.descval_engine(user_apid => resp_apid,
347: user_resp => uresp_id,
348: userid => userid,
349: flex_app_sname => appl_short_name,
350: desc_flex_name => desc_flex_name,

Line 432: FND_FLEX_SERVER4.descval_engine(user_apid => resp_apid,

428: g_coldef.context_value := SUBSTRB(l_default_context_value, 1, 30);
429: end if;
430: end if;
431:
432: FND_FLEX_SERVER4.descval_engine(user_apid => resp_apid,
433: user_resp => uresp_id,
434: userid => userid,
435: flex_app_sname => appl_short_name,
436: desc_flex_name => desc_flex_name,

Line 513: to_char(column_value, FND_FLEX_SERVER1.DATETIME_FMT), 'D');

509: PROCEDURE set_column_value(column_name IN VARCHAR2,
510: column_value IN DATE) IS
511: BEGIN
512: add_column_value(column_name,
513: to_char(column_value, FND_FLEX_SERVER1.DATETIME_FMT), 'D');
514: END set_column_value;
515:
516: /* ------------------------------------------------------------------------ */
517: /* Clears all defined column values. Column values are also cleared */

Line 523: FND_FLEX_SERVER4.init_coldef(g_coldef);

519: /* ------------------------------------------------------------------------ */
520:
521: PROCEDURE clear_column_values IS
522: BEGIN
523: FND_FLEX_SERVER4.init_coldef(g_coldef);
524: END clear_column_values;
525:
526: /* ------------------------------------------------------------------------ */
527: /* Functions for getting more details about the most recently */

Line 587: return(FND_FLEX_SERVER.concatenate_values(nvalidated, value_vals,

583:
584: FUNCTION concatenated_values RETURN VARCHAR2 IS
585: BEGIN
586: IF (sta_valid) THEN
587: return(FND_FLEX_SERVER.concatenate_values(nvalidated, value_vals,
588: disp_segs, delim));
589: ELSE
590: raise_application_error
591: (-20001, ('Developer Error: DVL.concatenated_values should not ' ||

Line 600: return(FND_FLEX_SERVER.concatenate_ids(nvalidated, value_ids, delim));

596:
597: FUNCTION concatenated_ids RETURN VARCHAR2 IS
598: BEGIN
599: IF (sta_valid) THEN
600: return(FND_FLEX_SERVER.concatenate_ids(nvalidated, value_ids, delim));
601: ELSE
602: raise_application_error
603: (-20001, ('Developer Error: DVL.concatenated_ids should not ' ||
604: 'be called if validation fails.'));

Line 612: return(FND_FLEX_SERVER.concatenate_descriptions(nvalidated,

608:
609: FUNCTION concatenated_descriptions RETURN VARCHAR2 IS
610: BEGIN
611: IF (sta_valid) THEN
612: return(FND_FLEX_SERVER.concatenate_descriptions(nvalidated,
613: value_descs, disp_segs, value_desclens, delim));
614: ELSE
615: raise_application_error
616: (-20001, ('Developer Error: DVL.concatenated_descriptions should not '||

Line 676: return(SUBSTR(segcodes, segnum, 1) = FND_FLEX_SERVER1.FF_VVALID);

672:
673: FUNCTION segment_valid(segnum IN NUMBER) RETURN BOOLEAN IS
674: BEGIN
675: if((segcodes is not null) and (segnum between 1 and LENGTH(segcodes))) then
676: return(SUBSTR(segcodes, segnum, 1) = FND_FLEX_SERVER1.FF_VVALID);
677: end if;
678: return(FALSE);
679: END segment_valid;
680:

Line 733: if(FND_FLEX_SERVER1.init_globals = FALSE) then

729: BEGIN
730: --
731: -- Initialize messages, debugging, and number of sql strings
732: --
733: if(FND_FLEX_SERVER1.init_globals = FALSE) then
734: return(FALSE);
735: end if;
736:
737: --

Line 797: sta_valid := (v_stat = FND_FLEX_SERVER1.VV_VALID);

793: /* ------------------------------------------------------------------------ */
794:
795: PROCEDURE set_stati(v_stat IN NUMBER) IS
796: BEGIN
797: sta_valid := (v_stat = FND_FLEX_SERVER1.VV_VALID);
798: sta_secured := ((v_stat = FND_FLEX_SERVER1.VV_SECURED) or
799: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
800: sta_value_err := (v_stat = FND_FLEX_SERVER1.VV_VALUES);
801: sta_unsupported_err := (v_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);

Line 798: sta_secured := ((v_stat = FND_FLEX_SERVER1.VV_SECURED) or

794:
795: PROCEDURE set_stati(v_stat IN NUMBER) IS
796: BEGIN
797: sta_valid := (v_stat = FND_FLEX_SERVER1.VV_VALID);
798: sta_secured := ((v_stat = FND_FLEX_SERVER1.VV_SECURED) or
799: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
800: sta_value_err := (v_stat = FND_FLEX_SERVER1.VV_VALUES);
801: sta_unsupported_err := (v_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);
802: sta_serious_err := (v_stat = FND_FLEX_SERVER1.VV_ERROR);

Line 799: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));

795: PROCEDURE set_stati(v_stat IN NUMBER) IS
796: BEGIN
797: sta_valid := (v_stat = FND_FLEX_SERVER1.VV_VALID);
798: sta_secured := ((v_stat = FND_FLEX_SERVER1.VV_SECURED) or
799: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
800: sta_value_err := (v_stat = FND_FLEX_SERVER1.VV_VALUES);
801: sta_unsupported_err := (v_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);
802: sta_serious_err := (v_stat = FND_FLEX_SERVER1.VV_ERROR);
803:

Line 800: sta_value_err := (v_stat = FND_FLEX_SERVER1.VV_VALUES);

796: BEGIN
797: sta_valid := (v_stat = FND_FLEX_SERVER1.VV_VALID);
798: sta_secured := ((v_stat = FND_FLEX_SERVER1.VV_SECURED) or
799: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
800: sta_value_err := (v_stat = FND_FLEX_SERVER1.VV_VALUES);
801: sta_unsupported_err := (v_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);
802: sta_serious_err := (v_stat = FND_FLEX_SERVER1.VV_ERROR);
803:
804: -- Clear column definitions

Line 801: sta_unsupported_err := (v_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);

797: sta_valid := (v_stat = FND_FLEX_SERVER1.VV_VALID);
798: sta_secured := ((v_stat = FND_FLEX_SERVER1.VV_SECURED) or
799: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
800: sta_value_err := (v_stat = FND_FLEX_SERVER1.VV_VALUES);
801: sta_unsupported_err := (v_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);
802: sta_serious_err := (v_stat = FND_FLEX_SERVER1.VV_ERROR);
803:
804: -- Clear column definitions
805: --

Line 802: sta_serious_err := (v_stat = FND_FLEX_SERVER1.VV_ERROR);

798: sta_secured := ((v_stat = FND_FLEX_SERVER1.VV_SECURED) or
799: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
800: sta_value_err := (v_stat = FND_FLEX_SERVER1.VV_VALUES);
801: sta_unsupported_err := (v_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);
802: sta_serious_err := (v_stat = FND_FLEX_SERVER1.VV_ERROR);
803:
804: -- Clear column definitions
805: --
806: FND_FLEX_SERVER4.init_coldef(g_coldef);

Line 806: FND_FLEX_SERVER4.init_coldef(g_coldef);

802: sta_serious_err := (v_stat = FND_FLEX_SERVER1.VV_ERROR);
803:
804: -- Clear column definitions
805: --
806: FND_FLEX_SERVER4.init_coldef(g_coldef);
807:
808: END set_stati;
809:
810: /* ------------------------------------------------------------------------ */