APPS.ARP_CTLGD_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 4: PROCEDURE set_to_dummy( p_dist_rec OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype);

1: PACKAGE ARP_CTLGD_PKG AUTHID CURRENT_USER AS
2: /* $Header: ARTILGDS.pls 120.4.12010000.2 2009/09/14 11:20:53 rasarasw ship $ */
3:
4: PROCEDURE set_to_dummy( p_dist_rec OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype);
5:
6:
7: PROCEDURE lock_p( p_cust_trx_line_gl_dist_id
8: IN ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);

Line 8: IN ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);

4: PROCEDURE set_to_dummy( p_dist_rec OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype);
5:
6:
7: PROCEDURE lock_p( p_cust_trx_line_gl_dist_id
8: IN ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);
9:
10: PROCEDURE lock_f_ct_id( p_customer_trx_id
11: IN ra_customer_trx.customer_trx_id%type,
12: p_account_set_flag

Line 13: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

9:
10: PROCEDURE lock_f_ct_id( p_customer_trx_id
11: IN ra_customer_trx.customer_trx_id%type,
12: p_account_set_flag
13: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
14: p_account_class
15: IN ra_cust_trx_line_gl_dist.account_class%type);
16:
17: PROCEDURE lock_f_ctl_id( p_customer_trx_line_id

Line 15: IN ra_cust_trx_line_gl_dist.account_class%type);

11: IN ra_customer_trx.customer_trx_id%type,
12: p_account_set_flag
13: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
14: p_account_class
15: IN ra_cust_trx_line_gl_dist.account_class%type);
16:
17: PROCEDURE lock_f_ctl_id( p_customer_trx_line_id
18: IN ra_customer_trx_lines.customer_trx_line_id%type,
19: p_account_set_flag

Line 20: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

16:
17: PROCEDURE lock_f_ctl_id( p_customer_trx_line_id
18: IN ra_customer_trx_lines.customer_trx_line_id%type,
19: p_account_set_flag
20: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
21: p_account_class
22: IN ra_cust_trx_line_gl_dist.account_class%type);
23:
24: PROCEDURE lock_f_ctls_id( p_cust_trx_line_salesrep_id

Line 22: IN ra_cust_trx_line_gl_dist.account_class%type);

18: IN ra_customer_trx_lines.customer_trx_line_id%type,
19: p_account_set_flag
20: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
21: p_account_class
22: IN ra_cust_trx_line_gl_dist.account_class%type);
23:
24: PROCEDURE lock_f_ctls_id( p_cust_trx_line_salesrep_id
25: IN ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
26: p_account_set_flag

Line 25: IN ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,

21: p_account_class
22: IN ra_cust_trx_line_gl_dist.account_class%type);
23:
24: PROCEDURE lock_f_ctls_id( p_cust_trx_line_salesrep_id
25: IN ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
26: p_account_set_flag
27: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
28: p_account_class
29: IN ra_cust_trx_line_gl_dist.account_class%type);

Line 27: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

23:
24: PROCEDURE lock_f_ctls_id( p_cust_trx_line_salesrep_id
25: IN ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
26: p_account_set_flag
27: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
28: p_account_class
29: IN ra_cust_trx_line_gl_dist.account_class%type);
30:
31: PROCEDURE lock_fetch_p( p_dist_rec IN OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,

Line 29: IN ra_cust_trx_line_gl_dist.account_class%type);

25: IN ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
26: p_account_set_flag
27: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
28: p_account_class
29: IN ra_cust_trx_line_gl_dist.account_class%type);
30:
31: PROCEDURE lock_fetch_p( p_dist_rec IN OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,
32: p_cust_trx_line_gl_dist_id IN
33: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);

Line 31: PROCEDURE lock_fetch_p( p_dist_rec IN OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,

27: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
28: p_account_class
29: IN ra_cust_trx_line_gl_dist.account_class%type);
30:
31: PROCEDURE lock_fetch_p( p_dist_rec IN OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,
32: p_cust_trx_line_gl_dist_id IN
33: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);
34:
35: PROCEDURE lock_compare_p( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

Line 33: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);

29: IN ra_cust_trx_line_gl_dist.account_class%type);
30:
31: PROCEDURE lock_fetch_p( p_dist_rec IN OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,
32: p_cust_trx_line_gl_dist_id IN
33: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);
34:
35: PROCEDURE lock_compare_p( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
36: p_cust_trx_line_gl_dist_id IN
37: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,

Line 35: PROCEDURE lock_compare_p( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

31: PROCEDURE lock_fetch_p( p_dist_rec IN OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,
32: p_cust_trx_line_gl_dist_id IN
33: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);
34:
35: PROCEDURE lock_compare_p( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
36: p_cust_trx_line_gl_dist_id IN
37: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
38: p_ignore_who_flag BOOLEAN DEFAULT FALSE);
39:

Line 37: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,

33: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);
34:
35: PROCEDURE lock_compare_p( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
36: p_cust_trx_line_gl_dist_id IN
37: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
38: p_ignore_who_flag BOOLEAN DEFAULT FALSE);
39:
40: PROCEDURE lock_compare_cover(
41: p_cust_trx_line_gl_dist_id IN

Line 42: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,

38: p_ignore_who_flag BOOLEAN DEFAULT FALSE);
39:
40: PROCEDURE lock_compare_cover(
41: p_cust_trx_line_gl_dist_id IN
42: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
43: p_customer_trx_id IN
44: ra_cust_trx_line_gl_dist.customer_trx_id%type,
45: p_customer_trx_line_id IN
46: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,

Line 44: ra_cust_trx_line_gl_dist.customer_trx_id%type,

40: PROCEDURE lock_compare_cover(
41: p_cust_trx_line_gl_dist_id IN
42: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
43: p_customer_trx_id IN
44: ra_cust_trx_line_gl_dist.customer_trx_id%type,
45: p_customer_trx_line_id IN
46: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,
47: p_cust_trx_line_salesrep_id IN
48: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,

Line 46: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,

42: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
43: p_customer_trx_id IN
44: ra_cust_trx_line_gl_dist.customer_trx_id%type,
45: p_customer_trx_line_id IN
46: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,
47: p_cust_trx_line_salesrep_id IN
48: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
49: p_account_class IN
50: ra_cust_trx_line_gl_dist.account_class%type,

Line 48: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,

44: ra_cust_trx_line_gl_dist.customer_trx_id%type,
45: p_customer_trx_line_id IN
46: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,
47: p_cust_trx_line_salesrep_id IN
48: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
49: p_account_class IN
50: ra_cust_trx_line_gl_dist.account_class%type,
51: p_percent IN
52: ra_cust_trx_line_gl_dist.percent%type,

Line 50: ra_cust_trx_line_gl_dist.account_class%type,

46: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,
47: p_cust_trx_line_salesrep_id IN
48: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
49: p_account_class IN
50: ra_cust_trx_line_gl_dist.account_class%type,
51: p_percent IN
52: ra_cust_trx_line_gl_dist.percent%type,
53: p_amount IN
54: ra_cust_trx_line_gl_dist.amount%type,

Line 52: ra_cust_trx_line_gl_dist.percent%type,

48: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
49: p_account_class IN
50: ra_cust_trx_line_gl_dist.account_class%type,
51: p_percent IN
52: ra_cust_trx_line_gl_dist.percent%type,
53: p_amount IN
54: ra_cust_trx_line_gl_dist.amount%type,
55: p_gl_date IN
56: ra_cust_trx_line_gl_dist.gl_date%type,

Line 54: ra_cust_trx_line_gl_dist.amount%type,

50: ra_cust_trx_line_gl_dist.account_class%type,
51: p_percent IN
52: ra_cust_trx_line_gl_dist.percent%type,
53: p_amount IN
54: ra_cust_trx_line_gl_dist.amount%type,
55: p_gl_date IN
56: ra_cust_trx_line_gl_dist.gl_date%type,
57: p_original_gl_date IN
58: ra_cust_trx_line_gl_dist.original_gl_date%type,

Line 56: ra_cust_trx_line_gl_dist.gl_date%type,

52: ra_cust_trx_line_gl_dist.percent%type,
53: p_amount IN
54: ra_cust_trx_line_gl_dist.amount%type,
55: p_gl_date IN
56: ra_cust_trx_line_gl_dist.gl_date%type,
57: p_original_gl_date IN
58: ra_cust_trx_line_gl_dist.original_gl_date%type,
59: p_gl_posted_date IN
60: ra_cust_trx_line_gl_dist.gl_posted_date%type,

Line 58: ra_cust_trx_line_gl_dist.original_gl_date%type,

54: ra_cust_trx_line_gl_dist.amount%type,
55: p_gl_date IN
56: ra_cust_trx_line_gl_dist.gl_date%type,
57: p_original_gl_date IN
58: ra_cust_trx_line_gl_dist.original_gl_date%type,
59: p_gl_posted_date IN
60: ra_cust_trx_line_gl_dist.gl_posted_date%type,
61: p_code_combination_id IN
62: ra_cust_trx_line_gl_dist.code_combination_id%type,

Line 60: ra_cust_trx_line_gl_dist.gl_posted_date%type,

56: ra_cust_trx_line_gl_dist.gl_date%type,
57: p_original_gl_date IN
58: ra_cust_trx_line_gl_dist.original_gl_date%type,
59: p_gl_posted_date IN
60: ra_cust_trx_line_gl_dist.gl_posted_date%type,
61: p_code_combination_id IN
62: ra_cust_trx_line_gl_dist.code_combination_id%type,
63: p_concatenated_segments IN
64: ra_cust_trx_line_gl_dist.concatenated_segments%type,

Line 62: ra_cust_trx_line_gl_dist.code_combination_id%type,

58: ra_cust_trx_line_gl_dist.original_gl_date%type,
59: p_gl_posted_date IN
60: ra_cust_trx_line_gl_dist.gl_posted_date%type,
61: p_code_combination_id IN
62: ra_cust_trx_line_gl_dist.code_combination_id%type,
63: p_concatenated_segments IN
64: ra_cust_trx_line_gl_dist.concatenated_segments%type,
65: p_collected_tax_ccid IN
66: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,

Line 64: ra_cust_trx_line_gl_dist.concatenated_segments%type,

60: ra_cust_trx_line_gl_dist.gl_posted_date%type,
61: p_code_combination_id IN
62: ra_cust_trx_line_gl_dist.code_combination_id%type,
63: p_concatenated_segments IN
64: ra_cust_trx_line_gl_dist.concatenated_segments%type,
65: p_collected_tax_ccid IN
66: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,
67: p_collected_tax_concat_seg IN
68: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,

Line 66: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,

62: ra_cust_trx_line_gl_dist.code_combination_id%type,
63: p_concatenated_segments IN
64: ra_cust_trx_line_gl_dist.concatenated_segments%type,
65: p_collected_tax_ccid IN
66: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,
67: p_collected_tax_concat_seg IN
68: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,
69: p_comments IN
70: ra_cust_trx_line_gl_dist.comments%type,

Line 68: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,

64: ra_cust_trx_line_gl_dist.concatenated_segments%type,
65: p_collected_tax_ccid IN
66: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,
67: p_collected_tax_concat_seg IN
68: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,
69: p_comments IN
70: ra_cust_trx_line_gl_dist.comments%type,
71: p_account_set_flag IN
72: ra_cust_trx_line_gl_dist.account_set_flag%type,

Line 70: ra_cust_trx_line_gl_dist.comments%type,

66: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,
67: p_collected_tax_concat_seg IN
68: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,
69: p_comments IN
70: ra_cust_trx_line_gl_dist.comments%type,
71: p_account_set_flag IN
72: ra_cust_trx_line_gl_dist.account_set_flag%type,
73: p_latest_rec_flag IN
74: ra_cust_trx_line_gl_dist.latest_rec_flag%type,

Line 72: ra_cust_trx_line_gl_dist.account_set_flag%type,

68: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,
69: p_comments IN
70: ra_cust_trx_line_gl_dist.comments%type,
71: p_account_set_flag IN
72: ra_cust_trx_line_gl_dist.account_set_flag%type,
73: p_latest_rec_flag IN
74: ra_cust_trx_line_gl_dist.latest_rec_flag%type,
75: p_ussgl_transaction_code IN
76: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,

Line 74: ra_cust_trx_line_gl_dist.latest_rec_flag%type,

70: ra_cust_trx_line_gl_dist.comments%type,
71: p_account_set_flag IN
72: ra_cust_trx_line_gl_dist.account_set_flag%type,
73: p_latest_rec_flag IN
74: ra_cust_trx_line_gl_dist.latest_rec_flag%type,
75: p_ussgl_transaction_code IN
76: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,
77: p_ussgl_trx_code_context IN
78: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,

Line 76: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,

72: ra_cust_trx_line_gl_dist.account_set_flag%type,
73: p_latest_rec_flag IN
74: ra_cust_trx_line_gl_dist.latest_rec_flag%type,
75: p_ussgl_transaction_code IN
76: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,
77: p_ussgl_trx_code_context IN
78: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,
79: p_attribute_category IN
80: ra_cust_trx_line_gl_dist.attribute_category%type,

Line 78: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,

74: ra_cust_trx_line_gl_dist.latest_rec_flag%type,
75: p_ussgl_transaction_code IN
76: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,
77: p_ussgl_trx_code_context IN
78: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,
79: p_attribute_category IN
80: ra_cust_trx_line_gl_dist.attribute_category%type,
81: p_attribute1 IN
82: ra_cust_trx_line_gl_dist.attribute1%type,

Line 80: ra_cust_trx_line_gl_dist.attribute_category%type,

76: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,
77: p_ussgl_trx_code_context IN
78: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,
79: p_attribute_category IN
80: ra_cust_trx_line_gl_dist.attribute_category%type,
81: p_attribute1 IN
82: ra_cust_trx_line_gl_dist.attribute1%type,
83: p_attribute2 IN
84: ra_cust_trx_line_gl_dist.attribute2%type,

Line 82: ra_cust_trx_line_gl_dist.attribute1%type,

78: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,
79: p_attribute_category IN
80: ra_cust_trx_line_gl_dist.attribute_category%type,
81: p_attribute1 IN
82: ra_cust_trx_line_gl_dist.attribute1%type,
83: p_attribute2 IN
84: ra_cust_trx_line_gl_dist.attribute2%type,
85: p_attribute3 IN
86: ra_cust_trx_line_gl_dist.attribute3%type,

Line 84: ra_cust_trx_line_gl_dist.attribute2%type,

80: ra_cust_trx_line_gl_dist.attribute_category%type,
81: p_attribute1 IN
82: ra_cust_trx_line_gl_dist.attribute1%type,
83: p_attribute2 IN
84: ra_cust_trx_line_gl_dist.attribute2%type,
85: p_attribute3 IN
86: ra_cust_trx_line_gl_dist.attribute3%type,
87: p_attribute4 IN
88: ra_cust_trx_line_gl_dist.attribute4%type,

Line 86: ra_cust_trx_line_gl_dist.attribute3%type,

82: ra_cust_trx_line_gl_dist.attribute1%type,
83: p_attribute2 IN
84: ra_cust_trx_line_gl_dist.attribute2%type,
85: p_attribute3 IN
86: ra_cust_trx_line_gl_dist.attribute3%type,
87: p_attribute4 IN
88: ra_cust_trx_line_gl_dist.attribute4%type,
89: p_attribute5 IN
90: ra_cust_trx_line_gl_dist.attribute5%type,

Line 88: ra_cust_trx_line_gl_dist.attribute4%type,

84: ra_cust_trx_line_gl_dist.attribute2%type,
85: p_attribute3 IN
86: ra_cust_trx_line_gl_dist.attribute3%type,
87: p_attribute4 IN
88: ra_cust_trx_line_gl_dist.attribute4%type,
89: p_attribute5 IN
90: ra_cust_trx_line_gl_dist.attribute5%type,
91: p_attribute6 IN
92: ra_cust_trx_line_gl_dist.attribute6%type,

Line 90: ra_cust_trx_line_gl_dist.attribute5%type,

86: ra_cust_trx_line_gl_dist.attribute3%type,
87: p_attribute4 IN
88: ra_cust_trx_line_gl_dist.attribute4%type,
89: p_attribute5 IN
90: ra_cust_trx_line_gl_dist.attribute5%type,
91: p_attribute6 IN
92: ra_cust_trx_line_gl_dist.attribute6%type,
93: p_attribute7 IN
94: ra_cust_trx_line_gl_dist.attribute7%type,

Line 92: ra_cust_trx_line_gl_dist.attribute6%type,

88: ra_cust_trx_line_gl_dist.attribute4%type,
89: p_attribute5 IN
90: ra_cust_trx_line_gl_dist.attribute5%type,
91: p_attribute6 IN
92: ra_cust_trx_line_gl_dist.attribute6%type,
93: p_attribute7 IN
94: ra_cust_trx_line_gl_dist.attribute7%type,
95: p_attribute8 IN
96: ra_cust_trx_line_gl_dist.attribute8%type,

Line 94: ra_cust_trx_line_gl_dist.attribute7%type,

90: ra_cust_trx_line_gl_dist.attribute5%type,
91: p_attribute6 IN
92: ra_cust_trx_line_gl_dist.attribute6%type,
93: p_attribute7 IN
94: ra_cust_trx_line_gl_dist.attribute7%type,
95: p_attribute8 IN
96: ra_cust_trx_line_gl_dist.attribute8%type,
97: p_attribute9 IN
98: ra_cust_trx_line_gl_dist.attribute9%type,

Line 96: ra_cust_trx_line_gl_dist.attribute8%type,

92: ra_cust_trx_line_gl_dist.attribute6%type,
93: p_attribute7 IN
94: ra_cust_trx_line_gl_dist.attribute7%type,
95: p_attribute8 IN
96: ra_cust_trx_line_gl_dist.attribute8%type,
97: p_attribute9 IN
98: ra_cust_trx_line_gl_dist.attribute9%type,
99: p_attribute10 IN
100: ra_cust_trx_line_gl_dist.attribute10%type,

Line 98: ra_cust_trx_line_gl_dist.attribute9%type,

94: ra_cust_trx_line_gl_dist.attribute7%type,
95: p_attribute8 IN
96: ra_cust_trx_line_gl_dist.attribute8%type,
97: p_attribute9 IN
98: ra_cust_trx_line_gl_dist.attribute9%type,
99: p_attribute10 IN
100: ra_cust_trx_line_gl_dist.attribute10%type,
101: p_attribute11 IN
102: ra_cust_trx_line_gl_dist.attribute11%type,

Line 100: ra_cust_trx_line_gl_dist.attribute10%type,

96: ra_cust_trx_line_gl_dist.attribute8%type,
97: p_attribute9 IN
98: ra_cust_trx_line_gl_dist.attribute9%type,
99: p_attribute10 IN
100: ra_cust_trx_line_gl_dist.attribute10%type,
101: p_attribute11 IN
102: ra_cust_trx_line_gl_dist.attribute11%type,
103: p_attribute12 IN
104: ra_cust_trx_line_gl_dist.attribute12%type,

Line 102: ra_cust_trx_line_gl_dist.attribute11%type,

98: ra_cust_trx_line_gl_dist.attribute9%type,
99: p_attribute10 IN
100: ra_cust_trx_line_gl_dist.attribute10%type,
101: p_attribute11 IN
102: ra_cust_trx_line_gl_dist.attribute11%type,
103: p_attribute12 IN
104: ra_cust_trx_line_gl_dist.attribute12%type,
105: p_attribute13 IN
106: ra_cust_trx_line_gl_dist.attribute13%type,

Line 104: ra_cust_trx_line_gl_dist.attribute12%type,

100: ra_cust_trx_line_gl_dist.attribute10%type,
101: p_attribute11 IN
102: ra_cust_trx_line_gl_dist.attribute11%type,
103: p_attribute12 IN
104: ra_cust_trx_line_gl_dist.attribute12%type,
105: p_attribute13 IN
106: ra_cust_trx_line_gl_dist.attribute13%type,
107: p_attribute14 IN
108: ra_cust_trx_line_gl_dist.attribute14%type,

Line 106: ra_cust_trx_line_gl_dist.attribute13%type,

102: ra_cust_trx_line_gl_dist.attribute11%type,
103: p_attribute12 IN
104: ra_cust_trx_line_gl_dist.attribute12%type,
105: p_attribute13 IN
106: ra_cust_trx_line_gl_dist.attribute13%type,
107: p_attribute14 IN
108: ra_cust_trx_line_gl_dist.attribute14%type,
109: p_attribute15 IN
110: ra_cust_trx_line_gl_dist.attribute15%type,

Line 108: ra_cust_trx_line_gl_dist.attribute14%type,

104: ra_cust_trx_line_gl_dist.attribute12%type,
105: p_attribute13 IN
106: ra_cust_trx_line_gl_dist.attribute13%type,
107: p_attribute14 IN
108: ra_cust_trx_line_gl_dist.attribute14%type,
109: p_attribute15 IN
110: ra_cust_trx_line_gl_dist.attribute15%type,
111: p_posting_control_id IN
112: ra_cust_trx_line_gl_dist.posting_control_id%type,

Line 110: ra_cust_trx_line_gl_dist.attribute15%type,

106: ra_cust_trx_line_gl_dist.attribute13%type,
107: p_attribute14 IN
108: ra_cust_trx_line_gl_dist.attribute14%type,
109: p_attribute15 IN
110: ra_cust_trx_line_gl_dist.attribute15%type,
111: p_posting_control_id IN
112: ra_cust_trx_line_gl_dist.posting_control_id%type,
113: p_ccid_change_flag IN
114: ra_cust_trx_line_gl_dist.ccid_change_flag%type ); /* Bug 8788491 */

Line 112: ra_cust_trx_line_gl_dist.posting_control_id%type,

108: ra_cust_trx_line_gl_dist.attribute14%type,
109: p_attribute15 IN
110: ra_cust_trx_line_gl_dist.attribute15%type,
111: p_posting_control_id IN
112: ra_cust_trx_line_gl_dist.posting_control_id%type,
113: p_ccid_change_flag IN
114: ra_cust_trx_line_gl_dist.ccid_change_flag%type ); /* Bug 8788491 */
115:
116: PROCEDURE fetch_p( p_dist_rec OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,

Line 114: ra_cust_trx_line_gl_dist.ccid_change_flag%type ); /* Bug 8788491 */

110: ra_cust_trx_line_gl_dist.attribute15%type,
111: p_posting_control_id IN
112: ra_cust_trx_line_gl_dist.posting_control_id%type,
113: p_ccid_change_flag IN
114: ra_cust_trx_line_gl_dist.ccid_change_flag%type ); /* Bug 8788491 */
115:
116: PROCEDURE fetch_p( p_dist_rec OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,
117: p_cust_trx_line_gl_dist_id IN
118: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);

Line 116: PROCEDURE fetch_p( p_dist_rec OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,

112: ra_cust_trx_line_gl_dist.posting_control_id%type,
113: p_ccid_change_flag IN
114: ra_cust_trx_line_gl_dist.ccid_change_flag%type ); /* Bug 8788491 */
115:
116: PROCEDURE fetch_p( p_dist_rec OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,
117: p_cust_trx_line_gl_dist_id IN
118: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);
119:
120: procedure delete_p( p_cust_trx_line_gl_dist_id

Line 118: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);

114: ra_cust_trx_line_gl_dist.ccid_change_flag%type ); /* Bug 8788491 */
115:
116: PROCEDURE fetch_p( p_dist_rec OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,
117: p_cust_trx_line_gl_dist_id IN
118: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);
119:
120: procedure delete_p( p_cust_trx_line_gl_dist_id
121: IN ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);
122:

Line 121: IN ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);

117: p_cust_trx_line_gl_dist_id IN
118: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);
119:
120: procedure delete_p( p_cust_trx_line_gl_dist_id
121: IN ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);
122:
123: procedure delete_f_ct_id( p_customer_trx_id
124: IN ra_customer_trx.customer_trx_id%type,
125: p_account_set_flag

Line 126: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

122:
123: procedure delete_f_ct_id( p_customer_trx_id
124: IN ra_customer_trx.customer_trx_id%type,
125: p_account_set_flag
126: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
127: p_account_class
128: IN ra_cust_trx_line_gl_dist.account_class%type);
129:
130: procedure delete_f_ctl_id( p_customer_trx_line_id

Line 128: IN ra_cust_trx_line_gl_dist.account_class%type);

124: IN ra_customer_trx.customer_trx_id%type,
125: p_account_set_flag
126: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
127: p_account_class
128: IN ra_cust_trx_line_gl_dist.account_class%type);
129:
130: procedure delete_f_ctl_id( p_customer_trx_line_id
131: IN ra_customer_trx_lines.customer_trx_line_id%type,
132: p_account_set_flag

Line 133: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

129:
130: procedure delete_f_ctl_id( p_customer_trx_line_id
131: IN ra_customer_trx_lines.customer_trx_line_id%type,
132: p_account_set_flag
133: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
134: p_account_class
135: IN ra_cust_trx_line_gl_dist.account_class%type);
136:
137: procedure delete_f_ctls_id( p_cust_trx_line_salesrep_id

Line 135: IN ra_cust_trx_line_gl_dist.account_class%type);

131: IN ra_customer_trx_lines.customer_trx_line_id%type,
132: p_account_set_flag
133: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
134: p_account_class
135: IN ra_cust_trx_line_gl_dist.account_class%type);
136:
137: procedure delete_f_ctls_id( p_cust_trx_line_salesrep_id
138: IN ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
139: p_account_set_flag

Line 140: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

136:
137: procedure delete_f_ctls_id( p_cust_trx_line_salesrep_id
138: IN ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
139: p_account_set_flag
140: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
141: p_account_class
142: IN ra_cust_trx_line_gl_dist.account_class%type);
143:
144: PROCEDURE delete_f_ct_ltctl_id_type(

Line 142: IN ra_cust_trx_line_gl_dist.account_class%type);

138: IN ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
139: p_account_set_flag
140: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
141: p_account_class
142: IN ra_cust_trx_line_gl_dist.account_class%type);
143:
144: PROCEDURE delete_f_ct_ltctl_id_type(
145: p_customer_trx_id IN
146: ra_customer_trx.customer_trx_id%type,

Line 152: ra_cust_trx_line_gl_dist.account_set_flag%type,

148: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
149: p_line_type IN
150: ra_customer_trx_lines.line_type%type,
151: p_account_set_flag IN
152: ra_cust_trx_line_gl_dist.account_set_flag%type,
153: p_account_class IN
154: ra_cust_trx_line_gl_dist.account_class%type);
155:
156: PROCEDURE update_p( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

Line 154: ra_cust_trx_line_gl_dist.account_class%type);

