1 PACKAGE ARP_PROCESS_FREIGHT_UTIL AUTHID CURRENT_USER AS
2 /* $Header: ARTEFR1S.pls 115.2 2002/11/15 03:40:55 anukumar ship $ */
3
4 PROCEDURE default_freight_line(
5 p_form_name IN varchar2,
6 p_form_version IN number,
7 p_ct_id IN ra_customer_trx.customer_trx_id%type,
8 p_line_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
9 p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
10 p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
11 p_primary_salesrep_id IN ra_customer_trx.cust_trx_type_id%type,
12 p_inventory_item_id IN ra_customer_trx_lines.inventory_item_id%type,
13 p_memo_line_id IN ra_customer_trx_lines.memo_line_id%type,
14 p_currency_code IN fnd_currencies.currency_code%type,
15 p_line_prev_ctl_id IN OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
16 p_prev_ctl_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
17 p_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
18 p_inv_line_number OUT NOCOPY ra_customer_trx_lines.line_number%type,
19 p_inv_frt_ccid OUT NOCOPY ra_customer_trx_lines.line_number%type,
20 p_inv_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
21 p_inv_frt_uncr_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
22 p_ccid OUT NOCOPY ra_cust_trx_line_gl_dist.code_combination_id%type,
23 p_concat_segments OUT NOCOPY ra_cust_trx_line_gl_dist.concatenated_segments%type,
24 p_ussgl_code OUT NOCOPY ra_customer_trx.default_ussgl_transaction_code%type);
25
26
27 FUNCTION get_freight_type(
28 p_customer_trx_id IN ra_customer_trx.customer_trx_id%type)
29 RETURN varchar2;
30
31 PROCEDURE delete_frt_lines(
32 p_form_name IN varchar2,
33 p_form_version IN number,
34 p_trx_class IN ra_cust_trx_types.type%type,
35 p_complete_flag IN varchar2,
36 p_open_rec_flag IN varchar2,
37 p_customer_trx_id IN ra_customer_trx.customer_trx_id%type);
38
39 PROCEDURE get_default_fob(
40 pn_SHIP_TO_SITE_USE_ID IN NUMBER
41 , pn_BILL_TO_SITE_USE_ID IN NUMBER
42 , pn_SHIP_TO_CUSTOMER_ID IN NUMBER
43 , pn_BILL_TO_CUSTOMER_ID IN NUMBER
44 , pc_fob_point OUT NOCOPY VARCHAR2
45 , pc_fob_point_name OUT NOCOPY VARCHAR2);
46
47
48 END ARP_PROCESS_FREIGHT_UTIL;