DBA Data[Home] [Help]

APPS.ARP_CTLS_PKG dependencies on RA_CUSTOMER_TRX

Line 19: ra_customer_trx_lines.customer_trx_line_id%type);

15: PROCEDURE display_salescredit_rec( p_srep_rec IN
16: ra_cust_trx_line_salesreps%rowtype);
17:
18: PROCEDURE display_salescredit_f_ctl_id( p_customer_trx_line_id IN
19: ra_customer_trx_lines.customer_trx_line_id%type);
20:
21: PROCEDURE set_to_dummy( p_srep_rec OUT NOCOPY ra_cust_trx_line_salesreps%rowtype);
22:
23: FUNCTION get_number_dummy(p_null IN NUMBER DEFAULT null) RETURN number;

Line 29: IN ra_customer_trx.customer_trx_id%type );

25: PROCEDURE lock_p( p_cust_trx_line_salesrep_id
26: IN ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);
27:
28: PROCEDURE lock_f_ct_id( p_customer_trx_id
29: IN ra_customer_trx.customer_trx_id%type );
30:
31: PROCEDURE lock_f_ctl_id( p_customer_trx_line_id
32: IN ra_customer_trx_lines.customer_trx_line_id%type);
33:

Line 32: IN ra_customer_trx_lines.customer_trx_line_id%type);

28: PROCEDURE lock_f_ct_id( p_customer_trx_id
29: IN ra_customer_trx.customer_trx_id%type );
30:
31: PROCEDURE lock_f_ctl_id( p_customer_trx_line_id
32: IN ra_customer_trx_lines.customer_trx_line_id%type);
33:
34: PROCEDURE lock_fetch_p( p_srep_rec IN OUT NOCOPY ra_cust_trx_line_salesreps%rowtype,
35: p_cust_trx_line_salesrep_id IN
36: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);

Line 50: IN ra_customer_trx_lines.customer_trx_line_id%type );

46:
47: procedure delete_p( p_cust_trx_line_salesrep_id
48: IN ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
49: p_customer_trx_line_id
50: IN ra_customer_trx_lines.customer_trx_line_id%type );
51:
52: procedure delete_f_ct_id( p_customer_trx_id
53: IN ra_customer_trx.customer_trx_id%type,
54: p_delete_default_recs_flag IN boolean DEFAULT TRUE);

Line 53: IN ra_customer_trx.customer_trx_id%type,

49: p_customer_trx_line_id
50: IN ra_customer_trx_lines.customer_trx_line_id%type );
51:
52: procedure delete_f_ct_id( p_customer_trx_id
53: IN ra_customer_trx.customer_trx_id%type,
54: p_delete_default_recs_flag IN boolean DEFAULT TRUE);
55:
56: procedure delete_f_ctl_id( p_customer_trx_line_id
57: IN ra_customer_trx_lines.customer_trx_line_id%type);

Line 57: IN ra_customer_trx_lines.customer_trx_line_id%type);

53: IN ra_customer_trx.customer_trx_id%type,
54: p_delete_default_recs_flag IN boolean DEFAULT TRUE);
55:
56: procedure delete_f_ctl_id( p_customer_trx_line_id
57: IN ra_customer_trx_lines.customer_trx_line_id%type);
58:
59: PROCEDURE update_p( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
60: p_cust_trx_line_salesrep_id IN
61: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);

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

60: p_cust_trx_line_salesrep_id IN
61: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);
62:
63: PROCEDURE update_f_ct_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
64: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type);
65:
66: PROCEDURE update_f_ctl_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
67: p_customer_trx_line_id IN
68: ra_customer_trx_lines.customer_trx_line_id%type);

Line 68: ra_customer_trx_lines.customer_trx_line_id%type);

64: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type);
65:
66: PROCEDURE update_f_ctl_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
67: p_customer_trx_line_id IN
68: ra_customer_trx_lines.customer_trx_line_id%type);
69:
70: PROCEDURE update_f_psr_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
71: p_prev_cust_trx_line_srep_id
72: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type);

Line 76: ra_customer_trx_lines.customer_trx_line_id%type,

72: ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type);
73:
74: PROCEDURE update_amounts_f_ctl_id(
75: p_customer_trx_line_id IN
76: ra_customer_trx_lines.customer_trx_line_id%type,
77: p_line_amount IN
78: ra_customer_trx_lines.extended_amount%type,
79: p_foreign_currency_code IN
80: fnd_currencies.currency_code%type);

Line 78: ra_customer_trx_lines.extended_amount%type,

74: PROCEDURE update_amounts_f_ctl_id(
75: p_customer_trx_line_id IN
76: ra_customer_trx_lines.customer_trx_line_id%type,
77: p_line_amount IN
78: ra_customer_trx_lines.extended_amount%type,
79: p_foreign_currency_code IN
80: fnd_currencies.currency_code%type);
81:
82: PROCEDURE insert_p(

Line 90: ra_customer_trx_lines.customer_trx_id%type,

86: );
87:
88: PROCEDURE insert_f_ct_ctl_id(
89: p_customer_trx_id IN
90: ra_customer_trx_lines.customer_trx_id%type,
91: p_customer_trx_line_id IN
92: ra_customer_trx_lines.customer_trx_line_id%type
93: );
94:

Line 92: ra_customer_trx_lines.customer_trx_line_id%type

88: PROCEDURE insert_f_ct_ctl_id(
89: p_customer_trx_id IN
90: ra_customer_trx_lines.customer_trx_id%type,
91: p_customer_trx_line_id IN
92: ra_customer_trx_lines.customer_trx_line_id%type
93: );
94:
95: PROCEDURE insert_f_cm_ct_ctl_id(
96: p_customer_trx_id IN

Line 97: ra_customer_trx.customer_trx_id%type,

93: );
94:
95: PROCEDURE insert_f_cm_ct_ctl_id(
96: p_customer_trx_id IN
97: ra_customer_trx.customer_trx_id%type,
98: p_customer_trx_line_id IN
99: ra_customer_trx_lines.customer_trx_line_id%type,
100: p_currency_code IN fnd_currencies.currency_code%type
101: );

Line 99: ra_customer_trx_lines.customer_trx_line_id%type,

95: PROCEDURE insert_f_cm_ct_ctl_id(
96: p_customer_trx_id IN
97: ra_customer_trx.customer_trx_id%type,
98: p_customer_trx_line_id IN
99: ra_customer_trx_lines.customer_trx_line_id%type,
100: p_currency_code IN fnd_currencies.currency_code%type
101: );
102: PROCEDURE insert_f_cmn_ct_ctl_id(
103: p_customer_trx_id IN

Line 104: ra_customer_trx.customer_trx_id%type,

100: p_currency_code IN fnd_currencies.currency_code%type
101: );
102: PROCEDURE insert_f_cmn_ct_ctl_id(
103: p_customer_trx_id IN
104: ra_customer_trx.customer_trx_id%type,
105: p_customer_trx_line_id IN
106: ra_customer_trx_lines.customer_trx_line_id%type
107: );
108: PROCEDURE merge_srep_recs(

Line 106: ra_customer_trx_lines.customer_trx_line_id%type

102: PROCEDURE insert_f_cmn_ct_ctl_id(
103: p_customer_trx_id IN
104: ra_customer_trx.customer_trx_id%type,
105: p_customer_trx_line_id IN
106: ra_customer_trx_lines.customer_trx_line_id%type
107: );
108: PROCEDURE merge_srep_recs(
109: p_old_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
110: p_new_srep_rec IN

Line 118: ra_customer_trx.customer_trx_id%type,

114:
115: PROCEDURE erase_foreign_key_references( p_cust_trx_line_salesrep_id IN
116: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
117: p_customer_trx_id IN
118: ra_customer_trx.customer_trx_id%type,
119: p_customer_trx_line_id IN
120: ra_customer_trx_lines.customer_trx_line_id%type);
121:
122: PROCEDURE lock_compare_cover(

Line 120: ra_customer_trx_lines.customer_trx_line_id%type);

116: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
117: p_customer_trx_id IN
118: ra_customer_trx.customer_trx_id%type,
119: p_customer_trx_line_id IN
120: ra_customer_trx_lines.customer_trx_line_id%type);
121:
122: PROCEDURE lock_compare_cover(
123: p_cust_trx_line_salesrep_id IN
124: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,