6: /* Private definitions */
7: /* -------------------------------------------------------------------- */
8:
9: FUNCTION cross_validate(nsegs IN NUMBER,
10: segs IN FND_FLEX_SERVER1.ValueArray,
11: segfmt IN FND_FLEX_SERVER1.SegFormats,
12: vdt IN DATE,
13: fstruct IN FND_FLEX_SERVER1.FlexStructId,
14: errcol OUT nocopy VARCHAR2) RETURN NUMBER;
7: /* -------------------------------------------------------------------- */
8:
9: FUNCTION cross_validate(nsegs IN NUMBER,
10: segs IN FND_FLEX_SERVER1.ValueArray,
11: segfmt IN FND_FLEX_SERVER1.SegFormats,
12: vdt IN DATE,
13: fstruct IN FND_FLEX_SERVER1.FlexStructId,
14: errcol OUT nocopy VARCHAR2) RETURN NUMBER;
15:
9: FUNCTION cross_validate(nsegs IN NUMBER,
10: segs IN FND_FLEX_SERVER1.ValueArray,
11: segfmt IN FND_FLEX_SERVER1.SegFormats,
12: vdt IN DATE,
13: fstruct IN FND_FLEX_SERVER1.FlexStructId,
14: errcol OUT nocopy VARCHAR2) RETURN NUMBER;
15:
16: FUNCTION x_drop_cached_cv_result(fstruct IN FND_FLEX_SERVER1.FlexStructId,
17: n_segs IN NUMBER,
12: vdt IN DATE,
13: fstruct IN FND_FLEX_SERVER1.FlexStructId,
14: errcol OUT nocopy VARCHAR2) RETURN NUMBER;
15:
16: FUNCTION x_drop_cached_cv_result(fstruct IN FND_FLEX_SERVER1.FlexStructId,
17: n_segs IN NUMBER,
18: segs IN FND_FLEX_SERVER1.ValueArray)
19: RETURN BOOLEAN;
20:
14: errcol OUT nocopy VARCHAR2) RETURN NUMBER;
15:
16: FUNCTION x_drop_cached_cv_result(fstruct IN FND_FLEX_SERVER1.FlexStructId,
17: n_segs IN NUMBER,
18: segs IN FND_FLEX_SERVER1.ValueArray)
19: RETURN BOOLEAN;
20:
21: PROCEDURE x_clear_cv_cache;
22:
34: FUNCTION get_keystruct(appl_sname IN VARCHAR2,
35: flex_code IN VARCHAR2,
36: select_comb_from_view IN VARCHAR2,
37: flex_num IN NUMBER,
38: flex_struct OUT nocopy FND_FLEX_SERVER1.FlexStructId,
39: struct_info OUT nocopy FND_FLEX_SERVER1.FlexStructInfo,
40: cctbl_info OUT nocopy FND_FLEX_SERVER1.CombTblInfo)
41: RETURN BOOLEAN;
42: FUNCTION get_descstruct(flex_app_sname IN VARCHAR2,
35: flex_code IN VARCHAR2,
36: select_comb_from_view IN VARCHAR2,
37: flex_num IN NUMBER,
38: flex_struct OUT nocopy FND_FLEX_SERVER1.FlexStructId,
39: struct_info OUT nocopy FND_FLEX_SERVER1.FlexStructInfo,
40: cctbl_info OUT nocopy FND_FLEX_SERVER1.CombTblInfo)
41: RETURN BOOLEAN;
42: FUNCTION get_descstruct(flex_app_sname IN VARCHAR2,
43: desc_flex_name IN VARCHAR2,
36: select_comb_from_view IN VARCHAR2,
37: flex_num IN NUMBER,
38: flex_struct OUT nocopy FND_FLEX_SERVER1.FlexStructId,
39: struct_info OUT nocopy FND_FLEX_SERVER1.FlexStructInfo,
40: cctbl_info OUT nocopy FND_FLEX_SERVER1.CombTblInfo)
41: RETURN BOOLEAN;
42: FUNCTION get_descstruct(flex_app_sname IN VARCHAR2,
43: desc_flex_name IN VARCHAR2,
44: dfinfo OUT nocopy FND_FLEX_SERVER1.DescFlexInfo)
40: cctbl_info OUT nocopy FND_FLEX_SERVER1.CombTblInfo)
41: RETURN BOOLEAN;
42: FUNCTION get_descstruct(flex_app_sname IN VARCHAR2,
43: desc_flex_name IN VARCHAR2,
44: dfinfo OUT nocopy FND_FLEX_SERVER1.DescFlexInfo)
45: RETURN BOOLEAN;
46:
47: FUNCTION get_struct_cols(fstruct IN FND_FLEX_SERVER1.FlexStructId,
48: table_apid IN NUMBER,
43: desc_flex_name IN VARCHAR2,
44: dfinfo OUT nocopy FND_FLEX_SERVER1.DescFlexInfo)
45: RETURN BOOLEAN;
46:
47: FUNCTION get_struct_cols(fstruct IN FND_FLEX_SERVER1.FlexStructId,
48: table_apid IN NUMBER,
49: table_id IN NUMBER,
50: n_columns OUT nocopy NUMBER,
51: cols OUT nocopy FND_FLEX_SERVER1.TabColArray,
47: FUNCTION get_struct_cols(fstruct IN FND_FLEX_SERVER1.FlexStructId,
48: table_apid IN NUMBER,
49: table_id IN NUMBER,
50: n_columns OUT nocopy NUMBER,
51: cols OUT nocopy FND_FLEX_SERVER1.TabColArray,
52: coltypes OUT nocopy FND_FLEX_SERVER1.CharArray,
53: seg_formats OUT nocopy FND_FLEX_SERVER1.SegFormats)
54: RETURN BOOLEAN;
55:
48: table_apid IN NUMBER,
49: table_id IN NUMBER,
50: n_columns OUT nocopy NUMBER,
51: cols OUT nocopy FND_FLEX_SERVER1.TabColArray,
52: coltypes OUT nocopy FND_FLEX_SERVER1.CharArray,
53: seg_formats OUT nocopy FND_FLEX_SERVER1.SegFormats)
54: RETURN BOOLEAN;
55:
56: FUNCTION get_all_segquals(fstruct IN FND_FLEX_SERVER1.FlexStructId,
49: table_id IN NUMBER,
50: n_columns OUT nocopy NUMBER,
51: cols OUT nocopy FND_FLEX_SERVER1.TabColArray,
52: coltypes OUT nocopy FND_FLEX_SERVER1.CharArray,
53: seg_formats OUT nocopy FND_FLEX_SERVER1.SegFormats)
54: RETURN BOOLEAN;
55:
56: FUNCTION get_all_segquals(fstruct IN FND_FLEX_SERVER1.FlexStructId,
57: seg_quals OUT nocopy FND_FLEX_SERVER1.Qualifiers)
52: coltypes OUT nocopy FND_FLEX_SERVER1.CharArray,
53: seg_formats OUT nocopy FND_FLEX_SERVER1.SegFormats)
54: RETURN BOOLEAN;
55:
56: FUNCTION get_all_segquals(fstruct IN FND_FLEX_SERVER1.FlexStructId,
57: seg_quals OUT nocopy FND_FLEX_SERVER1.Qualifiers)
58: RETURN BOOLEAN;
59:
60: FUNCTION get_qualsegs(fstruct IN FND_FLEX_SERVER1.FlexStructId,
53: seg_formats OUT nocopy FND_FLEX_SERVER1.SegFormats)
54: RETURN BOOLEAN;
55:
56: FUNCTION get_all_segquals(fstruct IN FND_FLEX_SERVER1.FlexStructId,
57: seg_quals OUT nocopy FND_FLEX_SERVER1.Qualifiers)
58: RETURN BOOLEAN;
59:
60: FUNCTION get_qualsegs(fstruct IN FND_FLEX_SERVER1.FlexStructId,
61: nsegs OUT nocopy NUMBER,
56: FUNCTION get_all_segquals(fstruct IN FND_FLEX_SERVER1.FlexStructId,
57: seg_quals OUT nocopy FND_FLEX_SERVER1.Qualifiers)
58: RETURN BOOLEAN;
59:
60: FUNCTION get_qualsegs(fstruct IN FND_FLEX_SERVER1.FlexStructId,
61: nsegs OUT nocopy NUMBER,
62: segdisp OUT nocopy FND_FLEX_SERVER1.CharArray,
63: segrqd OUT nocopy FND_FLEX_SERVER1.CharArray,
64: fqtab OUT nocopy FND_FLEX_SERVER1.FlexQualTable)
58: RETURN BOOLEAN;
59:
60: FUNCTION get_qualsegs(fstruct IN FND_FLEX_SERVER1.FlexStructId,
61: nsegs OUT nocopy NUMBER,
62: segdisp OUT nocopy FND_FLEX_SERVER1.CharArray,
63: segrqd OUT nocopy FND_FLEX_SERVER1.CharArray,
64: fqtab OUT nocopy FND_FLEX_SERVER1.FlexQualTable)
65: RETURN BOOLEAN;
66:
59:
60: FUNCTION get_qualsegs(fstruct IN FND_FLEX_SERVER1.FlexStructId,
61: nsegs OUT nocopy NUMBER,
62: segdisp OUT nocopy FND_FLEX_SERVER1.CharArray,
63: segrqd OUT nocopy FND_FLEX_SERVER1.CharArray,
64: fqtab OUT nocopy FND_FLEX_SERVER1.FlexQualTable)
65: RETURN BOOLEAN;
66:
67: /* ----------------------------------------------------------------------- */
60: FUNCTION get_qualsegs(fstruct IN FND_FLEX_SERVER1.FlexStructId,
61: nsegs OUT nocopy NUMBER,
62: segdisp OUT nocopy FND_FLEX_SERVER1.CharArray,
63: segrqd OUT nocopy FND_FLEX_SERVER1.CharArray,
64: fqtab OUT nocopy FND_FLEX_SERVER1.FlexQualTable)
65: RETURN BOOLEAN;
66:
67: /* ----------------------------------------------------------------------- */
68: /* This should be moved back to key validation engine when there */
71:
72: FUNCTION breakup_catsegs(catsegs IN VARCHAR2,
73: delim IN VARCHAR2,
74: vals_not_ids IN BOOLEAN,
75: displayed_segs IN FND_FLEX_SERVER1.DisplayedSegs,
76: nsegs_out OUT nocopy NUMBER,
77: segs_out IN OUT nocopy FND_FLEX_SERVER1.StringArray)
78: RETURN BOOLEAN;
79:
73: delim IN VARCHAR2,
74: vals_not_ids IN BOOLEAN,
75: displayed_segs IN FND_FLEX_SERVER1.DisplayedSegs,
76: nsegs_out OUT nocopy NUMBER,
77: segs_out IN OUT nocopy FND_FLEX_SERVER1.StringArray)
78: RETURN BOOLEAN;
79:
80: /* ----------------------------------------------------------------------- */
81: