APPS.PAY_AE_IV_MIGRATE_PKG dependencies on PAY_PATCH_STATUS

Line 18: /* Check if the entry for BG exists in pay_patch_status table */

14: ,retcode OUT NOCOPY VARCHAR2
15: ,p_business_group_id IN NUMBER) IS
16:
17:
18: /* Check if the entry for BG exists in pay_patch_status table */
19: CURSOR csr_pay_patch_status (l_number NUMBER) IS
20: SELECT PATCH_NUMBER
21: FROM PAY_PATCH_STATUS
22: WHERE PATCH_NUMBER = L_NUMBER

Line 19: CURSOR csr_pay_patch_status (l_number NUMBER) IS

15: ,p_business_group_id IN NUMBER) IS
16:
17:
18: /* Check if the entry for BG exists in pay_patch_status table */
19: CURSOR csr_pay_patch_status (l_number NUMBER) IS
20: SELECT PATCH_NUMBER
21: FROM PAY_PATCH_STATUS
22: WHERE PATCH_NUMBER = L_NUMBER
23: AND PATCH_NAME = 'AE_IV_MIGRATION'

Line 21: FROM PAY_PATCH_STATUS

17:
18: /* Check if the entry for BG exists in pay_patch_status table */
19: CURSOR csr_pay_patch_status (l_number NUMBER) IS
20: SELECT PATCH_NUMBER
21: FROM PAY_PATCH_STATUS
22: WHERE PATCH_NUMBER = L_NUMBER
23: AND PATCH_NAME = 'AE_IV_MIGRATION'
24: AND STATUS = 'C'
25: AND LEGISLATION_CODE = 'AE';

Line 165: OPEN csr_pay_patch_status (p_business_group_id);

161: BEGIN
162:
163: l_status := null;
164:
165: OPEN csr_pay_patch_status (p_business_group_id);
166: FETCH csr_pay_patch_status INTO l_status;
167: CLOSE csr_pay_patch_status;
168:
169: /* IF l_status <> p_business_group_id THEN*/

Line 166: FETCH csr_pay_patch_status INTO l_status;

162:
163: l_status := null;
164:
165: OPEN csr_pay_patch_status (p_business_group_id);
166: FETCH csr_pay_patch_status INTO l_status;
167: CLOSE csr_pay_patch_status;
168:
169: /* IF l_status <> p_business_group_id THEN*/
170: IF l_status IS NULL THEN

Line 167: CLOSE csr_pay_patch_status;

163: l_status := null;
164:
165: OPEN csr_pay_patch_status (p_business_group_id);
166: FETCH csr_pay_patch_status INTO l_status;
167: CLOSE csr_pay_patch_status;
168:
169: /* IF l_status <> p_business_group_id THEN*/
170: IF l_status IS NULL THEN
171:

Line 175: INSERT INTO PAY_PATCH_STATUS

171:
172: l_bg_id := p_business_group_id;
173: l_effective_date := to_date('01-11-2007','DD-MM-YYYY');
174:
175: INSERT INTO PAY_PATCH_STATUS
176: (ID,
177: PATCH_NUMBER,
178: PATCH_NAME,
179: STATUS,

Line 183: pay_patch_status_s.nextval,

179: STATUS,
180: APPLIED_DATE,
181: LEGISLATION_CODE)
182: SELECT
183: pay_patch_status_s.nextval,
184: p_business_group_id,
185: 'AE_IV_MIGRATION',
186: 'C',
187: sysdate,