1 PACKAGE fnd_flex_server2 AS
2 /* $Header: AFFFSV2S.pls 120.1.12010000.1 2008/07/25 14:14:28 appldev ship $ */
3
4
5 /* -------------------------------------------------------------------- */
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;
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
23
24 PROCEDURE submit_rxr_report(errbuf OUT nocopy VARCHAR2,
25 retcode OUT nocopy VARCHAR2,
26 p_application_id IN VARCHAR2,
27 p_id_flex_code IN VARCHAR2,
28 p_id_flex_num IN VARCHAR2,
29 p_update_flag IN VARCHAR2,
30 p_num_workers IN NUMBER,
31 p_debug_flag IN VARCHAR2);
32
33
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,
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,
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,
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 */
69 /* is room for it. */
70 /* ----------------------------------------------------------------------- */
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
80 /* ----------------------------------------------------------------------- */
81
82 END fnd_flex_server2;