eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.FND_FLEX_EXT dependencies on FND_FLEX_SERVER1

Line 14: FUNCTION read_displayedsegs(fstruct IN FND_FLEX_SERVER1.FlexStructId,

10: OLD_DATE_LEN CONSTANT NUMBER := 11;
11:
12: -- PRIVATE FUNCTIONS
13: --
14: FUNCTION read_displayedsegs(fstruct IN FND_FLEX_SERVER1.FlexStructId,
15: disp_segs OUT nocopy FND_FLEX_SERVER1.DisplayedSegs)
16: RETURN BOOLEAN;
17:
18: FUNCTION is_allow_id_valuesets(i_application_short_name IN VARCHAR2,

Line 15: disp_segs OUT nocopy FND_FLEX_SERVER1.DisplayedSegs)

11:
12: -- PRIVATE FUNCTIONS
13: --
14: FUNCTION read_displayedsegs(fstruct IN FND_FLEX_SERVER1.FlexStructId,
15: disp_segs OUT nocopy FND_FLEX_SERVER1.DisplayedSegs)
16: RETURN BOOLEAN;
17:
18: FUNCTION is_allow_id_valuesets(i_application_short_name IN VARCHAR2,
19: i_id_flex_code IN VARCHAR2,

Line 63: value_dvals FND_FLEX_SERVER1.ValueArray;

59: chr_newline VARCHAR2(8); -- := fnd_global.newline;
60:
61: ext_globals_valid BOOLEAN := FALSE;
62: nvalidated NUMBER;
63: value_dvals FND_FLEX_SERVER1.ValueArray;
64: value_vals FND_FLEX_SERVER1.ValueArray;
65: value_ids FND_FLEX_SERVER1.ValueIdArray;
66: value_descs FND_FLEX_SERVER1.ValueDescArray;
67: value_desclens FND_FLEX_SERVER1.NumberArray;

Line 64: value_vals FND_FLEX_SERVER1.ValueArray;

60:
61: ext_globals_valid BOOLEAN := FALSE;
62: nvalidated NUMBER;
63: value_dvals FND_FLEX_SERVER1.ValueArray;
64: value_vals FND_FLEX_SERVER1.ValueArray;
65: value_ids FND_FLEX_SERVER1.ValueIdArray;
66: value_descs FND_FLEX_SERVER1.ValueDescArray;
67: value_desclens FND_FLEX_SERVER1.NumberArray;
68: cc_cols FND_FLEX_SERVER1.TabColArray;

Line 65: value_ids FND_FLEX_SERVER1.ValueIdArray;

61: ext_globals_valid BOOLEAN := FALSE;
62: nvalidated NUMBER;
63: value_dvals FND_FLEX_SERVER1.ValueArray;
64: value_vals FND_FLEX_SERVER1.ValueArray;
65: value_ids FND_FLEX_SERVER1.ValueIdArray;
66: value_descs FND_FLEX_SERVER1.ValueDescArray;
67: value_desclens FND_FLEX_SERVER1.NumberArray;
68: cc_cols FND_FLEX_SERVER1.TabColArray;
69: cc_coltypes FND_FLEX_SERVER1.CharArray;

Line 66: value_descs FND_FLEX_SERVER1.ValueDescArray;

62: nvalidated NUMBER;
63: value_dvals FND_FLEX_SERVER1.ValueArray;
64: value_vals FND_FLEX_SERVER1.ValueArray;
65: value_ids FND_FLEX_SERVER1.ValueIdArray;
66: value_descs FND_FLEX_SERVER1.ValueDescArray;
67: value_desclens FND_FLEX_SERVER1.NumberArray;
68: cc_cols FND_FLEX_SERVER1.TabColArray;
69: cc_coltypes FND_FLEX_SERVER1.CharArray;
70: segtypes FND_FLEX_SERVER1.SegFormats;

Line 67: value_desclens FND_FLEX_SERVER1.NumberArray;

63: value_dvals FND_FLEX_SERVER1.ValueArray;
64: value_vals FND_FLEX_SERVER1.ValueArray;
65: value_ids FND_FLEX_SERVER1.ValueIdArray;
66: value_descs FND_FLEX_SERVER1.ValueDescArray;
67: value_desclens FND_FLEX_SERVER1.NumberArray;
68: cc_cols FND_FLEX_SERVER1.TabColArray;
69: cc_coltypes FND_FLEX_SERVER1.CharArray;
70: segtypes FND_FLEX_SERVER1.SegFormats;
71: disp_segs FND_FLEX_SERVER1.DisplayedSegs;

Line 68: cc_cols FND_FLEX_SERVER1.TabColArray;

64: value_vals FND_FLEX_SERVER1.ValueArray;
65: value_ids FND_FLEX_SERVER1.ValueIdArray;
66: value_descs FND_FLEX_SERVER1.ValueDescArray;
67: value_desclens FND_FLEX_SERVER1.NumberArray;
68: cc_cols FND_FLEX_SERVER1.TabColArray;
69: cc_coltypes FND_FLEX_SERVER1.CharArray;
70: segtypes FND_FLEX_SERVER1.SegFormats;
71: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
72: derv FND_FLEX_SERVER1.DerivedVals;

Line 69: cc_coltypes FND_FLEX_SERVER1.CharArray;

65: value_ids FND_FLEX_SERVER1.ValueIdArray;
66: value_descs FND_FLEX_SERVER1.ValueDescArray;
67: value_desclens FND_FLEX_SERVER1.NumberArray;
68: cc_cols FND_FLEX_SERVER1.TabColArray;
69: cc_coltypes FND_FLEX_SERVER1.CharArray;
70: segtypes FND_FLEX_SERVER1.SegFormats;
71: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
72: derv FND_FLEX_SERVER1.DerivedVals;
73: tbl_derv FND_FLEX_SERVER1.DerivedVals;

Line 70: segtypes FND_FLEX_SERVER1.SegFormats;

66: value_descs FND_FLEX_SERVER1.ValueDescArray;
67: value_desclens FND_FLEX_SERVER1.NumberArray;
68: cc_cols FND_FLEX_SERVER1.TabColArray;
69: cc_coltypes FND_FLEX_SERVER1.CharArray;
70: segtypes FND_FLEX_SERVER1.SegFormats;
71: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
72: derv FND_FLEX_SERVER1.DerivedVals;
73: tbl_derv FND_FLEX_SERVER1.DerivedVals;
74: drv_quals FND_FLEX_SERVER1.Qualifiers;

Line 71: disp_segs FND_FLEX_SERVER1.DisplayedSegs;

67: value_desclens FND_FLEX_SERVER1.NumberArray;
68: cc_cols FND_FLEX_SERVER1.TabColArray;
69: cc_coltypes FND_FLEX_SERVER1.CharArray;
70: segtypes FND_FLEX_SERVER1.SegFormats;
71: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
72: derv FND_FLEX_SERVER1.DerivedVals;
73: tbl_derv FND_FLEX_SERVER1.DerivedVals;
74: drv_quals FND_FLEX_SERVER1.Qualifiers;
75: tbl_quals FND_FLEX_SERVER1.Qualifiers;

Line 72: derv FND_FLEX_SERVER1.DerivedVals;

68: cc_cols FND_FLEX_SERVER1.TabColArray;
69: cc_coltypes FND_FLEX_SERVER1.CharArray;
70: segtypes FND_FLEX_SERVER1.SegFormats;
71: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
72: derv FND_FLEX_SERVER1.DerivedVals;
73: tbl_derv FND_FLEX_SERVER1.DerivedVals;
74: drv_quals FND_FLEX_SERVER1.Qualifiers;
75: tbl_quals FND_FLEX_SERVER1.Qualifiers;
76: n_xcol_vals NUMBER;

Line 73: tbl_derv FND_FLEX_SERVER1.DerivedVals;

69: cc_coltypes FND_FLEX_SERVER1.CharArray;
70: segtypes FND_FLEX_SERVER1.SegFormats;
71: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
72: derv FND_FLEX_SERVER1.DerivedVals;
73: tbl_derv FND_FLEX_SERVER1.DerivedVals;
74: drv_quals FND_FLEX_SERVER1.Qualifiers;
75: tbl_quals FND_FLEX_SERVER1.Qualifiers;
76: n_xcol_vals NUMBER;
77: xcol_vals FND_FLEX_SERVER1.StringArray;

Line 74: drv_quals FND_FLEX_SERVER1.Qualifiers;

70: segtypes FND_FLEX_SERVER1.SegFormats;
71: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
72: derv FND_FLEX_SERVER1.DerivedVals;
73: tbl_derv FND_FLEX_SERVER1.DerivedVals;
74: drv_quals FND_FLEX_SERVER1.Qualifiers;
75: tbl_quals FND_FLEX_SERVER1.Qualifiers;
76: n_xcol_vals NUMBER;
77: xcol_vals FND_FLEX_SERVER1.StringArray;
78: new_comb BOOLEAN;

Line 75: tbl_quals FND_FLEX_SERVER1.Qualifiers;

71: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
72: derv FND_FLEX_SERVER1.DerivedVals;
73: tbl_derv FND_FLEX_SERVER1.DerivedVals;
74: drv_quals FND_FLEX_SERVER1.Qualifiers;
75: tbl_quals FND_FLEX_SERVER1.Qualifiers;
76: n_xcol_vals NUMBER;
77: xcol_vals FND_FLEX_SERVER1.StringArray;
78: new_comb BOOLEAN;
79: segment_codes VARCHAR2(30);

Line 77: xcol_vals FND_FLEX_SERVER1.StringArray;

73: tbl_derv FND_FLEX_SERVER1.DerivedVals;
74: drv_quals FND_FLEX_SERVER1.Qualifiers;
75: tbl_quals FND_FLEX_SERVER1.Qualifiers;
76: n_xcol_vals NUMBER;
77: xcol_vals FND_FLEX_SERVER1.StringArray;
78: new_comb BOOLEAN;
79: segment_codes VARCHAR2(30);
80: valid_stat NUMBER;
81: ccid_o NUMBER;

Line 453: if(FND_FLEX_SERVER1.init_globals = FALSE) THEN

449: -- Initialize messages, debugging, and number of sql strings
450: --
451: init_message;
452: ext_globals_valid := FALSE;
453: if(FND_FLEX_SERVER1.init_globals = FALSE) THEN
454: set_failed;
455: return(FALSE);
456: end if;
457:

Line 468: if(valid_stat = FND_FLEX_SERVER1.VV_VALID) then

464: value_descs, value_desclens, cc_cols, cc_coltypes, segtypes,
465: disp_segs, derv, tbl_derv, drv_quals, tbl_quals,
466: n_xcol_vals, xcol_vals, delim, ccid_o, new_comb, valid_stat,
467: segcodes, err_segn);
468: if(valid_stat = FND_FLEX_SERVER1.VV_VALID) then
469: combination_id := ccid_o;
470: ext_globals_valid := TRUE;
471: return(TRUE);
472: end if;

Line 614: kff_id FND_FLEX_SERVER1.FlexStructId;

610: data_set IN NUMBER DEFAULT -1)
611: RETURN BOOLEAN IS
612: n_dispsegs NUMBER;
613:
614: kff_id FND_FLEX_SERVER1.FlexStructId;
615: kff_info FND_FLEX_SERVER1.FlexStructInfo;
616: kff_cc FND_FLEX_SERVER1.CombTblInfo;
617: tmp_qualcols FND_FLEX_SERVER1.TabColArray;
618: tmp_xcolnames FND_FLEX_SERVER1.StringArray;

