[Home] [Help]
PACKAGE: APPS.ARP_PROCESS_HEADER
Source
1 PACKAGE ARP_PROCESS_HEADER AS
2 /* $Header: ARTEHEAS.pls 120.5.12010000.1 2008/07/24 16:56:07 appldev ship $ */
3
4 PROCEDURE insert_header(
5 p_form_name IN varchar2,
6 p_form_version IN number,
7 p_trx_rec IN ra_customer_trx%rowtype,
8 p_trx_class IN ra_cust_trx_types.type%type,
9 p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
10 p_term_in_use_flag IN varchar2,
11 p_commitment_rec IN arp_process_commitment.commitment_rec_type,
12 p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
13 p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
14 p_customer_trx_line_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
15 p_row_id OUT NOCOPY rowid,
16 p_status OUT NOCOPY varchar2,
17 p_receivable_ccid IN gl_code_combinations.code_combination_id%type
18 DEFAULT NULL,
19 p_run_autoacc_flag IN varchar2 DEFAULT 'Y',
20 p_create_default_sc_flag IN varchar2 DEFAULT 'Y' );
21
22 PROCEDURE update_header(
23 p_form_name IN varchar2,
24 p_form_version IN number,
25 p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
26 p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
27 p_trx_amount IN number,
28 p_trx_class IN ra_cust_trx_types.type%type,
29 p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
30 p_initial_customer_trx_line_id IN
31 ra_customer_trx_lines.initial_customer_trx_line_id%type
32 default null,
33 p_commitment_rec IN arp_process_commitment.commitment_rec_type,
34 p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,
35 p_term_in_use_flag IN varchar2,
36 p_recalc_tax_flag IN boolean,
37 p_rerun_autoacc_flag IN boolean,
38 p_ps_dispute_amount IN NUMBER DEFAULT NULL,
39 p_ps_dispute_date IN DATE DEFAULT NULL,
40 p_status OUT NOCOPY varchar2);
41
42 PROCEDURE delete_header(
43 p_form_name IN varchar2,
44 p_form_version IN number,
45 p_customer_trx_id IN number,
46 p_trx_class IN varchar2,
47 p_status OUT NOCOPY varchar2 );
48
49
50 PROCEDURE post_commit( p_form_name IN varchar2,
51 p_form_version IN number,
52 p_customer_trx_id IN
53 ra_customer_trx.customer_trx_id%type,
54 p_previous_customer_trx_id IN
55 ra_customer_trx.previous_customer_trx_id%type,
56 p_complete_flag IN
57 ra_customer_trx.complete_flag%type,
58 p_trx_open_receivables_flag IN
59 ra_cust_trx_types.accounting_affect_flag%type,
60 p_prev_open_receivables_flag IN
61 ra_cust_trx_types.accounting_affect_flag%type,
62 p_creation_sign IN
63 ra_cust_trx_types.creation_sign%type,
64 p_allow_overapplication_flag IN
65 ra_cust_trx_types.allow_overapplication_flag%type,
66 p_natural_application_flag IN
67 ra_cust_trx_types.natural_application_only_flag%type,
68 p_cash_receipt_id IN
69 ar_cash_receipts.cash_receipt_id%type DEFAULT NULL
70 );
71
72 PROCEDURE update_header_freight_cover(
73 p_form_name IN varchar2,
74 p_form_version IN number,
75 p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
76 p_trx_class IN ra_cust_trx_types.type%type,
77 p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,
78 p_ship_via IN ra_customer_trx.ship_via%type,
79 p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
80 p_waybill_number IN ra_customer_trx.waybill_number%type,
81 p_fob_point IN ra_customer_trx.fob_point%type,
82 p_status OUT NOCOPY varchar2);
83
84
85 PROCEDURE post_query(
86 p_ct_rowid IN varchar2,
87 p_customer_trx_id IN NUMBER,
88 p_initial_customer_trx_id IN NUMBER,
89 p_previous_customer_trx_id IN NUMBER,
90 p_class IN varchar2,
91 p_ct_commitment_trx_date OUT NOCOPY date,
92 p_ct_commitment_number OUT NOCOPY varchar2,
93 p_gd_commitment_gl_date OUT NOCOPY date,
94 p_ctl_commit_cust_trx_line_id OUT NOCOPY number,
95 p_ctl_commitment_amount OUT NOCOPY number,
96 p_ctl_commitment_text OUT NOCOPY varchar2,
97 p_ctl_commitment_inv_item_id OUT NOCOPY number,
98 p_interface_line_context OUT NOCOPY varchar2,
99 p_interface_line_attribute1 OUT NOCOPY varchar2,
100 p_interface_line_attribute2 OUT NOCOPY varchar2,
101 p_interface_line_attribute3 OUT NOCOPY varchar2,
102 p_interface_line_attribute4 OUT NOCOPY varchar2,
103 p_interface_line_attribute5 OUT NOCOPY varchar2,
104 p_interface_line_attribute6 OUT NOCOPY varchar2,
105 p_interface_line_attribute7 OUT NOCOPY varchar2,
106 p_interface_line_attribute8 OUT NOCOPY varchar2,
107 p_interface_line_attribute9 OUT NOCOPY varchar2,
108 p_interface_line_attribute10 OUT NOCOPY varchar2,
109 p_interface_line_attribute11 OUT NOCOPY varchar2,
110 p_interface_line_attribute12 OUT NOCOPY varchar2,
111 p_interface_line_attribute13 OUT NOCOPY varchar2,
112 p_interface_line_attribute14 OUT NOCOPY varchar2,
113 p_interface_line_attribute15 OUT NOCOPY varchar2,
114 p_attribute_category OUT NOCOPY varchar2,
115 p_attribute1 OUT NOCOPY varchar2,
116 p_attribute2 OUT NOCOPY varchar2,
117 p_attribute3 OUT NOCOPY varchar2,
118 p_attribute4 OUT NOCOPY varchar2,
119 p_attribute5 OUT NOCOPY varchar2,
120 p_attribute6 OUT NOCOPY varchar2,
121 p_attribute7 OUT NOCOPY varchar2,
122 p_attribute8 OUT NOCOPY varchar2,
123 p_attribute9 OUT NOCOPY varchar2,
124 p_attribute10 OUT NOCOPY varchar2,
125 p_attribute11 OUT NOCOPY varchar2,
126 p_attribute12 OUT NOCOPY varchar2,
127 p_attribute13 OUT NOCOPY varchar2,
128 p_attribute14 OUT NOCOPY varchar2,
129 p_attribute15 OUT NOCOPY varchar2,
130 p_default_ussgl_trx_code OUT NOCOPY varchar2,
131 p_ct_prev_trx_number OUT NOCOPY varchar2,
132 p_ct_prev_trx_reference OUT NOCOPY varchar2,
133 p_ct_prev_inv_currency_code OUT NOCOPY varchar2,
134 p_ct_prev_trx_date OUT NOCOPY date,
135 p_ct_prev_bill_to_customer_id OUT NOCOPY number,
136 p_ct_prev_ship_to_customer_id OUT NOCOPY number,
137 p_ct_prev_sold_to_customer_id OUT NOCOPY number,
138 p_ct_prev_paying_customer_id OUT NOCOPY number,
139 p_ct_prev_bill_to_site_use_id OUT NOCOPY number,
140 p_ct_prev_ship_to_site_use_id OUT NOCOPY number,
141 p_ct_prev_paying_site_use_id OUT NOCOPY number,
142 p_ct_prev_bill_to_contact_id OUT NOCOPY number,
143 p_ct_prev_ship_to_contact_id OUT NOCOPY number,
144 p_ct_prev_initial_cust_trx_id OUT NOCOPY number,
145 p_ct_prev_primary_salesrep_id OUT NOCOPY number,
146 p_ct_prev_invoicing_rule_id OUT NOCOPY number,
147 p_gd_prev_gl_date OUT NOCOPY date,
148 p_prev_trx_original OUT NOCOPY number,
149 p_prev_trx_balance OUT NOCOPY number,
150 p_rac_prev_bill_to_cust_name OUT NOCOPY varchar2,
151 p_rac_prev_bill_to_cust_num OUT NOCOPY varchar2,
152 p_bs_prev_source_name OUT NOCOPY varchar2,
153 p_ctt_prev_class OUT NOCOPY varchar2,
154 p_ctt_prev_allow_overapp_flag OUT NOCOPY varchar2,
155 p_ctt_prev_natural_app_only OUT NOCOPY varchar2,
156 p_ct_prev_open_receivables OUT NOCOPY varchar2,
157 p_ct_prev_post_to_gl_flag OUT NOCOPY varchar2,
158 p_al_cm_reason_meaning OUT NOCOPY varchar2,
159 p_commit_memo_line_id OUT NOCOPY number,
160 p_commit_memo_line_desc OUT NOCOPY varchar2
161 );
162
163 PROCEDURE init;
164
165 END ARP_PROCESS_HEADER;