APPS.ARP_PROCESS_COMMITMENT dependencies on RA_CUSTOMER_TRX

Line 9: ra_customer_trx_lines.customer_trx_line_id%type,

5:
6: TYPE commitment_rec_type IS RECORD
7: (
8: customer_trx_line_id
9: ra_customer_trx_lines.customer_trx_line_id%type,
10: inventory_item_id ra_customer_trx_lines.inventory_item_id%type,
11: memo_line_id ra_customer_trx_lines.memo_line_id%type,
12: description ra_customer_trx_lines.description%type,
13: extended_amount ra_customer_trx_lines.extended_amount%type,

Line 10: inventory_item_id ra_customer_trx_lines.inventory_item_id%type,

6: TYPE commitment_rec_type IS RECORD
7: (
8: customer_trx_line_id
9: ra_customer_trx_lines.customer_trx_line_id%type,
10: inventory_item_id ra_customer_trx_lines.inventory_item_id%type,
11: memo_line_id ra_customer_trx_lines.memo_line_id%type,
12: description ra_customer_trx_lines.description%type,
13: extended_amount ra_customer_trx_lines.extended_amount%type,
14: interface_line_attribute1

Line 11: memo_line_id ra_customer_trx_lines.memo_line_id%type,

7: (
8: customer_trx_line_id
9: ra_customer_trx_lines.customer_trx_line_id%type,
10: inventory_item_id ra_customer_trx_lines.inventory_item_id%type,
11: memo_line_id ra_customer_trx_lines.memo_line_id%type,
12: description ra_customer_trx_lines.description%type,
13: extended_amount ra_customer_trx_lines.extended_amount%type,
14: interface_line_attribute1
15: ra_customer_trx_lines.interface_line_attribute1%type,

Line 12: description ra_customer_trx_lines.description%type,

8: customer_trx_line_id
9: ra_customer_trx_lines.customer_trx_line_id%type,
10: inventory_item_id ra_customer_trx_lines.inventory_item_id%type,
11: memo_line_id ra_customer_trx_lines.memo_line_id%type,
12: description ra_customer_trx_lines.description%type,
13: extended_amount ra_customer_trx_lines.extended_amount%type,
14: interface_line_attribute1
15: ra_customer_trx_lines.interface_line_attribute1%type,
16: interface_line_attribute2

Line 13: extended_amount ra_customer_trx_lines.extended_amount%type,

9: ra_customer_trx_lines.customer_trx_line_id%type,
10: inventory_item_id ra_customer_trx_lines.inventory_item_id%type,
11: memo_line_id ra_customer_trx_lines.memo_line_id%type,
12: description ra_customer_trx_lines.description%type,
13: extended_amount ra_customer_trx_lines.extended_amount%type,
14: interface_line_attribute1
15: ra_customer_trx_lines.interface_line_attribute1%type,
16: interface_line_attribute2
17: ra_customer_trx_lines.interface_line_attribute2%type,

Line 15: ra_customer_trx_lines.interface_line_attribute1%type,

11: memo_line_id ra_customer_trx_lines.memo_line_id%type,
12: description ra_customer_trx_lines.description%type,
13: extended_amount ra_customer_trx_lines.extended_amount%type,
14: interface_line_attribute1
15: ra_customer_trx_lines.interface_line_attribute1%type,
16: interface_line_attribute2
17: ra_customer_trx_lines.interface_line_attribute2%type,
18: interface_line_attribute3
19: ra_customer_trx_lines.interface_line_attribute3%type,

Line 17: ra_customer_trx_lines.interface_line_attribute2%type,

13: extended_amount ra_customer_trx_lines.extended_amount%type,
14: interface_line_attribute1
15: ra_customer_trx_lines.interface_line_attribute1%type,
16: interface_line_attribute2
17: ra_customer_trx_lines.interface_line_attribute2%type,
18: interface_line_attribute3
19: ra_customer_trx_lines.interface_line_attribute3%type,
20: interface_line_attribute4
21: ra_customer_trx_lines.interface_line_attribute4%type,

Line 19: ra_customer_trx_lines.interface_line_attribute3%type,

15: ra_customer_trx_lines.interface_line_attribute1%type,
16: interface_line_attribute2
17: ra_customer_trx_lines.interface_line_attribute2%type,
18: interface_line_attribute3
19: ra_customer_trx_lines.interface_line_attribute3%type,
20: interface_line_attribute4
21: ra_customer_trx_lines.interface_line_attribute4%type,
22: interface_line_attribute5
23: ra_customer_trx_lines.interface_line_attribute5%type,

Line 21: ra_customer_trx_lines.interface_line_attribute4%type,

17: ra_customer_trx_lines.interface_line_attribute2%type,
18: interface_line_attribute3
19: ra_customer_trx_lines.interface_line_attribute3%type,
20: interface_line_attribute4
21: ra_customer_trx_lines.interface_line_attribute4%type,
22: interface_line_attribute5
23: ra_customer_trx_lines.interface_line_attribute5%type,
24: interface_line_attribute6
25: ra_customer_trx_lines.interface_line_attribute6%type,

Line 23: ra_customer_trx_lines.interface_line_attribute5%type,

19: ra_customer_trx_lines.interface_line_attribute3%type,
20: interface_line_attribute4
21: ra_customer_trx_lines.interface_line_attribute4%type,
22: interface_line_attribute5
23: ra_customer_trx_lines.interface_line_attribute5%type,
24: interface_line_attribute6
25: ra_customer_trx_lines.interface_line_attribute6%type,
26: interface_line_attribute7
27: ra_customer_trx_lines.interface_line_attribute7%type,

Line 25: ra_customer_trx_lines.interface_line_attribute6%type,

21: ra_customer_trx_lines.interface_line_attribute4%type,
22: interface_line_attribute5
23: ra_customer_trx_lines.interface_line_attribute5%type,
24: interface_line_attribute6
25: ra_customer_trx_lines.interface_line_attribute6%type,
26: interface_line_attribute7
27: ra_customer_trx_lines.interface_line_attribute7%type,
28: interface_line_attribute8
29: ra_customer_trx_lines.interface_line_attribute8%type,

Line 27: ra_customer_trx_lines.interface_line_attribute7%type,

23: ra_customer_trx_lines.interface_line_attribute5%type,
24: interface_line_attribute6
25: ra_customer_trx_lines.interface_line_attribute6%type,
26: interface_line_attribute7
27: ra_customer_trx_lines.interface_line_attribute7%type,
28: interface_line_attribute8
29: ra_customer_trx_lines.interface_line_attribute8%type,
30: interface_line_attribute9
31: ra_customer_trx_lines.interface_line_attribute9%type,

Line 29: ra_customer_trx_lines.interface_line_attribute8%type,

25: ra_customer_trx_lines.interface_line_attribute6%type,
26: interface_line_attribute7
27: ra_customer_trx_lines.interface_line_attribute7%type,
28: interface_line_attribute8
29: ra_customer_trx_lines.interface_line_attribute8%type,
30: interface_line_attribute9
31: ra_customer_trx_lines.interface_line_attribute9%type,
32: interface_line_attribute10
33: ra_customer_trx_lines.interface_line_attribute10%type,

Line 31: ra_customer_trx_lines.interface_line_attribute9%type,

27: ra_customer_trx_lines.interface_line_attribute7%type,
28: interface_line_attribute8
29: ra_customer_trx_lines.interface_line_attribute8%type,
30: interface_line_attribute9
31: ra_customer_trx_lines.interface_line_attribute9%type,
32: interface_line_attribute10
33: ra_customer_trx_lines.interface_line_attribute10%type,
34: interface_line_attribute11
35: ra_customer_trx_lines.interface_line_attribute11%type,

Line 33: ra_customer_trx_lines.interface_line_attribute10%type,

29: ra_customer_trx_lines.interface_line_attribute8%type,
30: interface_line_attribute9
31: ra_customer_trx_lines.interface_line_attribute9%type,
32: interface_line_attribute10
33: ra_customer_trx_lines.interface_line_attribute10%type,
34: interface_line_attribute11
35: ra_customer_trx_lines.interface_line_attribute11%type,
36: interface_line_attribute12
37: ra_customer_trx_lines.interface_line_attribute12%type,

Line 35: ra_customer_trx_lines.interface_line_attribute11%type,

31: ra_customer_trx_lines.interface_line_attribute9%type,
32: interface_line_attribute10
33: ra_customer_trx_lines.interface_line_attribute10%type,
34: interface_line_attribute11
35: ra_customer_trx_lines.interface_line_attribute11%type,
36: interface_line_attribute12
37: ra_customer_trx_lines.interface_line_attribute12%type,
38: interface_line_attribute13
39: ra_customer_trx_lines.interface_line_attribute13%type,

Line 37: ra_customer_trx_lines.interface_line_attribute12%type,

33: ra_customer_trx_lines.interface_line_attribute10%type,
34: interface_line_attribute11
35: ra_customer_trx_lines.interface_line_attribute11%type,
36: interface_line_attribute12
37: ra_customer_trx_lines.interface_line_attribute12%type,
38: interface_line_attribute13
39: ra_customer_trx_lines.interface_line_attribute13%type,
40: interface_line_attribute14
41: ra_customer_trx_lines.interface_line_attribute14%type,

Line 39: ra_customer_trx_lines.interface_line_attribute13%type,

35: ra_customer_trx_lines.interface_line_attribute11%type,
36: interface_line_attribute12
37: ra_customer_trx_lines.interface_line_attribute12%type,
38: interface_line_attribute13
39: ra_customer_trx_lines.interface_line_attribute13%type,
40: interface_line_attribute14
41: ra_customer_trx_lines.interface_line_attribute14%type,
42: interface_line_attribute15
43: ra_customer_trx_lines.interface_line_attribute15%type,

Line 41: ra_customer_trx_lines.interface_line_attribute14%type,

37: ra_customer_trx_lines.interface_line_attribute12%type,
38: interface_line_attribute13
39: ra_customer_trx_lines.interface_line_attribute13%type,
40: interface_line_attribute14
41: ra_customer_trx_lines.interface_line_attribute14%type,
42: interface_line_attribute15
43: ra_customer_trx_lines.interface_line_attribute15%type,
44: interface_line_context
45: ra_customer_trx_lines.interface_line_context%type,

Line 43: ra_customer_trx_lines.interface_line_attribute15%type,

39: ra_customer_trx_lines.interface_line_attribute13%type,
40: interface_line_attribute14
41: ra_customer_trx_lines.interface_line_attribute14%type,
42: interface_line_attribute15
43: ra_customer_trx_lines.interface_line_attribute15%type,
44: interface_line_context
45: ra_customer_trx_lines.interface_line_context%type,
46: attribute_category
47: ra_customer_trx_lines.attribute_category%type,

Line 45: ra_customer_trx_lines.interface_line_context%type,

41: ra_customer_trx_lines.interface_line_attribute14%type,
42: interface_line_attribute15
43: ra_customer_trx_lines.interface_line_attribute15%type,
44: interface_line_context
45: ra_customer_trx_lines.interface_line_context%type,
46: attribute_category
47: ra_customer_trx_lines.attribute_category%type,
48: attribute1 ra_customer_trx_lines.attribute1%type,
49: attribute2 ra_customer_trx_lines.attribute2%type,

Line 47: ra_customer_trx_lines.attribute_category%type,

43: ra_customer_trx_lines.interface_line_attribute15%type,
44: interface_line_context
45: ra_customer_trx_lines.interface_line_context%type,
46: attribute_category
47: ra_customer_trx_lines.attribute_category%type,
48: attribute1 ra_customer_trx_lines.attribute1%type,
49: attribute2 ra_customer_trx_lines.attribute2%type,
50: attribute3 ra_customer_trx_lines.attribute3%type,
51: attribute4 ra_customer_trx_lines.attribute4%type,

Line 48: attribute1 ra_customer_trx_lines.attribute1%type,

44: interface_line_context
45: ra_customer_trx_lines.interface_line_context%type,
46: attribute_category
47: ra_customer_trx_lines.attribute_category%type,
48: attribute1 ra_customer_trx_lines.attribute1%type,
49: attribute2 ra_customer_trx_lines.attribute2%type,
50: attribute3 ra_customer_trx_lines.attribute3%type,
51: attribute4 ra_customer_trx_lines.attribute4%type,
52: attribute5 ra_customer_trx_lines.attribute5%type,

Line 49: attribute2 ra_customer_trx_lines.attribute2%type,

45: ra_customer_trx_lines.interface_line_context%type,
46: attribute_category
47: ra_customer_trx_lines.attribute_category%type,
48: attribute1 ra_customer_trx_lines.attribute1%type,
49: attribute2 ra_customer_trx_lines.attribute2%type,
50: attribute3 ra_customer_trx_lines.attribute3%type,
51: attribute4 ra_customer_trx_lines.attribute4%type,
52: attribute5 ra_customer_trx_lines.attribute5%type,
53: attribute6 ra_customer_trx_lines.attribute6%type,

Line 50: attribute3 ra_customer_trx_lines.attribute3%type,

46: attribute_category
47: ra_customer_trx_lines.attribute_category%type,
48: attribute1 ra_customer_trx_lines.attribute1%type,
49: attribute2 ra_customer_trx_lines.attribute2%type,
50: attribute3 ra_customer_trx_lines.attribute3%type,
51: attribute4 ra_customer_trx_lines.attribute4%type,
52: attribute5 ra_customer_trx_lines.attribute5%type,
53: attribute6 ra_customer_trx_lines.attribute6%type,
54: attribute7 ra_customer_trx_lines.attribute7%type,

Line 51: attribute4 ra_customer_trx_lines.attribute4%type,

47: ra_customer_trx_lines.attribute_category%type,
48: attribute1 ra_customer_trx_lines.attribute1%type,
49: attribute2 ra_customer_trx_lines.attribute2%type,
50: attribute3 ra_customer_trx_lines.attribute3%type,
51: attribute4 ra_customer_trx_lines.attribute4%type,
52: attribute5 ra_customer_trx_lines.attribute5%type,
53: attribute6 ra_customer_trx_lines.attribute6%type,
54: attribute7 ra_customer_trx_lines.attribute7%type,
55: attribute8 ra_customer_trx_lines.attribute8%type,

Line 52: attribute5 ra_customer_trx_lines.attribute5%type,

48: attribute1 ra_customer_trx_lines.attribute1%type,
49: attribute2 ra_customer_trx_lines.attribute2%type,
50: attribute3 ra_customer_trx_lines.attribute3%type,
51: attribute4 ra_customer_trx_lines.attribute4%type,
52: attribute5 ra_customer_trx_lines.attribute5%type,
53: attribute6 ra_customer_trx_lines.attribute6%type,
54: attribute7 ra_customer_trx_lines.attribute7%type,
55: attribute8 ra_customer_trx_lines.attribute8%type,
56: attribute9 ra_customer_trx_lines.attribute9%type,

Line 53: attribute6 ra_customer_trx_lines.attribute6%type,

49: attribute2 ra_customer_trx_lines.attribute2%type,
50: attribute3 ra_customer_trx_lines.attribute3%type,
51: attribute4 ra_customer_trx_lines.attribute4%type,
52: attribute5 ra_customer_trx_lines.attribute5%type,
53: attribute6 ra_customer_trx_lines.attribute6%type,
54: attribute7 ra_customer_trx_lines.attribute7%type,
55: attribute8 ra_customer_trx_lines.attribute8%type,
56: attribute9 ra_customer_trx_lines.attribute9%type,
57: attribute10 ra_customer_trx_lines.attribute10%type,

Line 54: attribute7 ra_customer_trx_lines.attribute7%type,

50: attribute3 ra_customer_trx_lines.attribute3%type,
51: attribute4 ra_customer_trx_lines.attribute4%type,
52: attribute5 ra_customer_trx_lines.attribute5%type,
53: attribute6 ra_customer_trx_lines.attribute6%type,
54: attribute7 ra_customer_trx_lines.attribute7%type,
55: attribute8 ra_customer_trx_lines.attribute8%type,
56: attribute9 ra_customer_trx_lines.attribute9%type,
57: attribute10 ra_customer_trx_lines.attribute10%type,
58: attribute11 ra_customer_trx_lines.attribute11%type,

Line 55: attribute8 ra_customer_trx_lines.attribute8%type,

51: attribute4 ra_customer_trx_lines.attribute4%type,
52: attribute5 ra_customer_trx_lines.attribute5%type,
53: attribute6 ra_customer_trx_lines.attribute6%type,
54: attribute7 ra_customer_trx_lines.attribute7%type,
55: attribute8 ra_customer_trx_lines.attribute8%type,
56: attribute9 ra_customer_trx_lines.attribute9%type,
57: attribute10 ra_customer_trx_lines.attribute10%type,
58: attribute11 ra_customer_trx_lines.attribute11%type,
59: attribute12 ra_customer_trx_lines.attribute12%type,

Line 56: attribute9 ra_customer_trx_lines.attribute9%type,

52: attribute5 ra_customer_trx_lines.attribute5%type,
53: attribute6 ra_customer_trx_lines.attribute6%type,
54: attribute7 ra_customer_trx_lines.attribute7%type,
55: attribute8 ra_customer_trx_lines.attribute8%type,
56: attribute9 ra_customer_trx_lines.attribute9%type,
57: attribute10 ra_customer_trx_lines.attribute10%type,
58: attribute11 ra_customer_trx_lines.attribute11%type,
59: attribute12 ra_customer_trx_lines.attribute12%type,
60: attribute13 ra_customer_trx_lines.attribute13%type,

Line 57: attribute10 ra_customer_trx_lines.attribute10%type,

53: attribute6 ra_customer_trx_lines.attribute6%type,
54: attribute7 ra_customer_trx_lines.attribute7%type,
55: attribute8 ra_customer_trx_lines.attribute8%type,
56: attribute9 ra_customer_trx_lines.attribute9%type,
57: attribute10 ra_customer_trx_lines.attribute10%type,
58: attribute11 ra_customer_trx_lines.attribute11%type,
59: attribute12 ra_customer_trx_lines.attribute12%type,
60: attribute13 ra_customer_trx_lines.attribute13%type,
61: attribute14 ra_customer_trx_lines.attribute14%type,

Line 58: attribute11 ra_customer_trx_lines.attribute11%type,

54: attribute7 ra_customer_trx_lines.attribute7%type,
55: attribute8 ra_customer_trx_lines.attribute8%type,
56: attribute9 ra_customer_trx_lines.attribute9%type,
57: attribute10 ra_customer_trx_lines.attribute10%type,
58: attribute11 ra_customer_trx_lines.attribute11%type,
59: attribute12 ra_customer_trx_lines.attribute12%type,
60: attribute13 ra_customer_trx_lines.attribute13%type,
61: attribute14 ra_customer_trx_lines.attribute14%type,
62: attribute15 ra_customer_trx_lines.attribute15%type,

Line 59: attribute12 ra_customer_trx_lines.attribute12%type,

55: attribute8 ra_customer_trx_lines.attribute8%type,
56: attribute9 ra_customer_trx_lines.attribute9%type,
57: attribute10 ra_customer_trx_lines.attribute10%type,
58: attribute11 ra_customer_trx_lines.attribute11%type,
59: attribute12 ra_customer_trx_lines.attribute12%type,
60: attribute13 ra_customer_trx_lines.attribute13%type,
61: attribute14 ra_customer_trx_lines.attribute14%type,
62: attribute15 ra_customer_trx_lines.attribute15%type,
63: default_ussgl_transaction_code

Line 60: attribute13 ra_customer_trx_lines.attribute13%type,

56: attribute9 ra_customer_trx_lines.attribute9%type,
57: attribute10 ra_customer_trx_lines.attribute10%type,
58: attribute11 ra_customer_trx_lines.attribute11%type,
59: attribute12 ra_customer_trx_lines.attribute12%type,
60: attribute13 ra_customer_trx_lines.attribute13%type,
61: attribute14 ra_customer_trx_lines.attribute14%type,
62: attribute15 ra_customer_trx_lines.attribute15%type,
63: default_ussgl_transaction_code
64: ra_customer_trx_lines.default_ussgl_transaction_code%type

Line 61: attribute14 ra_customer_trx_lines.attribute14%type,

57: attribute10 ra_customer_trx_lines.attribute10%type,
58: attribute11 ra_customer_trx_lines.attribute11%type,
59: attribute12 ra_customer_trx_lines.attribute12%type,
60: attribute13 ra_customer_trx_lines.attribute13%type,
61: attribute14 ra_customer_trx_lines.attribute14%type,
62: attribute15 ra_customer_trx_lines.attribute15%type,
63: default_ussgl_transaction_code
64: ra_customer_trx_lines.default_ussgl_transaction_code%type
65: );

Line 62: attribute15 ra_customer_trx_lines.attribute15%type,

58: attribute11 ra_customer_trx_lines.attribute11%type,
59: attribute12 ra_customer_trx_lines.attribute12%type,
60: attribute13 ra_customer_trx_lines.attribute13%type,
61: attribute14 ra_customer_trx_lines.attribute14%type,
62: attribute15 ra_customer_trx_lines.attribute15%type,
63: default_ussgl_transaction_code
64: ra_customer_trx_lines.default_ussgl_transaction_code%type
65: );
66:

Line 64: ra_customer_trx_lines.default_ussgl_transaction_code%type

60: attribute13 ra_customer_trx_lines.attribute13%type,
61: attribute14 ra_customer_trx_lines.attribute14%type,
62: attribute15 ra_customer_trx_lines.attribute15%type,
63: default_ussgl_transaction_code
64: ra_customer_trx_lines.default_ussgl_transaction_code%type
65: );
66:
67: PROCEDURE header_post_insert ( p_customer_trx_id IN
68: ra_customer_trx.customer_trx_id%type,

Line 68: ra_customer_trx.customer_trx_id%type,

64: ra_customer_trx_lines.default_ussgl_transaction_code%type
65: );
66:
67: PROCEDURE header_post_insert ( p_customer_trx_id IN
68: ra_customer_trx.customer_trx_id%type,
69: p_commitment_rec IN commitment_rec_type,
70: p_primary_salesrep_id IN
71: ra_customer_trx.primary_salesrep_id%type,
72: p_gl_date IN

Line 71: ra_customer_trx.primary_salesrep_id%type,

67: PROCEDURE header_post_insert ( p_customer_trx_id IN
68: ra_customer_trx.customer_trx_id%type,
69: p_commitment_rec IN commitment_rec_type,
70: p_primary_salesrep_id IN
71: ra_customer_trx.primary_salesrep_id%type,
72: p_gl_date IN
73: ra_cust_trx_line_gl_dist.gl_date%type,
74: p_customer_trx_line_id OUT NOCOPY
75: ra_customer_trx_lines.customer_trx_line_id%type,

Line 75: ra_customer_trx_lines.customer_trx_line_id%type,

71: ra_customer_trx.primary_salesrep_id%type,
72: p_gl_date IN
73: ra_cust_trx_line_gl_dist.gl_date%type,
74: p_customer_trx_line_id OUT NOCOPY
75: ra_customer_trx_lines.customer_trx_line_id%type,
76: p_status OUT NOCOPY varchar2
77: );
78:
79: PROCEDURE header_pre_update;

Line 85: ra_customer_trx.exchange_rate%type,

81: PROCEDURE header_post_update( p_commitment_rec IN commitment_rec_type,
82: p_foreign_currency_code IN
83: fnd_currencies.currency_code%type,
84: p_exchange_rate IN
85: ra_customer_trx.exchange_rate%type,
86: p_rerun_autoacc_flag IN boolean );
87:
88: PROCEDURE header_pre_delete;
89: