APPS.HR_EMPLOYEE_SWI dependencies on HR_ORGANIZATION_INFORMATION

Line 1372: org_id HR_ORGANIZATION_INFORMATION.Organization_id%TYPE,

1368: PRAGMA EXCEPTION_INIT(e_ResourceBusy, -54);
1369:
1370: TYPE t_bgRecord IS RECORD
1371: (
1372: org_id HR_ORGANIZATION_INFORMATION.Organization_id%TYPE,
1373: emp_method HR_ORGANIZATION_INFORMATION.Org_information2%TYPE,
1374: apl_method HR_ORGANIZATION_INFORMATION.Org_information3%TYPE,
1375: cwk_method HR_ORGANIZATION_INFORMATION.Org_information16%TYPE
1376: );

Line 1373: emp_method HR_ORGANIZATION_INFORMATION.Org_information2%TYPE,

1369:
1370: TYPE t_bgRecord IS RECORD
1371: (
1372: org_id HR_ORGANIZATION_INFORMATION.Organization_id%TYPE,
1373: emp_method HR_ORGANIZATION_INFORMATION.Org_information2%TYPE,
1374: apl_method HR_ORGANIZATION_INFORMATION.Org_information3%TYPE,
1375: cwk_method HR_ORGANIZATION_INFORMATION.Org_information16%TYPE
1376: );
1377:

Line 1374: apl_method HR_ORGANIZATION_INFORMATION.Org_information3%TYPE,

1370: TYPE t_bgRecord IS RECORD
1371: (
1372: org_id HR_ORGANIZATION_INFORMATION.Organization_id%TYPE,
1373: emp_method HR_ORGANIZATION_INFORMATION.Org_information2%TYPE,
1374: apl_method HR_ORGANIZATION_INFORMATION.Org_information3%TYPE,
1375: cwk_method HR_ORGANIZATION_INFORMATION.Org_information16%TYPE
1376: );
1377:
1378: l_message varchar2(200) := null;

Line 1375: cwk_method HR_ORGANIZATION_INFORMATION.Org_information16%TYPE

1371: (
1372: org_id HR_ORGANIZATION_INFORMATION.Organization_id%TYPE,
1373: emp_method HR_ORGANIZATION_INFORMATION.Org_information2%TYPE,
1374: apl_method HR_ORGANIZATION_INFORMATION.Org_information3%TYPE,
1375: cwk_method HR_ORGANIZATION_INFORMATION.Org_information16%TYPE
1376: );
1377:
1378: l_message varchar2(200) := null;
1379:

Line 1390: FROM hr_organization_information

1386: SELECT organization_id,
1387: org_information2,
1388: org_information3,
1389: org_information16
1390: FROM hr_organization_information
1391: WHERE organization_id = cp_bg_id
1392: AND ORG_INFORMATION_CONTEXT = 'Business Group Information'
1393: FOR UPDATE of Org_information3 -- method_of_generation_apl_num
1394: , Org_information2 -- method_of_generation_emp_num

Line 1426: UPDATE HR_ORGANIZATION_INFORMATION

1422: -- -------------------------------------------------------------+
1423:
1424: hr_utility.set_location(c_proc_name,40);
1425:
1426: UPDATE HR_ORGANIZATION_INFORMATION
1427: SET org_information2 = 'M' -- method_of_generation_emp_num
1428: /*,org_information3 = 'M' -- method_of_generation_apl_num
1429: ,org_information16 = 'M' -- method_of_generation_cwk_num
1430: */