DBA Data[Home] [Help]

APPS.ARP_PROCESS_HEADER dependencies on RA_CUSTOMER_TRX

Line 7: p_trx_rec IN ra_customer_trx%rowtype,

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,

Line 12: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,

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,

Line 13: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%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

Line 14: p_customer_trx_line_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%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,

Line 25: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,

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,

Line 26: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

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

Line 31: ra_customer_trx_lines.initial_customer_trx_line_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,

Line 53: ra_customer_trx.customer_trx_id%type,

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,

Line 55: ra_customer_trx.previous_customer_trx_id%type,

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,

Line 57: ra_customer_trx.complete_flag%type,

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,

Line 75: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

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,

Line 78: p_ship_via IN ra_customer_trx.ship_via%type,

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);

Line 79: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,

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:

Line 80: p_waybill_number IN ra_customer_trx.waybill_number%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:

Line 81: p_fob_point IN ra_customer_trx.fob_point%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(