APPS.PAY_MX_UTILITY dependencies on PAY_MX_UTILITY

Line 1: PACKAGE BODY pay_mx_utility AS

1: PACKAGE BODY pay_mx_utility AS
2: /* $Header: pymxutil.pkb 120.6.12010000.3 2008/11/25 13:50:44 vvijayku ship $ */
3:
4: --
5: -- Global Variables

Line 48: hr_utility.trace( 'COUNT '|| pay_mx_utility.days_bal_tbl.count);

44: --hr_utility.trace_on( NULL, 'BAL');
45:
46: ln_found := 0;
47:
48: hr_utility.trace( 'COUNT '|| pay_mx_utility.days_bal_tbl.count);
49:
50: if pay_mx_utility.days_bal_tbl.count > 0 then
51:
52: for i in pay_mx_utility.days_bal_tbl.first ..

Line 50: if pay_mx_utility.days_bal_tbl.count > 0 then

46: ln_found := 0;
47:
48: hr_utility.trace( 'COUNT '|| pay_mx_utility.days_bal_tbl.count);
49:
50: if pay_mx_utility.days_bal_tbl.count > 0 then
51:
52: for i in pay_mx_utility.days_bal_tbl.first ..
53: pay_mx_utility.days_bal_tbl.last
54: loop

Line 52: for i in pay_mx_utility.days_bal_tbl.first ..

48: hr_utility.trace( 'COUNT '|| pay_mx_utility.days_bal_tbl.count);
49:
50: if pay_mx_utility.days_bal_tbl.count > 0 then
51:
52: for i in pay_mx_utility.days_bal_tbl.first ..
53: pay_mx_utility.days_bal_tbl.last
54: loop
55:
56: if pay_mx_utility.days_bal_tbl(i).bal_type_id = p_balance_type_id then

Line 53: pay_mx_utility.days_bal_tbl.last

49:
50: if pay_mx_utility.days_bal_tbl.count > 0 then
51:
52: for i in pay_mx_utility.days_bal_tbl.first ..
53: pay_mx_utility.days_bal_tbl.last
54: loop
55:
56: if pay_mx_utility.days_bal_tbl(i).bal_type_id = p_balance_type_id then
57:

Line 56: if pay_mx_utility.days_bal_tbl(i).bal_type_id = p_balance_type_id then

52: for i in pay_mx_utility.days_bal_tbl.first ..
53: pay_mx_utility.days_bal_tbl.last
54: loop
55:
56: if pay_mx_utility.days_bal_tbl(i).bal_type_id = p_balance_type_id then
57:
58: ln_days_bal_type_id :=
59: pay_mx_utility.days_bal_tbl(i).days_bal_type_id;
60: lv_balance_uom := pay_mx_utility.days_bal_tbl(i).days_bal_uom;

Line 59: pay_mx_utility.days_bal_tbl(i).days_bal_type_id;

55:
56: if pay_mx_utility.days_bal_tbl(i).bal_type_id = p_balance_type_id then
57:
58: ln_days_bal_type_id :=
59: pay_mx_utility.days_bal_tbl(i).days_bal_type_id;
60: lv_balance_uom := pay_mx_utility.days_bal_tbl(i).days_bal_uom;
61: ln_found := 1;
62:
63: end if;

Line 60: lv_balance_uom := pay_mx_utility.days_bal_tbl(i).days_bal_uom;

56: if pay_mx_utility.days_bal_tbl(i).bal_type_id = p_balance_type_id then
57:
58: ln_days_bal_type_id :=
59: pay_mx_utility.days_bal_tbl(i).days_bal_type_id;
60: lv_balance_uom := pay_mx_utility.days_bal_tbl(i).days_bal_uom;
61: ln_found := 1;
62:
63: end if;
64:

Line 67: pay_mx_utility.days_bal_tbl(i).days_bal_type_id);

63: end if;
64:
65: hr_utility.trace( 'p_balance_type_id '||p_balance_type_id);
66: hr_utility.trace( 'BAL TYPE ID '||
67: pay_mx_utility.days_bal_tbl(i).days_bal_type_id);
68:
69: end loop;
70:
71: end if;

Line 79: ln_index := pay_mx_utility.days_bal_tbl.count;

75: open c_days_bal_type_id(p_balance_type_id);
76: fetch c_days_bal_type_id into ln_days_bal_type_id, lv_balance_uom;
77: close c_days_bal_type_id;
78:
79: ln_index := pay_mx_utility.days_bal_tbl.count;
80:
81: pay_mx_utility.days_bal_tbl(ln_index).bal_type_id := p_balance_type_id;
82: pay_mx_utility.days_bal_tbl(ln_index).days_bal_type_id :=
83: ln_days_bal_type_id;

Line 81: pay_mx_utility.days_bal_tbl(ln_index).bal_type_id := p_balance_type_id;

77: close c_days_bal_type_id;
78:
79: ln_index := pay_mx_utility.days_bal_tbl.count;
80:
81: pay_mx_utility.days_bal_tbl(ln_index).bal_type_id := p_balance_type_id;
82: pay_mx_utility.days_bal_tbl(ln_index).days_bal_type_id :=
83: ln_days_bal_type_id;
84: pay_mx_utility.days_bal_tbl(ln_index).days_bal_uom := lv_balance_uom;
85:

Line 82: pay_mx_utility.days_bal_tbl(ln_index).days_bal_type_id :=

78:
79: ln_index := pay_mx_utility.days_bal_tbl.count;
80:
81: pay_mx_utility.days_bal_tbl(ln_index).bal_type_id := p_balance_type_id;
82: pay_mx_utility.days_bal_tbl(ln_index).days_bal_type_id :=
83: ln_days_bal_type_id;
84: pay_mx_utility.days_bal_tbl(ln_index).days_bal_uom := lv_balance_uom;
85:
86: hr_utility.trace( 'DAYS BAL TYPE ID '||ln_days_bal_type_id);

Line 84: pay_mx_utility.days_bal_tbl(ln_index).days_bal_uom := lv_balance_uom;

80:
81: pay_mx_utility.days_bal_tbl(ln_index).bal_type_id := p_balance_type_id;
82: pay_mx_utility.days_bal_tbl(ln_index).days_bal_type_id :=
83: ln_days_bal_type_id;
84: pay_mx_utility.days_bal_tbl(ln_index).days_bal_uom := lv_balance_uom;
85:
86: hr_utility.trace( 'DAYS BAL TYPE ID '||ln_days_bal_type_id);
87: end if;
88:

Line 130: hr_utility.trace( 'COUNT '|| pay_mx_utility.hours_bal_tbl.count);

126: --hr_utility.trace_on( NULL, 'BAL');
127:
128: ln_found := 0;
129:
130: hr_utility.trace( 'COUNT '|| pay_mx_utility.hours_bal_tbl.count);
131:
132: /*
133: if pay_mx_utility.hours_bal_tbl.count > 0 then
134:

Line 133: if pay_mx_utility.hours_bal_tbl.count > 0 then

129:
130: hr_utility.trace( 'COUNT '|| pay_mx_utility.hours_bal_tbl.count);
131:
132: /*
133: if pay_mx_utility.hours_bal_tbl.count > 0 then
134:
135: for i in pay_mx_utility.hours_bal_tbl.first ..
136: pay_mx_utility.hours_bal_tbl.last
137: loop

Line 135: for i in pay_mx_utility.hours_bal_tbl.first ..

131:
132: /*
133: if pay_mx_utility.hours_bal_tbl.count > 0 then
134:
135: for i in pay_mx_utility.hours_bal_tbl.first ..
136: pay_mx_utility.hours_bal_tbl.last
137: loop
138:
139: if pay_mx_utility.hours_bal_tbl(i).bal_type_id = p_balance_type_id

Line 136: pay_mx_utility.hours_bal_tbl.last

132: /*
133: if pay_mx_utility.hours_bal_tbl.count > 0 then
134:
135: for i in pay_mx_utility.hours_bal_tbl.first ..
136: pay_mx_utility.hours_bal_tbl.last
137: loop
138:
139: if pay_mx_utility.hours_bal_tbl(i).bal_type_id = p_balance_type_id
140: then

Line 139: if pay_mx_utility.hours_bal_tbl(i).bal_type_id = p_balance_type_id

135: for i in pay_mx_utility.hours_bal_tbl.first ..
136: pay_mx_utility.hours_bal_tbl.last
137: loop
138:
139: if pay_mx_utility.hours_bal_tbl(i).bal_type_id = p_balance_type_id
140: then
141:
142: ln_hours_bal_type_id :=
143: pay_mx_utility.hours_bal_tbl(i).hours_bal_type_id;

Line 143: pay_mx_utility.hours_bal_tbl(i).hours_bal_type_id;

139: if pay_mx_utility.hours_bal_tbl(i).bal_type_id = p_balance_type_id
140: then
141:
142: ln_hours_bal_type_id :=
143: pay_mx_utility.hours_bal_tbl(i).hours_bal_type_id;
144: lv_balance_uom := pay_mx_utility.hours_bal_tbl(i).hours_bal_uom;
145: ln_found := 1;
146:
147: end if;

Line 144: lv_balance_uom := pay_mx_utility.hours_bal_tbl(i).hours_bal_uom;

140: then
141:
142: ln_hours_bal_type_id :=
143: pay_mx_utility.hours_bal_tbl(i).hours_bal_type_id;
144: lv_balance_uom := pay_mx_utility.hours_bal_tbl(i).hours_bal_uom;
145: ln_found := 1;
146:
147: end if;
148:

Line 151: pay_mx_utility.hours_bal_tbl(i).hours_bal_type_id);

147: end if;
148:
149: hr_utility.trace( 'p_balance_type_id '||p_balance_type_id);
150: hr_utility.trace( 'BAL TYPE ID '||
151: pay_mx_utility.hours_bal_tbl(i).hours_bal_type_id);
152:
153: end loop;
154:
155: end if;

Line 158: IF (pay_mx_utility.hours_bal_tbl.EXISTS(p_balance_type_id) = FALSE) THEN

154:
155: end if;
156: */
157:
158: IF (pay_mx_utility.hours_bal_tbl.EXISTS(p_balance_type_id) = FALSE) THEN
159:
160:
161: open c_hours_bal_type_id(p_balance_type_id);
162: fetch c_hours_bal_type_id into ln_hours_bal_type_id, lv_balance_uom;

Line 165: ln_index := pay_mx_utility.hours_bal_tbl.count;

161: open c_hours_bal_type_id(p_balance_type_id);
162: fetch c_hours_bal_type_id into ln_hours_bal_type_id, lv_balance_uom;
163: close c_hours_bal_type_id;
164:
165: ln_index := pay_mx_utility.hours_bal_tbl.count;
166:
167: pay_mx_utility.hours_bal_tbl(p_balance_type_id).bal_type_id :=
168: p_balance_type_id;
169: pay_mx_utility.hours_bal_tbl(p_balance_type_id).hours_bal_type_id :=

Line 167: pay_mx_utility.hours_bal_tbl(p_balance_type_id).bal_type_id :=

163: close c_hours_bal_type_id;
164:
165: ln_index := pay_mx_utility.hours_bal_tbl.count;
166:
167: pay_mx_utility.hours_bal_tbl(p_balance_type_id).bal_type_id :=
168: p_balance_type_id;
169: pay_mx_utility.hours_bal_tbl(p_balance_type_id).hours_bal_type_id :=
170: ln_hours_bal_type_id;
171: pay_mx_utility.hours_bal_tbl(p_balance_type_id).hours_bal_uom :=

Line 169: pay_mx_utility.hours_bal_tbl(p_balance_type_id).hours_bal_type_id :=

165: ln_index := pay_mx_utility.hours_bal_tbl.count;
166:
167: pay_mx_utility.hours_bal_tbl(p_balance_type_id).bal_type_id :=
168: p_balance_type_id;
169: pay_mx_utility.hours_bal_tbl(p_balance_type_id).hours_bal_type_id :=
170: ln_hours_bal_type_id;
171: pay_mx_utility.hours_bal_tbl(p_balance_type_id).hours_bal_uom :=
172: lv_balance_uom;
173:

Line 171: pay_mx_utility.hours_bal_tbl(p_balance_type_id).hours_bal_uom :=

167: pay_mx_utility.hours_bal_tbl(p_balance_type_id).bal_type_id :=
168: p_balance_type_id;
169: pay_mx_utility.hours_bal_tbl(p_balance_type_id).hours_bal_type_id :=
170: ln_hours_bal_type_id;
171: pay_mx_utility.hours_bal_tbl(p_balance_type_id).hours_bal_uom :=
172: lv_balance_uom;
173:
174: hr_utility.trace( 'HOURS BAL TYPE ID '||ln_hours_bal_type_id);
175:

Line 179: pay_mx_utility.hours_bal_tbl(p_balance_type_id).hours_bal_type_id;

175:
176: END IF;
177:
178: ln_hours_bal_type_id :=
179: pay_mx_utility.hours_bal_tbl(p_balance_type_id).hours_bal_type_id;
180: lv_balance_uom :=
181: pay_mx_utility.hours_bal_tbl(p_balance_type_id).hours_bal_uom;
182:
183: return ln_hours_bal_type_id;

Line 181: pay_mx_utility.hours_bal_tbl(p_balance_type_id).hours_bal_uom;

177:
178: ln_hours_bal_type_id :=
179: pay_mx_utility.hours_bal_tbl(p_balance_type_id).hours_bal_type_id;
180: lv_balance_uom :=
181: pay_mx_utility.hours_bal_tbl(p_balance_type_id).hours_bal_uom;
182:
183: return ln_hours_bal_type_id;
184:
185: END get_hours_bal_type_id;

Line 1197: g_package_name := 'pay_mx_utility.';

1193:
1194:
1195: BEGIN
1196:
1197: g_package_name := 'pay_mx_utility.';
1198: g_debug := hr_utility.debug_enabled;
1199:
1200: END pay_mx_utility;

Line 1200: END pay_mx_utility;

1196:
1197: g_package_name := 'pay_mx_utility.';
1198: g_debug := hr_utility.debug_enabled;
1199:
1200: END pay_mx_utility;