Line 615: kff_info FND_FLEX_SERVER1.FlexStructInfo;

611: RETURN BOOLEAN IS
612: n_dispsegs NUMBER;
613:
614: kff_id FND_FLEX_SERVER1.FlexStructId;
615: kff_info FND_FLEX_SERVER1.FlexStructInfo;
616: kff_cc FND_FLEX_SERVER1.CombTblInfo;
617: tmp_qualcols FND_FLEX_SERVER1.TabColArray;
618: tmp_xcolnames FND_FLEX_SERVER1.StringArray;
619:

Line 616: kff_cc FND_FLEX_SERVER1.CombTblInfo;

612: n_dispsegs NUMBER;
613:
614: kff_id FND_FLEX_SERVER1.FlexStructId;
615: kff_info FND_FLEX_SERVER1.FlexStructInfo;
616: kff_cc FND_FLEX_SERVER1.CombTblInfo;
617: tmp_qualcols FND_FLEX_SERVER1.TabColArray;
618: tmp_xcolnames FND_FLEX_SERVER1.StringArray;
619:
620: nfound NUMBER;

Line 617: tmp_qualcols FND_FLEX_SERVER1.TabColArray;

613:
614: kff_id FND_FLEX_SERVER1.FlexStructId;
615: kff_info FND_FLEX_SERVER1.FlexStructInfo;
616: kff_cc FND_FLEX_SERVER1.CombTblInfo;
617: tmp_qualcols FND_FLEX_SERVER1.TabColArray;
618: tmp_xcolnames FND_FLEX_SERVER1.StringArray;
619:
620: nfound NUMBER;
621: ccid NUMBER;

