DBA Data[Home] [Help]

PACKAGE: APPS.AR_IDEP_UTILS

Source


1 PACKAGE AR_IDEP_UTILS  AUTHID CURRENT_USER AS
2 /* $Header: ARDEPUTS.pls 120.3 2005/08/12 13:01:11 rsinthre noship $ */
3 
4 
5 
6 /*========================================================================
7  | PUBLIC function get_course_description
8  |
9  | DESCRIPTION
10  |      function which returns the description of a course which is an item in
11  |      an invoice against a deposit.
12  |      Wrapper function on OTA_UTILITY.GET_DESCRIPTION
13  |
14  | PSEUDO CODE/LOGIC
15  |
16  | PARAMETERS
17  |   pn_deposit_id   Deposit Identifier
18  |
19  | RETURNS
20  |   Original owners email address
21  |
22  | KNOWN ISSUES
23  |
24  | NOTES
25  |
26  | MODIFICATION HISTORY
27  | Date                  Author                 Description of Changes
28  | 20-Jun-2001           Krishnakumar Menon      Created
29  *=======================================================================*/
30 
31 FUNCTION get_course_description(pn_line_id   IN  Number,
32                                 pv_uom       IN  Varchar2) RETURN VARCHAR2;
33 
34 
35 /*========================================================================
36  | PUBLIC function get_reserved_commitment_amt
37  |
38  | DESCRIPTION
39  |      function which returns the reserved amount for a given commitment/deposit.
40  |
41  | PSEUDO CODE/LOGIC
42  |
43  | PARAMETERS
44  |   p_customer_trx_id      The deposit identifier
45  |
46  | RETURNS
47  |   The reserved amount
48  |
49  | KNOWN ISSUES
50  |
51  | NOTES
52  |
53  | MODIFICATION HISTORY
54  | Date                  Author                 Description of Changes
55  | 13-Dec-2001           Krishnakumar Menon      Created
56  *=======================================================================*/
57 FUNCTION get_reserved_commitment_amt (p_customer_trx_id in NUMBER) RETURN NUMBER;
58 
59 
60 
61 /*========================================================================
62  | PUBLIC function get_applied_commitment_amt
63  |
64  | DESCRIPTION
65  |      function which returns the applied amount for a given commitment/deposit.
66  |
67  | PSEUDO CODE/LOGIC
68  |
69  | PARAMETERS
70  |   p_customer_trx_id      The deposit identifier
71  |
72  | RETURNS
73  |   The applied amount
74  |
75  | KNOWN ISSUES
76  |
77  | NOTES
78  |
79  | MODIFICATION HISTORY
80  | Date                  Author       Description of Changes
81  | 02-May-2002           krmenon      Created
82  *=======================================================================*/
83 FUNCTION get_applied_commitment_amt (p_customer_trx_id in NUMBER) RETURN NUMBER;
84 
85 END AR_IDEP_UTILS;