[Home] [Help]
PACKAGE: APPS.IEX_COLL_IND_PUB
Source
1 PACKAGE IEX_COLL_IND_PUB AUTHID CURRENT_USER AS
2 /* $Header: iexpmtis.pls 120.1 2010/12/23 10:25:30 snuthala noship $ */
3 /*#
4 * Public API for Metric functions.
5 * @rep:scope internal
6 * @rep:product IEX
7 * @rep:displayname Public API for Metric functions
8 * @rep:lifecycle active
9 * @rep:compatibility S
10 */
11
12 /*#
13 * Function GET_CREDIT_LIMIT.
14 * @param p_party_id party_id
15 * @param p_cust_account_id account_id
16 * @param p_customer_site_use_id site_use_id
17 * @param p_org_id org_id
18 * @rep:scope internal
19 * @rep:displayname GET_CREDIT_LIMIT
20 * @rep:lifecycle active
21 * @rep:compatibility S
22 */
23
24 FUNCTION GET_CREDIT_LIMIT(p_party_id IN NUMBER,
25 p_cust_account_id IN NUMBER,
26 p_customer_site_use_id IN NUMBER,
27 p_org_id NUMBER) RETURN VARCHAR2;
28
29 /*#
30 * Function GET_WTD_DAYS_TERMS.
31 * @param p_party_id party_id
32 * @param p_cust_account_id account_id
33 * @param p_customer_site_use_id site_use_id
34 * @param p_org_id org_id
35 * @rep:scope internal
36 * @rep:displayname WTD_DAYS_TERMS
37 * @rep:lifecycle active
38 * @rep:compatibility S
39 */
40
41 FUNCTION GET_WTD_DAYS_TERMS(p_party_id IN NUMBER,
42 p_cust_account_id IN NUMBER,
43 p_customer_site_use_id IN NUMBER,
44 p_org_id NUMBER) RETURN VARCHAR2;
45
46 /*#
47 * Function GET_WTD_DAYS_LATE.
48 * @param p_party_id party_id
49 * @param p_cust_account_id account_id
50 * @param p_customer_site_use_id site_use_id
51 * @param p_org_id org_id
52 * @rep:scope internal
53 * @rep:displayname GET_WTD_DAYS_LATE
54 * @rep:lifecycle active
55 * @rep:compatibility S
56 */
57
58 FUNCTION GET_WTD_DAYS_LATE(p_party_id IN NUMBER,
59 p_cust_account_id IN NUMBER,
60 p_customer_site_use_id IN NUMBER,
61 p_org_id NUMBER) RETURN VARCHAR2;
62
63 /*#
64 * Function to get the real value of DSO.
65 * @param p_party_id party_id
66 * @param p_cust_account_id account_id
67 * @param p_customer_site_use_id customer_site_use_id
68 * @param p_org_id org_id
69 * @rep:scope internal
70 * @rep:displayname GET_TRUE_DSO
71 * @rep:lifecycle active
72 * @rep:compatibility S
73 */
74
75 FUNCTION GET_TRUE_DSO(p_party_id IN NUMBER,
76 p_cust_account_id IN NUMBER,
77 p_customer_site_use_id IN NUMBER,
78 p_org_id NUMBER) RETURN VARCHAR2;
79
80 /*#
81 * Function to be used by GET_TRUE_DSO.
82 * @param p_party_id party_id
83 * @param p_cust_account_id account_id
84 * @param p_customer_site_use_id customer_site_use_id
85 * @rep:scope internal
86 * @rep:displayname COMP_TOT_REC
87 * @rep:lifecycle active
88 * @rep:compatibility S
89 */
90
91
92 FUNCTION COMP_TOT_REC(p_start_date IN DATE,
93 p_end_date IN DATE,
94 p_party_id IN NUMBER,
95 p_cust_account_id IN NUMBER,
96 p_customer_site_use_id IN NUMBER) RETURN NUMBER;
97
98
99 /*#
100 * Procedure to get global variable values.
101 * @param p_org_id org_id
102 * @rep:scope internal
103 * @rep:displayname Get_Common
104 * @rep:lifecycle active
105 * @rep:compatibility S
106 */
107
108 Procedure Get_Common(p_org_id number);
109
110 /*#
111 * Function to get sales detailss.
112 * @param p_party_id party_id
113 * @param p_cust_account_id account_id
114 * @param p_customer_site_use_id customer_site_use_id
115 * @param p_org_id org_id
116 * @rep:scope internal
117 * @rep:displayname GET_SALES
118 * @rep:lifecycle active
119 * @rep:compatibility S
120 */
121
122 FUNCTION GET_SALES(p_party_id IN NUMBER,
123 p_cust_account_id IN NUMBER,
124 p_customer_site_use_id IN NUMBER,
125 p_org_id IN NUMBER ) RETURN VARCHAR2;
126
127 END;