1 PACKAGE fnd_flex_server2 AUTHID CURRENT_USER AS
2 /* $Header: AFFFSV2S.pls 120.1.12010000.2 2010/02/25 09:41:48 nareshku 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 p_enddate_flag IN VARCHAR2 DEFAULT NULL,
33 p_cvr_name_low IN VARCHAR2 DEFAULT NULL,
34 p_cvr_name_high IN VARCHAR2 DEFAULT NULL);
35
36
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,
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,
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,
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 */
72 /* is room for it. */
73 /* ----------------------------------------------------------------------- */
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
83 /* ----------------------------------------------------------------------- */
84
85 END fnd_flex_server2;