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_FREIGHT_UTIL dependencies on RA_CUSTOMER_TRX

Line 7: p_ct_id IN ra_customer_trx.customer_trx_id%type,

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,

Line 8: p_line_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,

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,

Line 9: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,

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,

Line 10: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,

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,

Line 11: p_primary_salesrep_id IN ra_customer_trx.cust_trx_type_id%type,

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,

Line 12: p_inventory_item_id IN ra_customer_trx_lines.inventory_item_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,

Line 13: p_memo_line_id IN ra_customer_trx_lines.memo_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,

Line 15: p_line_prev_ctl_id IN OUT NOCOPY ra_customer_trx_lines.customer_trx_line_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,

Line 16: p_prev_ctl_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_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,

Line 17: p_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%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,

Line 18: p_inv_line_number OUT NOCOPY ra_customer_trx_lines.line_number%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,

Line 19: p_inv_frt_ccid OUT NOCOPY ra_customer_trx_lines.line_number%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,

Line 20: p_inv_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%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);

Line 21: p_inv_frt_uncr_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%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:

Line 24: p_ussgl_code OUT NOCOPY ra_customer_trx.default_ussgl_transaction_code%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)

Line 28: p_customer_trx_id IN ra_customer_trx.customer_trx_id%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,

Line 37: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type);

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