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_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 AS
2: /* $Header: ARTILGDS.pls 120.4 2005/10/30 04:27:22 appldev 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:
114: PROCEDURE fetch_p( p_dist_rec OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,

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:
114: PROCEDURE fetch_p( p_dist_rec OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,
115: p_cust_trx_line_gl_dist_id IN
116: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);

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

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:
114: PROCEDURE fetch_p( p_dist_rec OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,
115: p_cust_trx_line_gl_dist_id IN
116: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);
117:
118: procedure delete_p( p_cust_trx_line_gl_dist_id

Line 116: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);

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

Line 119: IN ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);

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

Line 124: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

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

Line 126: IN ra_cust_trx_line_gl_dist.account_class%type);

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

Line 131: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

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

Line 133: IN ra_cust_trx_line_gl_dist.account_class%type);

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

Line 138: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

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

Line 140: IN ra_cust_trx_line_gl_dist.account_class%type);

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

Line 150: ra_cust_trx_line_gl_dist.account_set_flag%type,

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

Line 152: ra_cust_trx_line_gl_dist.account_class%type);

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

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

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

Line 156: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,

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

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

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

Line 170: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

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

Line 172: IN ra_cust_trx_line_gl_dist.account_class%type,

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

Line 184: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

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

Line 188: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

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

Line 190: IN ra_cust_trx_line_gl_dist.account_class%type,

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

Line 202: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

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

Line 206: IN ra_cust_trx_line_gl_dist.account_set_flag%type,

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

Line 208: IN ra_cust_trx_line_gl_dist.account_class%type,

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

Line 249: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

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

Line 251: OUT NOCOPY ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,

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

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

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

Line 265: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);

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

Line 277: p_old_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,

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

Line 279: ra_cust_trx_line_gl_dist%rowtype,

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

Line 281: ra_cust_trx_line_gl_dist%rowtype

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