150: ra_customer_trx_lines.line_type%type,
151: p_account_set_flag IN
152: ra_cust_trx_line_gl_dist.account_set_flag%type,
153: p_account_class IN
154: ra_cust_trx_line_gl_dist.account_class%type);
155:
156: PROCEDURE update_p( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
157: p_cust_trx_line_gl_dist_id IN
158: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,

Line 156: PROCEDURE update_p( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

152: ra_cust_trx_line_gl_dist.account_set_flag%type,
153: p_account_class IN
154: ra_cust_trx_line_gl_dist.account_class%type);
155:
156: PROCEDURE update_p( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
157: p_cust_trx_line_gl_dist_id IN
158: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
159: p_exchange_rate IN ra_customer_trx.exchange_rate%type
160: DEFAULT 1,

Line 158: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,

154: ra_cust_trx_line_gl_dist.account_class%type);
155:
156: PROCEDURE update_p( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
157: p_cust_trx_line_gl_dist_id IN
158: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
159: p_exchange_rate IN ra_customer_trx.exchange_rate%type
160: DEFAULT 1,
161: p_currency_code IN fnd_currencies.currency_code%type
162: DEFAULT null,

Line 169: PROCEDURE update_f_ct_id( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

165: p_mau IN
166: fnd_currencies.minimum_accountable_unit%type
167: DEFAULT null);
168:
169: PROCEDURE update_f_ct_id( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
170: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
171: p_account_set_flag
172: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
173: p_account_class

Line 172: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

168:
169: PROCEDURE update_f_ct_id( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
170: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
171: p_account_set_flag
172: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
173: p_account_class
174: IN ra_cust_trx_line_gl_dist.account_class%type,
175: p_exchange_rate IN ra_customer_trx.exchange_rate%type
176: DEFAULT 1,

Line 174: IN ra_cust_trx_line_gl_dist.account_class%type,

170: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
171: p_account_set_flag
172: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
173: p_account_class
174: IN ra_cust_trx_line_gl_dist.account_class%type,
175: p_exchange_rate IN ra_customer_trx.exchange_rate%type
176: DEFAULT 1,
177: p_currency_code IN fnd_currencies.currency_code%type
178: DEFAULT null,

Line 186: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

182: fnd_currencies.minimum_accountable_unit%type
183: DEFAULT null);
184:
185: PROCEDURE update_f_ctl_id(
186: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
187: p_customer_trx_line_id IN
188: ra_customer_trx_lines.customer_trx_line_id%type,
189: p_account_set_flag
190: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

Line 190: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

186: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
187: p_customer_trx_line_id IN
188: ra_customer_trx_lines.customer_trx_line_id%type,
189: p_account_set_flag
190: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
191: p_account_class
192: IN ra_cust_trx_line_gl_dist.account_class%type,
193: p_exchange_rate IN ra_customer_trx.exchange_rate%type
194: DEFAULT 1,

Line 192: IN ra_cust_trx_line_gl_dist.account_class%type,

188: ra_customer_trx_lines.customer_trx_line_id%type,
189: p_account_set_flag
190: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
191: p_account_class
192: IN ra_cust_trx_line_gl_dist.account_class%type,
193: p_exchange_rate IN ra_customer_trx.exchange_rate%type
194: DEFAULT 1,
195: p_currency_code IN fnd_currencies.currency_code%type
196: DEFAULT null,

Line 204: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

200: fnd_currencies.minimum_accountable_unit%type
201: DEFAULT null);
202:
203: PROCEDURE update_f_ctls_id(
204: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
205: p_cust_trx_line_salesrep_id IN
206: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
207: p_account_set_flag
208: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

Line 208: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

204: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
205: p_cust_trx_line_salesrep_id IN
206: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
207: p_account_set_flag
208: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
209: p_account_class
210: IN ra_cust_trx_line_gl_dist.account_class%type,
211: p_exchange_rate IN ra_customer_trx.exchange_rate%type
212: DEFAULT 1,

Line 210: IN ra_cust_trx_line_gl_dist.account_class%type,

206: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
207: p_account_set_flag
208: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
209: p_account_class
210: IN ra_cust_trx_line_gl_dist.account_class%type,
211: p_exchange_rate IN ra_customer_trx.exchange_rate%type
212: DEFAULT 1,
213: p_currency_code IN fnd_currencies.currency_code%type
214: DEFAULT null,

Line 251: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

247: fnd_currencies.minimum_accountable_unit%type
248: default null);
249:
250: PROCEDURE insert_p(
251: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
252: p_cust_trx_line_gl_dist_id
253: OUT NOCOPY ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
254: p_exchange_rate IN ra_customer_trx.exchange_rate%type
255: DEFAULT 1,

Line 253: OUT NOCOPY ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,

249:
250: PROCEDURE insert_p(
251: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
252: p_cust_trx_line_gl_dist_id
253: OUT NOCOPY ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
254: p_exchange_rate IN ra_customer_trx.exchange_rate%type
255: DEFAULT 1,
256: p_currency_code IN fnd_currencies.currency_code%type
257: DEFAULT null,

Line 264: PROCEDURE display_dist_rec( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype);

260: p_mau IN fnd_currencies.minimum_accountable_unit%type
261: DEFAULT null
262: );
263:
264: PROCEDURE display_dist_rec( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype);
265:
266: PROCEDURE display_dist_p( p_cust_trx_line_gl_dist_id IN
267: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);
268:

Line 267: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);

263:
264: PROCEDURE display_dist_rec( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype);
265:
266: PROCEDURE display_dist_p( p_cust_trx_line_gl_dist_id IN
267: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);
268:
269: PROCEDURE display_dist_f_ctls_id( p_cust_trx_line_salesrep_id IN
270: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);
271:

Line 279: p_old_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

275: PROCEDURE display_dist_f_ctl_id( p_customer_trx_line_id IN
276: ra_customer_trx_lines.customer_trx_line_id%type);
277:
278: PROCEDURE merge_dist_recs(
279: p_old_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
280: p_new_dist_rec IN
281: ra_cust_trx_line_gl_dist%rowtype,
282: p_out_dist_rec IN OUT NOCOPY
283: ra_cust_trx_line_gl_dist%rowtype

Line 281: ra_cust_trx_line_gl_dist%rowtype,

277:
278: PROCEDURE merge_dist_recs(
279: p_old_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
280: p_new_dist_rec IN
281: ra_cust_trx_line_gl_dist%rowtype,
282: p_out_dist_rec IN OUT NOCOPY
283: ra_cust_trx_line_gl_dist%rowtype
284: );
285:

Line 283: ra_cust_trx_line_gl_dist%rowtype

279: p_old_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
280: p_new_dist_rec IN
281: ra_cust_trx_line_gl_dist%rowtype,
282: p_out_dist_rec IN OUT NOCOPY
283: ra_cust_trx_line_gl_dist%rowtype
284: );
285:
286: FUNCTION get_number_dummy(p_null IN NUMBER DEFAULT null) RETURN NUMBER;
287: