34: where_clause_msg IN VARCHAR2,
35: get_extra_cols IN VARCHAR2,
36: ccid_in IN NUMBER,
37: nvalidated OUT nocopy NUMBER,
38: displayed_vals OUT nocopy FND_FLEX_SERVER1.ValueArray,
39: stored_vals OUT nocopy FND_FLEX_SERVER1.ValueArray,
40: segment_ids OUT nocopy FND_FLEX_SERVER1.ValueIdArray,
41: descriptions OUT nocopy FND_FLEX_SERVER1.ValueDescArray,
42: desc_lengths OUT nocopy FND_FLEX_SERVER1.NumberArray,
35: get_extra_cols IN VARCHAR2,
36: ccid_in IN NUMBER,
37: nvalidated OUT nocopy NUMBER,
38: displayed_vals OUT nocopy FND_FLEX_SERVER1.ValueArray,
39: stored_vals OUT nocopy FND_FLEX_SERVER1.ValueArray,
40: segment_ids OUT nocopy FND_FLEX_SERVER1.ValueIdArray,
41: descriptions OUT nocopy FND_FLEX_SERVER1.ValueDescArray,
42: desc_lengths OUT nocopy FND_FLEX_SERVER1.NumberArray,
43: seg_colnames OUT nocopy FND_FLEX_SERVER1.TabColArray,
36: ccid_in IN NUMBER,
37: nvalidated OUT nocopy NUMBER,
38: displayed_vals OUT nocopy FND_FLEX_SERVER1.ValueArray,
39: stored_vals OUT nocopy FND_FLEX_SERVER1.ValueArray,
40: segment_ids OUT nocopy FND_FLEX_SERVER1.ValueIdArray,
41: descriptions OUT nocopy FND_FLEX_SERVER1.ValueDescArray,
42: desc_lengths OUT nocopy FND_FLEX_SERVER1.NumberArray,
43: seg_colnames OUT nocopy FND_FLEX_SERVER1.TabColArray,
44: seg_coltypes OUT nocopy FND_FLEX_SERVER1.CharArray,
37: nvalidated OUT nocopy NUMBER,
38: displayed_vals OUT nocopy FND_FLEX_SERVER1.ValueArray,
39: stored_vals OUT nocopy FND_FLEX_SERVER1.ValueArray,
40: segment_ids OUT nocopy FND_FLEX_SERVER1.ValueIdArray,
41: descriptions OUT nocopy FND_FLEX_SERVER1.ValueDescArray,
42: desc_lengths OUT nocopy FND_FLEX_SERVER1.NumberArray,
43: seg_colnames OUT nocopy FND_FLEX_SERVER1.TabColArray,
44: seg_coltypes OUT nocopy FND_FLEX_SERVER1.CharArray,
45: segment_types OUT nocopy FND_FLEX_SERVER1.SegFormats,
38: displayed_vals OUT nocopy FND_FLEX_SERVER1.ValueArray,
39: stored_vals OUT nocopy FND_FLEX_SERVER1.ValueArray,
40: segment_ids OUT nocopy FND_FLEX_SERVER1.ValueIdArray,
41: descriptions OUT nocopy FND_FLEX_SERVER1.ValueDescArray,
42: desc_lengths OUT nocopy FND_FLEX_SERVER1.NumberArray,
43: seg_colnames OUT nocopy FND_FLEX_SERVER1.TabColArray,
44: seg_coltypes OUT nocopy FND_FLEX_SERVER1.CharArray,
45: segment_types OUT nocopy FND_FLEX_SERVER1.SegFormats,
46: displayed_segs OUT nocopy FND_FLEX_SERVER1.DisplayedSegs,
39: stored_vals OUT nocopy FND_FLEX_SERVER1.ValueArray,
40: segment_ids OUT nocopy FND_FLEX_SERVER1.ValueIdArray,
41: descriptions OUT nocopy FND_FLEX_SERVER1.ValueDescArray,
42: desc_lengths OUT nocopy FND_FLEX_SERVER1.NumberArray,
43: seg_colnames OUT nocopy FND_FLEX_SERVER1.TabColArray,
44: seg_coltypes OUT nocopy FND_FLEX_SERVER1.CharArray,
45: segment_types OUT nocopy FND_FLEX_SERVER1.SegFormats,
46: displayed_segs OUT nocopy FND_FLEX_SERVER1.DisplayedSegs,
47: derived_eff OUT nocopy FND_FLEX_SERVER1.DerivedVals,
40: segment_ids OUT nocopy FND_FLEX_SERVER1.ValueIdArray,
41: descriptions OUT nocopy FND_FLEX_SERVER1.ValueDescArray,
42: desc_lengths OUT nocopy FND_FLEX_SERVER1.NumberArray,
43: seg_colnames OUT nocopy FND_FLEX_SERVER1.TabColArray,
44: seg_coltypes OUT nocopy FND_FLEX_SERVER1.CharArray,
45: segment_types OUT nocopy FND_FLEX_SERVER1.SegFormats,
46: displayed_segs OUT nocopy FND_FLEX_SERVER1.DisplayedSegs,
47: derived_eff OUT nocopy FND_FLEX_SERVER1.DerivedVals,
48: table_eff OUT nocopy FND_FLEX_SERVER1.DerivedVals,
41: descriptions OUT nocopy FND_FLEX_SERVER1.ValueDescArray,
42: desc_lengths OUT nocopy FND_FLEX_SERVER1.NumberArray,
43: seg_colnames OUT nocopy FND_FLEX_SERVER1.TabColArray,
44: seg_coltypes OUT nocopy FND_FLEX_SERVER1.CharArray,
45: segment_types OUT nocopy FND_FLEX_SERVER1.SegFormats,
46: displayed_segs OUT nocopy FND_FLEX_SERVER1.DisplayedSegs,
47: derived_eff OUT nocopy FND_FLEX_SERVER1.DerivedVals,
48: table_eff OUT nocopy FND_FLEX_SERVER1.DerivedVals,
49: derived_quals OUT nocopy FND_FLEX_SERVER1.Qualifiers,
42: desc_lengths OUT nocopy FND_FLEX_SERVER1.NumberArray,
43: seg_colnames OUT nocopy FND_FLEX_SERVER1.TabColArray,
44: seg_coltypes OUT nocopy FND_FLEX_SERVER1.CharArray,
45: segment_types OUT nocopy FND_FLEX_SERVER1.SegFormats,
46: displayed_segs OUT nocopy FND_FLEX_SERVER1.DisplayedSegs,
47: derived_eff OUT nocopy FND_FLEX_SERVER1.DerivedVals,
48: table_eff OUT nocopy FND_FLEX_SERVER1.DerivedVals,
49: derived_quals OUT nocopy FND_FLEX_SERVER1.Qualifiers,
50: table_quals OUT nocopy FND_FLEX_SERVER1.Qualifiers,
43: seg_colnames OUT nocopy FND_FLEX_SERVER1.TabColArray,
44: seg_coltypes OUT nocopy FND_FLEX_SERVER1.CharArray,
45: segment_types OUT nocopy FND_FLEX_SERVER1.SegFormats,
46: displayed_segs OUT nocopy FND_FLEX_SERVER1.DisplayedSegs,
47: derived_eff OUT nocopy FND_FLEX_SERVER1.DerivedVals,
48: table_eff OUT nocopy FND_FLEX_SERVER1.DerivedVals,
49: derived_quals OUT nocopy FND_FLEX_SERVER1.Qualifiers,
50: table_quals OUT nocopy FND_FLEX_SERVER1.Qualifiers,
51: n_column_vals OUT nocopy NUMBER,
44: seg_coltypes OUT nocopy FND_FLEX_SERVER1.CharArray,
45: segment_types OUT nocopy FND_FLEX_SERVER1.SegFormats,
46: displayed_segs OUT nocopy FND_FLEX_SERVER1.DisplayedSegs,
47: derived_eff OUT nocopy FND_FLEX_SERVER1.DerivedVals,
48: table_eff OUT nocopy FND_FLEX_SERVER1.DerivedVals,
49: derived_quals OUT nocopy FND_FLEX_SERVER1.Qualifiers,
50: table_quals OUT nocopy FND_FLEX_SERVER1.Qualifiers,
51: n_column_vals OUT nocopy NUMBER,
52: column_vals OUT nocopy FND_FLEX_SERVER1.StringArray,
45: segment_types OUT nocopy FND_FLEX_SERVER1.SegFormats,
46: displayed_segs OUT nocopy FND_FLEX_SERVER1.DisplayedSegs,
47: derived_eff OUT nocopy FND_FLEX_SERVER1.DerivedVals,
48: table_eff OUT nocopy FND_FLEX_SERVER1.DerivedVals,
49: derived_quals OUT nocopy FND_FLEX_SERVER1.Qualifiers,
50: table_quals OUT nocopy FND_FLEX_SERVER1.Qualifiers,
51: n_column_vals OUT nocopy NUMBER,
52: column_vals OUT nocopy FND_FLEX_SERVER1.StringArray,
53: seg_delimiter OUT nocopy VARCHAR2,
46: displayed_segs OUT nocopy FND_FLEX_SERVER1.DisplayedSegs,
47: derived_eff OUT nocopy FND_FLEX_SERVER1.DerivedVals,
48: table_eff OUT nocopy FND_FLEX_SERVER1.DerivedVals,
49: derived_quals OUT nocopy FND_FLEX_SERVER1.Qualifiers,
50: table_quals OUT nocopy FND_FLEX_SERVER1.Qualifiers,
51: n_column_vals OUT nocopy NUMBER,
52: column_vals OUT nocopy FND_FLEX_SERVER1.StringArray,
53: seg_delimiter OUT nocopy VARCHAR2,
54: ccid_out OUT nocopy NUMBER,
48: table_eff OUT nocopy FND_FLEX_SERVER1.DerivedVals,
49: derived_quals OUT nocopy FND_FLEX_SERVER1.Qualifiers,
50: table_quals OUT nocopy FND_FLEX_SERVER1.Qualifiers,
51: n_column_vals OUT nocopy NUMBER,
52: column_vals OUT nocopy FND_FLEX_SERVER1.StringArray,
53: seg_delimiter OUT nocopy VARCHAR2,
54: ccid_out OUT nocopy NUMBER,
55: new_combination OUT nocopy BOOLEAN,
56: v_status OUT nocopy NUMBER,
61: -- find_combination() function made public and used in AFFFEXTB package.
62: -- ----------------------------------------------------------------------
63: FUNCTION find_combination
64: (structnum IN NUMBER,
65: combtbl IN FND_FLEX_SERVER1.CombTblInfo,
66: nsegs IN NUMBER,
67: combcols IN FND_FLEX_SERVER1.TabColArray,
68: combtypes IN FND_FLEX_SERVER1.CharArray,
69: segfmts IN FND_FLEX_SERVER1.SegFormats,
63: FUNCTION find_combination
64: (structnum IN NUMBER,
65: combtbl IN FND_FLEX_SERVER1.CombTblInfo,
66: nsegs IN NUMBER,
67: combcols IN FND_FLEX_SERVER1.TabColArray,
68: combtypes IN FND_FLEX_SERVER1.CharArray,
69: segfmts IN FND_FLEX_SERVER1.SegFormats,
70: nquals IN NUMBER,
71: qualcols IN FND_FLEX_SERVER1.TabColArray,
64: (structnum IN NUMBER,
65: combtbl IN FND_FLEX_SERVER1.CombTblInfo,
66: nsegs IN NUMBER,
67: combcols IN FND_FLEX_SERVER1.TabColArray,
68: combtypes IN FND_FLEX_SERVER1.CharArray,
69: segfmts IN FND_FLEX_SERVER1.SegFormats,
70: nquals IN NUMBER,
71: qualcols IN FND_FLEX_SERVER1.TabColArray,
72: nxcols IN NUMBER,
65: combtbl IN FND_FLEX_SERVER1.CombTblInfo,
66: nsegs IN NUMBER,
67: combcols IN FND_FLEX_SERVER1.TabColArray,
68: combtypes IN FND_FLEX_SERVER1.CharArray,
69: segfmts IN FND_FLEX_SERVER1.SegFormats,
70: nquals IN NUMBER,
71: qualcols IN FND_FLEX_SERVER1.TabColArray,
72: nxcols IN NUMBER,
73: xcolnames IN FND_FLEX_SERVER1.StringArray,
67: combcols IN FND_FLEX_SERVER1.TabColArray,
68: combtypes IN FND_FLEX_SERVER1.CharArray,
69: segfmts IN FND_FLEX_SERVER1.SegFormats,
70: nquals IN NUMBER,
71: qualcols IN FND_FLEX_SERVER1.TabColArray,
72: nxcols IN NUMBER,
73: xcolnames IN FND_FLEX_SERVER1.StringArray,
74: where_cl IN VARCHAR2,
75: ccid IN OUT nocopy NUMBER,
69: segfmts IN FND_FLEX_SERVER1.SegFormats,
70: nquals IN NUMBER,
71: qualcols IN FND_FLEX_SERVER1.TabColArray,
72: nxcols IN NUMBER,
73: xcolnames IN FND_FLEX_SERVER1.StringArray,
74: where_cl IN VARCHAR2,
75: ccid IN OUT nocopy NUMBER,
76: segids IN OUT nocopy FND_FLEX_SERVER1.ValueIdArray,
77: tblderv OUT nocopy FND_FLEX_SERVER1.DerivedVals,
72: nxcols IN NUMBER,
73: xcolnames IN FND_FLEX_SERVER1.StringArray,
74: where_cl IN VARCHAR2,
75: ccid IN OUT nocopy NUMBER,
76: segids IN OUT nocopy FND_FLEX_SERVER1.ValueIdArray,
77: tblderv OUT nocopy FND_FLEX_SERVER1.DerivedVals,
78: qualvals OUT nocopy FND_FLEX_SERVER1.ValAttribArray,
79: xcolvals OUT nocopy FND_FLEX_SERVER1.StringArray)
80: RETURN NUMBER;
73: xcolnames IN FND_FLEX_SERVER1.StringArray,
74: where_cl IN VARCHAR2,
75: ccid IN OUT nocopy NUMBER,
76: segids IN OUT nocopy FND_FLEX_SERVER1.ValueIdArray,
77: tblderv OUT nocopy FND_FLEX_SERVER1.DerivedVals,
78: qualvals OUT nocopy FND_FLEX_SERVER1.ValAttribArray,
79: xcolvals OUT nocopy FND_FLEX_SERVER1.StringArray)
80: RETURN NUMBER;
81:
74: where_cl IN VARCHAR2,
75: ccid IN OUT nocopy NUMBER,
76: segids IN OUT nocopy FND_FLEX_SERVER1.ValueIdArray,
77: tblderv OUT nocopy FND_FLEX_SERVER1.DerivedVals,
78: qualvals OUT nocopy FND_FLEX_SERVER1.ValAttribArray,
79: xcolvals OUT nocopy FND_FLEX_SERVER1.StringArray)
80: RETURN NUMBER;
81:
82:
75: ccid IN OUT nocopy NUMBER,
76: segids IN OUT nocopy FND_FLEX_SERVER1.ValueIdArray,
77: tblderv OUT nocopy FND_FLEX_SERVER1.DerivedVals,
78: qualvals OUT nocopy FND_FLEX_SERVER1.ValAttribArray,
79: xcolvals OUT nocopy FND_FLEX_SERVER1.StringArray)
80: RETURN NUMBER;
81:
82:
83: -- ----------------------------------------------------------------------
81:
82:
83: -- ----------------------------------------------------------------------
84: FUNCTION parse_displayed
85: (fstruct IN FND_FLEX_SERVER1.FlexStructId,
86: token_str IN VARCHAR2,
87: dispsegs OUT nocopy FND_FLEX_SERVER1.DisplayedSegs)
88: RETURN BOOLEAN;
89:
83: -- ----------------------------------------------------------------------
84: FUNCTION parse_displayed
85: (fstruct IN FND_FLEX_SERVER1.FlexStructId,
86: token_str IN VARCHAR2,
87: dispsegs OUT nocopy FND_FLEX_SERVER1.DisplayedSegs)
88: RETURN BOOLEAN;
89:
90: -- ----------------------------------------------------------------------
91: FUNCTION concatenate_values
89:
90: -- ----------------------------------------------------------------------
91: FUNCTION concatenate_values
92: (nvals IN NUMBER,
93: vals IN FND_FLEX_SERVER1.ValueArray,
94: displ IN FND_FLEX_SERVER1.DisplayedSegs,
95: delimiter IN VARCHAR2)
96: RETURN VARCHAR2;
97:
90: -- ----------------------------------------------------------------------
91: FUNCTION concatenate_values
92: (nvals IN NUMBER,
93: vals IN FND_FLEX_SERVER1.ValueArray,
94: displ IN FND_FLEX_SERVER1.DisplayedSegs,
95: delimiter IN VARCHAR2)
96: RETURN VARCHAR2;
97:
98: -- ----------------------------------------------------------------------
97:
98: -- ----------------------------------------------------------------------
99: FUNCTION concatenate_ids
100: (nids IN NUMBER,
101: ids IN FND_FLEX_SERVER1.ValueIdArray,
102: delimiter IN VARCHAR2)
103: RETURN VARCHAR2;
104:
105: -- ----------------------------------------------------------------------
104:
105: -- ----------------------------------------------------------------------
106: FUNCTION concatenate_descriptions
107: (ndescs IN NUMBER,
108: descs IN FND_FLEX_SERVER1.ValueDescArray,
109: displ IN FND_FLEX_SERVER1.DisplayedSegs,
110: lengths IN FND_FLEX_SERVER1.NumberArray,
111: delimiter IN VARCHAR2)
112: RETURN VARCHAR2;
105: -- ----------------------------------------------------------------------
106: FUNCTION concatenate_descriptions
107: (ndescs IN NUMBER,
108: descs IN FND_FLEX_SERVER1.ValueDescArray,
109: displ IN FND_FLEX_SERVER1.DisplayedSegs,
110: lengths IN FND_FLEX_SERVER1.NumberArray,
111: delimiter IN VARCHAR2)
112: RETURN VARCHAR2;
113:
106: FUNCTION concatenate_descriptions
107: (ndescs IN NUMBER,
108: descs IN FND_FLEX_SERVER1.ValueDescArray,
109: displ IN FND_FLEX_SERVER1.DisplayedSegs,
110: lengths IN FND_FLEX_SERVER1.NumberArray,
111: delimiter IN VARCHAR2)
112: RETURN VARCHAR2;
113:
114: -- ----------------------------------------------------------------------
480: PROCEDURE parse_flex_values
481: (p_concatenated_flex_values IN VARCHAR2,
482: p_delimiter IN VARCHAR2,
483: p_numof_flex_values IN NUMBER DEFAULT NULL,
484: x_flex_values OUT nocopy fnd_flex_server1.stringarray,
485: x_numof_flex_values OUT nocopy NUMBER);
486:
487: -- ----------------------------------------------------------------------
488: -- concatenate_flex_values:
511: -- "AB", "CD" 2 "AB.CD"
512: --
513: -- ----------------------------------------------------------------------
514: PROCEDURE concatenate_flex_values
515: (p_flex_values IN fnd_flex_server1.stringarray,
516: p_numof_flex_values IN NUMBER,
517: p_delimiter IN VARCHAR2,
518: x_concatenated_flex_values OUT nocopy VARCHAR2);
519: