eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_PROCESS_CREDIT_UTIL dependencies on RA_CUSTOMER_TRX

Line 5: p_ct_id IN ra_customer_trx.customer_trx_id%type,

1: PACKAGE ARP_PROCESS_CREDIT_UTIL AS
2: /* $Header: ARTECMUS.pls 120.4.12010000.1 2008/07/24 16:55:43 appldev ship $ */
3:
4: FUNCTION get_commitment_adjustments(
5: p_ct_id IN ra_customer_trx.customer_trx_id%type,
6: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type)
7: RETURN number;
8:
9: PROCEDURE get_commitment_adj_detail(

Line 6: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type)

2: /* $Header: ARTECMUS.pls 120.4.12010000.1 2008/07/24 16:55:43 appldev ship $ */
3:
4: FUNCTION get_commitment_adjustments(
5: p_ct_id IN ra_customer_trx.customer_trx_id%type,
6: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type)
7: RETURN number;
8:
9: PROCEDURE get_commitment_adj_detail(
10: p_ct_id IN ra_customer_trx.customer_trx_id%type,

Line 10: p_ct_id IN ra_customer_trx.customer_trx_id%type,

6: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type)
7: RETURN number;
8:
9: PROCEDURE get_commitment_adj_detail(
10: p_ct_id IN ra_customer_trx.customer_trx_id%type,
11: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type,
12: p_amount IN OUT NOCOPY number,
13: p_line_amount IN OUT NOCOPY number,
14: p_tax_amount IN OUT NOCOPY number,

Line 11: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type,

7: RETURN number;
8:
9: PROCEDURE get_commitment_adj_detail(
10: p_ct_id IN ra_customer_trx.customer_trx_id%type,
11: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type,
12: p_amount IN OUT NOCOPY number,
13: p_line_amount IN OUT NOCOPY number,
14: p_tax_amount IN OUT NOCOPY number,
15: p_freight_amount IN OUT NOCOPY number);

Line 18: p_ct_id IN ra_customer_trx.customer_trx_id%type,

14: p_tax_amount IN OUT NOCOPY number,
15: p_freight_amount IN OUT NOCOPY number);
16:
17: PROCEDURE get_credited_trx_details(
18: p_ct_id IN ra_customer_trx.customer_trx_id%type,
19: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type,
20: p_orig_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
21: p_orig_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
22: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 19: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type,

15: p_freight_amount IN OUT NOCOPY number);
16:
17: PROCEDURE get_credited_trx_details(
18: p_ct_id IN ra_customer_trx.customer_trx_id%type,
19: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type,
20: p_orig_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
21: p_orig_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
22: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
23: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 20: p_orig_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

16:
17: PROCEDURE get_credited_trx_details(
18: p_ct_id IN ra_customer_trx.customer_trx_id%type,
19: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type,
20: p_orig_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
21: p_orig_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
22: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
23: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
24: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 21: p_orig_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

17: PROCEDURE get_credited_trx_details(
18: p_ct_id IN ra_customer_trx.customer_trx_id%type,
19: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type,
20: p_orig_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
21: p_orig_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
22: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
23: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
24: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
25: p_bal_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 22: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

18: p_ct_id IN ra_customer_trx.customer_trx_id%type,
19: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type,
20: p_orig_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
21: p_orig_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
22: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
23: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
24: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
25: p_bal_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
26: p_bal_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 23: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

19: p_commit_ct_id IN ra_customer_trx.customer_trx_id%type,
20: p_orig_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
21: p_orig_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
22: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
23: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
24: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
25: p_bal_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
26: p_bal_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
27: p_bal_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 24: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

20: p_orig_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
21: p_orig_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
22: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
23: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
24: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
25: p_bal_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
26: p_bal_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
27: p_bal_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
28: p_num_line_lines OUT NOCOPY number,

Line 25: p_bal_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

21: p_orig_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
22: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
23: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
24: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
25: p_bal_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
26: p_bal_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
27: p_bal_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
28: p_num_line_lines OUT NOCOPY number,
29: p_num_tax_lines OUT NOCOPY number,

Line 26: p_bal_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

22: p_orig_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
23: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
24: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
25: p_bal_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
26: p_bal_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
27: p_bal_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
28: p_num_line_lines OUT NOCOPY number,
29: p_num_tax_lines OUT NOCOPY number,
30: p_num_frt_lines OUT NOCOPY number,

Line 27: p_bal_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

23: p_orig_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
24: p_bal_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
25: p_bal_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
26: p_bal_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
27: p_bal_tot_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
28: p_num_line_lines OUT NOCOPY number,
29: p_num_tax_lines OUT NOCOPY number,
30: p_num_frt_lines OUT NOCOPY number,
31: p_num_installments OUT NOCOPY number,

Line 36: p_ct_id IN ra_customer_trx.customer_trx_id%type,

32: p_payment_exist_flag OUT NOCOPY varchar2);
33:
34:
35: PROCEDURE get_credit_memo_amounts(
36: p_ct_id IN ra_customer_trx.customer_trx_id%type,
37: p_cm_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
38: p_cm_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
39: p_cm_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
40: p_num_line_lines OUT NOCOPY number,

Line 37: p_cm_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

33:
34:
35: PROCEDURE get_credit_memo_amounts(
36: p_ct_id IN ra_customer_trx.customer_trx_id%type,
37: p_cm_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
38: p_cm_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
39: p_cm_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
40: p_num_line_lines OUT NOCOPY number,
41: p_num_tax_lines OUT NOCOPY number,

Line 38: p_cm_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

34:
35: PROCEDURE get_credit_memo_amounts(
36: p_ct_id IN ra_customer_trx.customer_trx_id%type,
37: p_cm_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
38: p_cm_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
39: p_cm_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
40: p_num_line_lines OUT NOCOPY number,
41: p_num_tax_lines OUT NOCOPY number,
42: p_num_frt_lines OUT NOCOPY number);

Line 39: p_cm_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

35: PROCEDURE get_credit_memo_amounts(
36: p_ct_id IN ra_customer_trx.customer_trx_id%type,
37: p_cm_line_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
38: p_cm_tax_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
39: p_cm_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
40: p_num_line_lines OUT NOCOPY number,
41: p_num_tax_lines OUT NOCOPY number,
42: p_num_frt_lines OUT NOCOPY number);
43:

Line 46: ra_customer_trx.trx_date%type,

42: p_num_frt_lines OUT NOCOPY number);
43:
44: PROCEDURE get_cm_header_defaults(
45: p_trx_date IN
46: ra_customer_trx.trx_date%type,
47: p_crtrx_ct_id IN
48: ra_customer_trx.customer_trx_id%type,
49: p_ct_id IN
50: ra_customer_trx.customer_trx_id%type,

Line 48: ra_customer_trx.customer_trx_id%type,

44: PROCEDURE get_cm_header_defaults(
45: p_trx_date IN
46: ra_customer_trx.trx_date%type,
47: p_crtrx_ct_id IN
48: ra_customer_trx.customer_trx_id%type,
49: p_ct_id IN
50: ra_customer_trx.customer_trx_id%type,
51: p_bs_id IN
52: ra_batch_sources.batch_source_id%type,

Line 50: ra_customer_trx.customer_trx_id%type,

46: ra_customer_trx.trx_date%type,
47: p_crtrx_ct_id IN
48: ra_customer_trx.customer_trx_id%type,
49: p_ct_id IN
50: ra_customer_trx.customer_trx_id%type,
51: p_bs_id IN
52: ra_batch_sources.batch_source_id%type,
53: p_gl_date IN
54: ra_cust_trx_line_gl_dist.gl_date%type,

Line 82: ra_customer_trx.ship_via%type,

78: hz_cust_accounts.cust_account_id%type,
79: p_paying_site_use_id IN
80: hz_cust_site_uses.site_use_id%type,
81: p_ship_via IN
82: ra_customer_trx.ship_via%type,
83: p_fob_point IN
84: ra_customer_trx.fob_point%type,
85: p_invoicing_rule_id IN
86: ra_customer_trx.invoicing_rule_id%type,

Line 84: ra_customer_trx.fob_point%type,

80: hz_cust_site_uses.site_use_id%type,
81: p_ship_via IN
82: ra_customer_trx.ship_via%type,
83: p_fob_point IN
84: ra_customer_trx.fob_point%type,
85: p_invoicing_rule_id IN
86: ra_customer_trx.invoicing_rule_id%type,
87: p_rev_recog_run_flag IN
88: varchar2,

Line 86: ra_customer_trx.invoicing_rule_id%type,

82: ra_customer_trx.ship_via%type,
83: p_fob_point IN
84: ra_customer_trx.fob_point%type,
85: p_invoicing_rule_id IN
86: ra_customer_trx.invoicing_rule_id%type,
87: p_rev_recog_run_flag IN
88: varchar2,
89: p_complete_flag IN
90: ra_customer_trx.complete_flag%type,

Line 90: ra_customer_trx.complete_flag%type,

86: ra_customer_trx.invoicing_rule_id%type,
87: p_rev_recog_run_flag IN
88: varchar2,
89: p_complete_flag IN
90: ra_customer_trx.complete_flag%type,
91: p_salesrep_required_flag IN
92: ar_system_parameters.salesrep_required_flag%type,
93: --
94: p_crtrx_bs_id IN

Line 133: ra_customer_trx.ship_via%type,

129: ar_receipt_methods.receipt_method_id%type,
130: p_crtrx_cust_bank_account_id IN
131: ce_bank_accounts.bank_account_id%type,
132: p_crtrx_ship_via IN
133: ra_customer_trx.ship_via%type,
134: p_crtrx_ship_date_actual IN
135: ra_customer_trx.ship_date_actual%type,
136: p_crtrx_waybill_number IN
137: ra_customer_trx.waybill_number%type,

Line 135: ra_customer_trx.ship_date_actual%type,

131: ce_bank_accounts.bank_account_id%type,
132: p_crtrx_ship_via IN
133: ra_customer_trx.ship_via%type,
134: p_crtrx_ship_date_actual IN
135: ra_customer_trx.ship_date_actual%type,
136: p_crtrx_waybill_number IN
137: ra_customer_trx.waybill_number%type,
138: p_crtrx_fob_point IN
139: ra_customer_trx.fob_point%type,

Line 137: ra_customer_trx.waybill_number%type,

133: ra_customer_trx.ship_via%type,
134: p_crtrx_ship_date_actual IN
135: ra_customer_trx.ship_date_actual%type,
136: p_crtrx_waybill_number IN
137: ra_customer_trx.waybill_number%type,
138: p_crtrx_fob_point IN
139: ra_customer_trx.fob_point%type,
140: --
141: p_default_bs_id OUT NOCOPY

Line 139: ra_customer_trx.fob_point%type,

135: ra_customer_trx.ship_date_actual%type,
136: p_crtrx_waybill_number IN
137: ra_customer_trx.waybill_number%type,
138: p_crtrx_fob_point IN
139: ra_customer_trx.fob_point%type,
140: --
141: p_default_bs_id OUT NOCOPY
142: ra_batch_sources.batch_source_id%type,
143: p_default_bs_name OUT NOCOPY

Line 172: ra_customer_trx.printing_option%type,

168: ra_cust_trx_types.natural_application_only_flag%type,
169: p_tax_calculation_flag OUT NOCOPY
170: ra_cust_trx_types.tax_calculation_flag%type,
171: p_default_printing_option OUT NOCOPY
172: ra_customer_trx.printing_option%type,
173: --
174: p_default_gl_date OUT NOCOPY
175: ra_cust_trx_line_gl_dist.gl_date%type,
176: p_default_ship_to_customer_id OUT NOCOPY

Line 199: ra_customer_trx.ship_via%type,

195: hz_cust_accounts.cust_account_id%type,
196: p_default_paying_site_use_id OUT NOCOPY
197: hz_cust_site_uses.site_use_id%type,
198: p_default_ship_via OUT NOCOPY
199: ra_customer_trx.ship_via%type,
200: p_default_ship_date_actual OUT NOCOPY
201: ra_customer_trx.ship_date_actual%type,
202: p_default_waybill_number OUT NOCOPY
203: ra_customer_trx.waybill_number%type,

Line 201: ra_customer_trx.ship_date_actual%type,

197: hz_cust_site_uses.site_use_id%type,
198: p_default_ship_via OUT NOCOPY
199: ra_customer_trx.ship_via%type,
200: p_default_ship_date_actual OUT NOCOPY
201: ra_customer_trx.ship_date_actual%type,
202: p_default_waybill_number OUT NOCOPY
203: ra_customer_trx.waybill_number%type,
204: p_default_fob_point OUT NOCOPY
205: ra_customer_trx.fob_point%type);

Line 203: ra_customer_trx.waybill_number%type,

199: ra_customer_trx.ship_via%type,
200: p_default_ship_date_actual OUT NOCOPY
201: ra_customer_trx.ship_date_actual%type,
202: p_default_waybill_number OUT NOCOPY
203: ra_customer_trx.waybill_number%type,
204: p_default_fob_point OUT NOCOPY
205: ra_customer_trx.fob_point%type);
206:
207:

Line 205: ra_customer_trx.fob_point%type);

201: ra_customer_trx.ship_date_actual%type,
202: p_default_waybill_number OUT NOCOPY
203: ra_customer_trx.waybill_number%type,
204: p_default_fob_point OUT NOCOPY
205: ra_customer_trx.fob_point%type);
206:
207:
208: FUNCTION check_payment_method(
209: p_trx_date IN

Line 210: ra_customer_trx.trx_date%type,

206:
207:
208: FUNCTION check_payment_method(
209: p_trx_date IN
210: ra_customer_trx.trx_date%type,
211: p_customer_id IN
212: ra_customer_trx.customer_trx_id%type,
213: p_site_use_id IN
214: hz_cust_site_uses.site_use_id%type,

Line 212: ra_customer_trx.customer_trx_id%type,

208: FUNCTION check_payment_method(
209: p_trx_date IN
210: ra_customer_trx.trx_date%type,
211: p_customer_id IN
212: ra_customer_trx.customer_trx_id%type,
213: p_site_use_id IN
214: hz_cust_site_uses.site_use_id%type,
215: p_parent_customer_id IN
216: hz_cust_accounts.cust_account_id%type,

Line 233: ra_customer_trx.trx_date%type,

229: ) RETURN BOOLEAN;
230:
231: FUNCTION check_bank_account(
232: p_trx_date IN
233: ra_customer_trx.trx_date%type,
234: p_currency_code IN
235: fnd_currencies.currency_code%type,
236: p_bill_to_customer_id IN
237: hz_cust_accounts.cust_account_id%type,