[Home] [Help]
PACKAGE: APPS.ARH_DQM_TREE
Source
1 PACKAGE arh_dqm_tree AUTHID CURRENT_USER AS
2 /*$Header: ARHDQMTS.pls 115.0 2002/03/28 11:27:13 pkm ship $*/
3
4 TYPE dsprec IS RECORD
5 ( state NUMBER,
6 depth NUMBER,
7 label VARCHAR2(2000),
8 icon VARCHAR2(30),
9 ndata VARCHAR2(2000));
10
11 TYPE dsplist IS TABLE OF dsprec INDEX BY BINARY_INTEGER;
12
13 erase_list dsplist;
14
15
16 FUNCTION AddList
17 ( p_dsplist1 dsplist,
18 p_dsplist2 dsplist)
19 RETURN dsplist;
20
21 FUNCTION dsplist_for_parties
22 (p_ctx_id IN NUMBER,
23 p_status IN VARCHAR2 DEFAULT 'ALL',
24 p_disp_percent IN VARCHAR2 DEFAULT 'Y')
25 RETURN dsplist;
26
27 FUNCTION Add_site_party
28 (p_ctx_id IN NUMBER,
29 p_party_id IN NUMBER,
30 p_status IN VARCHAR2 DEFAULT 'ALL',
31 p_dsprec IN dsprec)
32 RETURN dsplist;
33
34 FUNCTION Add_Contact_party
35 (p_ctx_id IN NUMBER,
36 p_party_id IN NUMBER,
37 p_status IN VARCHAR2 DEFAULT 'ALL',
38 p_dsprec IN dsprec)
39 RETURN dsplist;
40
41 FUNCTION Add_Ctp_to_Party_Site
42 (p_ctx_id IN NUMBER,
43 p_party_id IN NUMBER,
44 p_party_site_id IN NUMBER,
45 p_status IN VARCHAR2 DEFAULT 'ALL',
46 p_dsprec IN dsprec)
47 RETURN dsplist;
48
49 FUNCTION Add_Contact_to_site
50 ( p_ctx_id NUMBER,
51 p_party_id NUMBER,
52 p_party_site_id NUMBER,
53 p_status IN VARCHAR2 DEFAULT 'ALL',
54 p_dsprec dsprec)
55 RETURN dsplist;
56
57 FUNCTION Add_Ctp_to_Party
58 (p_ctx_id IN NUMBER,
59 p_party_id IN NUMBER,
60 p_rel_pty_id IN NUMBER DEFAULT NULL,
61 p_status IN VARCHAR2 DEFAULT 'ALL',
62 p_dsprec IN dsprec)
63 RETURN dsplist;
64
65
66 ----------040202
67
68 FUNCTION dsp_for_party_pty_accts
69 (p_ctx_id IN NUMBER,
70 p_cur_all IN VARCHAR2 DEFAULT 'ALL',
71 p_status IN VARCHAR2 DEFAULT 'ALL',
72 p_disp_percent IN VARCHAR2 DEFAULT 'Y')
73 RETURN dsplist;
74
75 FUNCTION dsp_for_party_accts
76 (p_ctx_id IN NUMBER,
77 p_cur_all IN VARCHAR2 DEFAULT 'ALL',
78 p_status IN VARCHAR2 DEFAULT 'ALL',
79 p_disp_percent IN VARCHAR2 DEFAULT 'Y')
80 RETURN dsplist;
81
82 FUNCTION add_acct_party
83 (p_ctx_id IN NUMBER,
84 p_party_id IN NUMBER,
85 p_cur_all IN VARCHAR2 DEFAULT 'ALL',
86 p_status IN VARCHAR2 DEFAULT 'ALL',
87 p_dsprec IN dsprec)
88 RETURN dsplist;
89
90
91 FUNCTION Add_site_acct
92 (p_ctx_id IN NUMBER,
93 p_party_id IN NUMBER,
94 p_cust_acct_id IN NUMBER,
95 p_cur_all IN VARCHAR2 DEFAULT 'ALL',
96 p_status IN VARCHAR2 DEFAULT 'ALL',
97 p_dsprec IN dsprec)
98 RETURN dsplist;
99
100
101 FUNCTION Add_Contact_Acct
102 (p_ctx_id IN NUMBER,
103 p_party_id IN NUMBER,
104 p_cust_acct_id IN NUMBER,
105 p_status IN VARCHAR2 DEFAULT 'ALL',
106 p_dsprec IN dsprec)
107 RETURN dsplist;
108
109 /*
110 FUNCTION Add_Contact_to_acct_site
111 ( p_ctx_id IN NUMBER,
112 p_party_id IN NUMBER,
113 p_party_site_id IN NUMBER,
114 p_cust_acct_id IN NUMBER,
115 p_acct_site_id IN NUMBER,
116 p_status IN VARCHAR2 DEFAULT 'ALL',
117 p_dsprec IN dsprec)
118 RETURN dsplist;
119 */
120
121 FUNCTION Add_Contact_to_acct_site
122 ( p_ctx_id IN NUMBER,
123 p_party_id IN NUMBER,
124 p_cust_acct_id IN NUMBER,
125 p_acct_site_id IN NUMBER,
126 p_cur_all IN VARCHAR2,
127 p_status IN VARCHAR2 DEFAULT 'ALL',
128 p_dsprec IN dsprec)
129 RETURN dsplist;
130
131 END;