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:
37: FUNCTION get_keystruct(appl_sname IN VARCHAR2,
38: flex_code IN VARCHAR2,
39: select_comb_from_view IN VARCHAR2,
40: flex_num IN NUMBER,
41: flex_struct OUT nocopy FND_FLEX_SERVER1.FlexStructId,
42: struct_info OUT nocopy FND_FLEX_SERVER1.FlexStructInfo,
43: cctbl_info OUT nocopy FND_FLEX_SERVER1.CombTblInfo)
44: RETURN BOOLEAN;
45: FUNCTION get_descstruct(flex_app_sname IN VARCHAR2,
38: flex_code IN VARCHAR2,
39: select_comb_from_view IN VARCHAR2,
40: flex_num IN NUMBER,
41: flex_struct OUT nocopy FND_FLEX_SERVER1.FlexStructId,
42: struct_info OUT nocopy FND_FLEX_SERVER1.FlexStructInfo,
43: cctbl_info OUT nocopy FND_FLEX_SERVER1.CombTblInfo)
44: RETURN BOOLEAN;
45: FUNCTION get_descstruct(flex_app_sname IN VARCHAR2,
46: desc_flex_name IN VARCHAR2,
39: select_comb_from_view IN VARCHAR2,
40: flex_num IN NUMBER,
41: flex_struct OUT nocopy FND_FLEX_SERVER1.FlexStructId,
42: struct_info OUT nocopy FND_FLEX_SERVER1.FlexStructInfo,
43: cctbl_info OUT nocopy FND_FLEX_SERVER1.CombTblInfo)
44: RETURN BOOLEAN;
45: FUNCTION get_descstruct(flex_app_sname IN VARCHAR2,
46: desc_flex_name IN VARCHAR2,
47: dfinfo OUT nocopy FND_FLEX_SERVER1.DescFlexInfo)
43: cctbl_info OUT nocopy FND_FLEX_SERVER1.CombTblInfo)
44: RETURN BOOLEAN;
45: FUNCTION get_descstruct(flex_app_sname IN VARCHAR2,
46: desc_flex_name IN VARCHAR2,
47: dfinfo OUT nocopy FND_FLEX_SERVER1.DescFlexInfo)
48: RETURN BOOLEAN;
49:
50: FUNCTION get_struct_cols(fstruct IN FND_FLEX_SERVER1.FlexStructId,
51: table_apid IN NUMBER,
46: desc_flex_name IN VARCHAR2,
47: dfinfo OUT nocopy FND_FLEX_SERVER1.DescFlexInfo)
48: RETURN BOOLEAN;
49:
50: FUNCTION get_struct_cols(fstruct IN FND_FLEX_SERVER1.FlexStructId,
51: table_apid IN NUMBER,
52: table_id IN NUMBER,
53: n_columns OUT nocopy NUMBER,
54: cols OUT nocopy FND_FLEX_SERVER1.TabColArray,
50: FUNCTION get_struct_cols(fstruct IN FND_FLEX_SERVER1.FlexStructId,
51: table_apid IN NUMBER,
52: table_id IN NUMBER,
53: n_columns OUT nocopy NUMBER,
54: cols OUT nocopy FND_FLEX_SERVER1.TabColArray,
55: coltypes OUT nocopy FND_FLEX_SERVER1.CharArray,
56: seg_formats OUT nocopy FND_FLEX_SERVER1.SegFormats)
57: RETURN BOOLEAN;
58:
51: table_apid IN NUMBER,
52: table_id IN NUMBER,
53: n_columns OUT nocopy NUMBER,
54: cols OUT nocopy FND_FLEX_SERVER1.TabColArray,
55: coltypes OUT nocopy FND_FLEX_SERVER1.CharArray,
56: seg_formats OUT nocopy FND_FLEX_SERVER1.SegFormats)
57: RETURN BOOLEAN;
58:
59: FUNCTION get_all_segquals(fstruct IN FND_FLEX_SERVER1.FlexStructId,
52: table_id IN NUMBER,
53: n_columns OUT nocopy NUMBER,
54: cols OUT nocopy FND_FLEX_SERVER1.TabColArray,
55: coltypes OUT nocopy FND_FLEX_SERVER1.CharArray,
56: seg_formats OUT nocopy FND_FLEX_SERVER1.SegFormats)
57: RETURN BOOLEAN;
58:
59: FUNCTION get_all_segquals(fstruct IN FND_FLEX_SERVER1.FlexStructId,
60: seg_quals OUT nocopy FND_FLEX_SERVER1.Qualifiers)
55: coltypes OUT nocopy FND_FLEX_SERVER1.CharArray,
56: seg_formats OUT nocopy FND_FLEX_SERVER1.SegFormats)
57: RETURN BOOLEAN;
58:
59: FUNCTION get_all_segquals(fstruct IN FND_FLEX_SERVER1.FlexStructId,
60: seg_quals OUT nocopy FND_FLEX_SERVER1.Qualifiers)
61: RETURN BOOLEAN;
62:
63: FUNCTION get_qualsegs(fstruct IN FND_FLEX_SERVER1.FlexStructId,
56: seg_formats OUT nocopy FND_FLEX_SERVER1.SegFormats)
57: RETURN BOOLEAN;
58:
59: FUNCTION get_all_segquals(fstruct IN FND_FLEX_SERVER1.FlexStructId,
60: seg_quals OUT nocopy FND_FLEX_SERVER1.Qualifiers)
61: RETURN BOOLEAN;
62:
63: FUNCTION get_qualsegs(fstruct IN FND_FLEX_SERVER1.FlexStructId,
64: nsegs OUT nocopy NUMBER,
59: FUNCTION get_all_segquals(fstruct IN FND_FLEX_SERVER1.FlexStructId,
60: seg_quals OUT nocopy FND_FLEX_SERVER1.Qualifiers)
61: RETURN BOOLEAN;
62:
63: FUNCTION get_qualsegs(fstruct IN FND_FLEX_SERVER1.FlexStructId,
64: nsegs OUT nocopy NUMBER,
65: segdisp OUT nocopy FND_FLEX_SERVER1.CharArray,
66: segrqd OUT nocopy FND_FLEX_SERVER1.CharArray,
67: fqtab OUT nocopy FND_FLEX_SERVER1.FlexQualTable)
61: RETURN BOOLEAN;
62:
63: FUNCTION get_qualsegs(fstruct IN FND_FLEX_SERVER1.FlexStructId,
64: nsegs OUT nocopy NUMBER,
65: segdisp OUT nocopy FND_FLEX_SERVER1.CharArray,
66: segrqd OUT nocopy FND_FLEX_SERVER1.CharArray,
67: fqtab OUT nocopy FND_FLEX_SERVER1.FlexQualTable)
68: RETURN BOOLEAN;
69:
62:
63: FUNCTION get_qualsegs(fstruct IN FND_FLEX_SERVER1.FlexStructId,
64: nsegs OUT nocopy NUMBER,
65: segdisp OUT nocopy FND_FLEX_SERVER1.CharArray,
66: segrqd OUT nocopy FND_FLEX_SERVER1.CharArray,
67: fqtab OUT nocopy FND_FLEX_SERVER1.FlexQualTable)
68: RETURN BOOLEAN;
69:
70: /* ----------------------------------------------------------------------- */
63: FUNCTION get_qualsegs(fstruct IN FND_FLEX_SERVER1.FlexStructId,
64: nsegs OUT nocopy NUMBER,
65: segdisp OUT nocopy FND_FLEX_SERVER1.CharArray,
66: segrqd OUT nocopy FND_FLEX_SERVER1.CharArray,
67: fqtab OUT nocopy FND_FLEX_SERVER1.FlexQualTable)
68: RETURN BOOLEAN;
69:
70: /* ----------------------------------------------------------------------- */
71: /* This should be moved back to key validation engine when there */
74:
75: FUNCTION breakup_catsegs(catsegs IN VARCHAR2,
76: delim IN VARCHAR2,
77: vals_not_ids IN BOOLEAN,
78: displayed_segs IN FND_FLEX_SERVER1.DisplayedSegs,
79: nsegs_out OUT nocopy NUMBER,
80: segs_out IN OUT nocopy FND_FLEX_SERVER1.StringArray)
81: RETURN BOOLEAN;
82:
76: delim IN VARCHAR2,
77: vals_not_ids IN BOOLEAN,
78: displayed_segs IN FND_FLEX_SERVER1.DisplayedSegs,
79: nsegs_out OUT nocopy NUMBER,
80: segs_out IN OUT nocopy FND_FLEX_SERVER1.StringArray)
81: RETURN BOOLEAN;
82:
83: /* ----------------------------------------------------------------------- */
84: