[Home] [Help]
391: -- Create the assignment action to represnt the person combination.
392: --
393: SELECT PAY_ASSIGNMENT_ACTIONS_S.NEXTVAL
394: INTO LOCKINGACTID
395: FROM DUAL;
396: --
397: -- insert into pay_assignment_actions.
398: --
399: hr_nonrun_asact.insact(lockingactid => lockingactid,
414: -- Create the assignment action to represnt the person combination.
415: --
416: SELECT PAY_ASSIGNMENT_ACTIONS_S.NEXTVAL
417: INTO LOCKINGACTID
418: FROM DUAL;
419: --
420: -- insert into pay_assignment_actions.
421: --
422: hr_nonrun_asact.insact(lockingactid => lockingactid,
1607: select p_person_id, p_business_group_id,
1608: p_request_id, p_error_desc,
1609: p_attr_category,fnd_global.user_id,
1610: sysdate, fnd_global.user_id,sysdate, fnd_global.login_id
1611: from dual;
1612: --
1613: END IF;
1614: --
1615: commit; --pragma commit
1827: DECODE (INSTR(l_dff_attr_str, 'ATTRIBUTE28,') ,0,'', per_rec.ATTRIBUTE28)||
1828: DECODE (INSTR(l_dff_attr_str, 'ATTRIBUTE29,') ,0,'', per_rec.ATTRIBUTE29)||
1829: DECODE (INSTR(l_dff_attr_str, 'ATTRIBUTE30,') ,0,'', per_rec.ATTRIBUTE30)
1830: INTO l_this_per_attr_str
1831: FROM DUAL;
1832: --
1833: -- If no attributes are found then assign a comma to the string
1834: -- in order to avoid comparison failure due to a null value.
1835: --
2244: select l_mig_rec.person_id, l_mig_rec.business_group_id,
2245: g_request_id, substr(l_error_code||l_error_desc,1,990),
2246: l_mig_rec.ATTRIBUTE_CATEGORY,fnd_global.user_id,
2247: sysdate, fnd_global.user_id,sysdate, fnd_global.login_id
2248: from dual;
2249: --
2250: END IF;
2251: --
2252: */
2323: g_request_id, 'FAILED',
2324: null,fnd_global.user_id,
2325: sysdate, fnd_global.user_id,sysdate,
2326: fnd_global.login_id
2327: from dual;
2328: --
2329: END IF;
2330: --
2331: ELSE
2352: g_request_id, 'SUCCESS',
2353: null,fnd_global.user_id,
2354: sysdate, fnd_global.user_id,sysdate,
2355: fnd_global.login_id
2356: from dual;
2357: --
2358: END IF;
2359: END IF;
2360: --
2480: PROCEDURE populate_mapping_tables IS
2481: --
2482: CURSOR csr_already_populated IS
2483: SELECT 'Y'
2484: FROM DUAL
2485: WHERE EXISTS
2486: (SELECT NULL
2487: FROM PER_PTU_DFF_MAPPING_HEADERS
2488: );