[Home] [Help]
PACKAGE: APPS.ARP_CTL_PKG
Source
1 PACKAGE ARP_CTL_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARTICTLS.pls 120.6 2005/08/18 15:22:43 jbeckett ship $ */
3
4 PROCEDURE set_to_dummy( p_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype);
5
6
7 PROCEDURE fetch_p( p_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype,
8 p_customer_trx_line_id IN
9 ra_customer_trx_lines.customer_trx_line_id%type );
10
11 PROCEDURE lock_p( p_customer_trx_line_id IN
12 ra_customer_trx_lines.customer_trx_line_id%type );
13
14
15 PROCEDURE lock_f_ct_id( p_customer_trx_id IN
16 ra_customer_trx.customer_trx_id%type );
17
18 PROCEDURE lock_fetch_p( p_line_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,
19 p_customer_trx_line_id IN
20 ra_customer_trx_lines.customer_trx_line_id%type );
21
22 PROCEDURE lock_compare_p( p_line_rec IN ra_customer_trx_lines%rowtype,
23 p_customer_trx_line_id IN
24 ra_customer_trx_lines.customer_trx_line_id%type,
25 p_ignore_who_flag BOOLEAN DEFAULT FALSE );
26
27 procedure delete_p( p_customer_trx_line_id IN
28 ra_customer_trx_lines.customer_trx_line_id%type);
29
30 procedure delete_f_ct_id( p_customer_trx_id IN
31 ra_customer_trx.customer_trx_id%type);
32
33 procedure delete_f_ltctl_id( p_link_to_cust_trx_line_id IN
34 ra_customer_trx_lines.link_to_cust_trx_line_id%type);
35
36 procedure delete_f_ct_ltctl_id_type(
37 p_customer_trx_id IN
38 ra_customer_trx.customer_trx_id%type,
39 p_link_to_cust_trx_line_id IN
40 ra_customer_trx_lines.link_to_cust_trx_line_id%type,
41 p_line_type IN
42 ra_customer_trx_lines.line_type%type DEFAULT NULL);
43
44 PROCEDURE update_p( p_line_rec IN ra_customer_trx_lines%rowtype,
45 p_customer_trx_line_id IN
46 ra_customer_trx_lines.customer_trx_line_id%type,
47 p_currency_code IN fnd_currencies.currency_code%type
48 DEFAULT NULL );
49
50 PROCEDURE update_f_ct_id( p_line_rec IN ra_customer_trx_lines%rowtype,
51 p_customer_trx_id IN
52 ra_customer_trx_lines.customer_trx_id%type,
53 p_line_type IN
54 ra_customer_trx_lines.line_type%type default null,
55 p_currency_code IN fnd_currencies.currency_code%type
56 DEFAULT NULL);
57
58 PROCEDURE update_amount_f_ctl_id(
59 p_customer_trx_line_id IN Number,
60 p_inclusive_amt IN Number,
61 p_new_extended_amt OUT NOCOPY Number,
62 p_new_unit_selling_price OUT NOCOPY Number,
63 p_precision IN Number,
64 p_min_acct_unit IN Number);
65
66 PROCEDURE update_cm_amount_f_ctl_id(
67 p_customer_trx_line_id IN Number,
68 p_inclusive_amount IN Number,
69 p_new_gross_extended_amount OUT NOCOPY Number,
70 p_new_gross_unit_selling_price OUT NOCOPY Number,
71 p_precision IN Number,
72 p_min_acct_unit IN Number);
73
74
75 PROCEDURE insert_p(
76 p_line_rec IN ra_customer_trx_lines%rowtype,
77 p_customer_trx_line_id OUT NOCOPY
78 ra_customer_trx_lines.customer_trx_line_id%type
79 );
80
81 PROCEDURE display_line_p(
82 p_customer_trx_line_id IN
83 ra_customer_trx_lines.customer_trx_line_id%type
84 );
85
86 PROCEDURE display_line_rec(
87 p_line_rec IN ra_customer_trx_lines%rowtype
88 );
89
90 PROCEDURE display_line_f_lctl_id( p_link_to_cust_trx_line_id IN
91 ra_customer_trx_lines.link_to_cust_trx_line_id%type);
92
93 PROCEDURE display_line_f_ct_id( p_customer_trx_id IN
94 ra_customer_trx.customer_trx_id%type );
95
96 PROCEDURE merge_line_recs(
97 p_old_line_rec IN ra_customer_trx_lines%rowtype,
98 p_new_line_rec IN
99 ra_customer_trx_lines%rowtype,
100 p_out_line_rec IN OUT NOCOPY
101 ra_customer_trx_lines%rowtype);
102
103 PROCEDURE insert_line_f_cm_ct_ctl_id(
104 p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
105 p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
106 p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
107 p_line_type IN ra_customer_trx_lines.line_type%type,
108 p_line_percent IN number,
109 p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
110 p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
111 p_currency_code IN fnd_currencies.currency_code%type,
112 p_tax_amount IN ra_customer_trx_lines.extended_amount%type DEFAULT NULL);
113
114 PROCEDURE update_line_f_cm_ctl_id(
115 p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
116 p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
117 p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
118 p_line_type IN ra_customer_trx_lines.line_type%type,
119 p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
120 p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
121 p_currency_code IN fnd_currencies.currency_code%type);
122
123 FUNCTION get_text_dummy(p_null IN NUMBER DEFAULT null) RETURN varchar2;
124
125 FUNCTION get_number_dummy(p_null IN NUMBER DEFAULT null) RETURN number;
126
127 END ARP_CTL_PKG;