Line 618: tmp_xcolnames FND_FLEX_SERVER1.StringArray;

614: kff_id FND_FLEX_SERVER1.FlexStructId;
615: kff_info FND_FLEX_SERVER1.FlexStructInfo;
616: kff_cc FND_FLEX_SERVER1.CombTblInfo;
617: tmp_qualcols FND_FLEX_SERVER1.TabColArray;
618: tmp_xcolnames FND_FLEX_SERVER1.StringArray;
619:
620: nfound NUMBER;
621: ccid NUMBER;
622: struct_def_val NUMBER;

Line 633: if(FND_FLEX_SERVER1.init_globals = FALSE) THEN

629: -- Initialize messages, debugging, and number of sql strings
630: --
631: n_segments := 0;
632: ext_globals_valid := FALSE;
633: if(FND_FLEX_SERVER1.init_globals = FALSE) THEN
634: GOTO label_failure;
635: end if;
636:
637: --

Line 695: IF (fnd_flex_server1.g_debug_level > 0) THEN

691: * or disabling on the combination or its values and does not check
692: * value security.
693: */
694:
695: IF (fnd_flex_server1.g_debug_level > 0) THEN
696: FND_FLEX_SERVER1.add_debug('Non-ID value sets.Skip full validation');
697: END IF;
698:
699: -- Check CCID.

Line 696: FND_FLEX_SERVER1.add_debug('Non-ID value sets.Skip full validation');

692: * value security.
693: */
694:
695: IF (fnd_flex_server1.g_debug_level > 0) THEN
696: FND_FLEX_SERVER1.add_debug('Non-ID value sets.Skip full validation');
697: END IF;
698:
699: -- Check CCID.
700: --

Line 780: valid_stat := FND_FLEX_SERVER1.VV_VALID;

776: IF (NOT read_displayedsegs(kff_id, disp_segs)) THEN
777: GOTO label_failure;
778: END IF;
779:
780: valid_stat := FND_FLEX_SERVER1.VV_VALID;
781:
782: ELSE
783: -- Allow id valuesets is 'Y'; do full validation.
784: --

Line 802: if((valid_stat = FND_FLEX_SERVER1.VV_VALID) or

798:
799: -- Return only the displayed segments if combination found
800: --
801: l_newline_comb := '';
802: if((valid_stat = FND_FLEX_SERVER1.VV_VALID) or
803: (valid_stat = FND_FLEX_SERVER1.VV_SECURED)) then
804: n_dispsegs := 0;
805: for i in 1..nvalidated loop
806: if(disp_segs.segflags(i)) THEN

Line 803: (valid_stat = FND_FLEX_SERVER1.VV_SECURED)) then

799: -- Return only the displayed segments if combination found
800: --
801: l_newline_comb := '';
802: if((valid_stat = FND_FLEX_SERVER1.VV_VALID) or
803: (valid_stat = FND_FLEX_SERVER1.VV_SECURED)) then
804: n_dispsegs := 0;
805: for i in 1..nvalidated loop
806: if(disp_segs.segflags(i)) THEN
807: n_dispsegs := n_dispsegs + 1;

Line 892: if(FND_FLEX_SERVER1.init_globals = FALSE) THEN

888: if ((sepchar is not null) and
889: (concat_segs(n_segments, segments, sepchar, catsegs) = TRUE)) then
890:
891: ext_globals_valid := FALSE;
892: if(FND_FLEX_SERVER1.init_globals = FALSE) THEN
893: set_failed;
894: return(FALSE);
895: end if;
896:

Line 907: if(valid_stat = FND_FLEX_SERVER1.VV_VALID) then

903: value_descs, value_desclens, cc_cols, cc_coltypes, segtypes,
904: disp_segs, derv, tbl_derv, drv_quals, tbl_quals,
905: n_xcol_vals, xcol_vals, delim, ccid_o, new_comb, valid_stat,
906: segcodes, err_segn);
907: if(valid_stat = FND_FLEX_SERVER1.VV_VALID) then
908: combination_id := ccid_o;
909: ext_globals_valid := TRUE;
910: return(TRUE);
911: end if;

Line 936: FUNCTION read_displayedsegs(fstruct IN FND_FLEX_SERVER1.FlexStructId,

932: /* ------------------------------------------------------------------------ */
933: /* This function is copied from SV2[S|B].get_struct_cols() */
934: /* Gets the displayed information. */
935: /* ------------------------------------------------------------------------ */
936: FUNCTION read_displayedsegs(fstruct IN FND_FLEX_SERVER1.FlexStructId,
937: disp_segs OUT nocopy FND_FLEX_SERVER1.DisplayedSegs)
938: RETURN BOOLEAN IS
939: ncols NUMBER;
940:

Line 937: disp_segs OUT nocopy FND_FLEX_SERVER1.DisplayedSegs)

933: /* This function is copied from SV2[S|B].get_struct_cols() */
934: /* Gets the displayed information. */
935: /* ------------------------------------------------------------------------ */
936: FUNCTION read_displayedsegs(fstruct IN FND_FLEX_SERVER1.FlexStructId,
937: disp_segs OUT nocopy FND_FLEX_SERVER1.DisplayedSegs)
938: RETURN BOOLEAN IS
939: ncols NUMBER;
940:
941: CURSOR Key_column_cursor(keystruct IN FND_FLEX_SERVER1.FlexStructId) IS

Line 941: CURSOR Key_column_cursor(keystruct IN FND_FLEX_SERVER1.FlexStructId) IS

937: disp_segs OUT nocopy FND_FLEX_SERVER1.DisplayedSegs)
938: RETURN BOOLEAN IS
939: ncols NUMBER;
940:
941: CURSOR Key_column_cursor(keystruct IN FND_FLEX_SERVER1.FlexStructId) IS
942: SELECT g.display_flag
943: FROM fnd_id_flex_segments g
944: WHERE g.application_id = keystruct.application_id
945: AND g.id_flex_code = keystruct.id_flex_code

Line 1101: /* Copied from FND_FLEX_SERVER1.to_stringarray. Uses SegmentArray */

