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,
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,
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
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,
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,
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
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,
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,
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,
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,
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,
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);
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:
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:
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(