1097:
1098: /* ----------------------------------------------------------------------- */
1099: /* Converts concatenated segments to segment array */
1100: /* Segment array is 1-based containing entries for 1 <= i <= nsegs */
1101: /* Copied from FND_FLEX_SERVER1.to_stringarray. Uses SegmentArray */
1102: /* instead of StringArray. */
1103: /* ----------------------------------------------------------------------- */
1104:
1105: FUNCTION to_segmentarray(catsegs IN VARCHAR2,

Line 1232: /* Copied from FND_FLEX_SERVER1.from_stringarray. Uses SegmentArray */

1228:
1229: /* ----------------------------------------------------------------------- */
1230: /* Converts segment array to concatenated segments */
1231: /* Segment array is 1-based containing entries for 1 <= i <= nsegs */
1232: /* Copied from FND_FLEX_SERVER1.from_stringarray. Uses SegmentArray */
1233: /* instead of StringArray. */
1234: /* ----------------------------------------------------------------------- */
1235: FUNCTION from_segmentarray(nsegs IN NUMBER,
1236: segs IN SegmentArray,

Line 1246: IF (fnd_flex_server1.g_debug_level > 0) THEN

1242: l_segnum pls_integer;
1243: l_delimiter VARCHAR2(10);
1244: BEGIN
1245: l_delimiter := Substr(sepchar, 1, 1);
1246: IF (fnd_flex_server1.g_debug_level > 0) THEN
1247: fnd_flex_server1.add_debug('BEGIN EXT.from_segmentarray()');
1248: END IF;
1249: --
1250: -- Make sure delimiter is valid.

Line 1247: fnd_flex_server1.add_debug('BEGIN EXT.from_segmentarray()');

1243: l_delimiter VARCHAR2(10);
1244: BEGIN
1245: l_delimiter := Substr(sepchar, 1, 1);
1246: IF (fnd_flex_server1.g_debug_level > 0) THEN
1247: fnd_flex_server1.add_debug('BEGIN EXT.from_segmentarray()');
1248: END IF;
1249: --
1250: -- Make sure delimiter is valid.
1251: --

Line 1313: IF (fnd_flex_server1.g_debug_level > 0) THEN

1309: END IF;
1310: END LOOP;
1311:
1312: <>
1313: IF (fnd_flex_server1.g_debug_level > 0) THEN
1314: fnd_flex_server1.add_debug('END EXT.from_segmentarray()');
1315: END IF;
1316: RETURN(l_return);
1317: EXCEPTION

Line 1314: fnd_flex_server1.add_debug('END EXT.from_segmentarray()');

1310: END LOOP;
1311:
1312: <>
1313: IF (fnd_flex_server1.g_debug_level > 0) THEN
1314: fnd_flex_server1.add_debug('END EXT.from_segmentarray()');
1315: END IF;
1316: RETURN(l_return);
1317: EXCEPTION
1318: WHEN OTHERS THEN

Line 1319: IF (fnd_flex_server1.g_debug_level > 0) THEN

1315: END IF;
1316: RETURN(l_return);
1317: EXCEPTION
1318: WHEN OTHERS THEN
1319: IF (fnd_flex_server1.g_debug_level > 0) THEN
1320: fnd_flex_server1.add_debug('EXCEPTION EXT.from_segmentarray()');
1321: END IF;
1322: raise_application_error(-20001, 'EXT.from_segmentarray. SQLERRM : ' || Sqlerrm);
1323: END from_segmentarray;

Line 1320: fnd_flex_server1.add_debug('EXCEPTION EXT.from_segmentarray()');

1316: RETURN(l_return);
1317: EXCEPTION
1318: WHEN OTHERS THEN
1319: IF (fnd_flex_server1.g_debug_level > 0) THEN
1320: fnd_flex_server1.add_debug('EXCEPTION EXT.from_segmentarray()');
1321: END IF;
1322: raise_application_error(-20001, 'EXT.from_segmentarray. SQLERRM : ' || Sqlerrm);
1323: END from_segmentarray;
1324: