APPS.HR_ORG_INFORMATION_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 144: from hr_organization_information

140:
141: )
142: IS
143: select 'Y'
144: from hr_organization_information
145: where ORG_INFORMATION_CONTEXT like p_org_information_context
146: and org_information1 = p_org_information1
147: and organization_id = p_organization_id
148: ;

Line 270: CURSOR C (p_org_info_id number)IS SELECT rowid FROM HR_ORGANIZATION_INFORMATION

266: X_Attribute19 VARCHAR2,
267: X_Attribute20 VARCHAR2
268: ) IS
269:
270: CURSOR C (p_org_info_id number)IS SELECT rowid FROM HR_ORGANIZATION_INFORMATION
271: WHERE org_information_id = p_org_info_id;
272:
273: CURSOR C2 IS SELECT hr_organization_information_s.nextval FROM sys.dual;
274: l_rowid varchar2(255);

Line 273: CURSOR C2 IS SELECT hr_organization_information_s.nextval FROM sys.dual;

269:
270: CURSOR C (p_org_info_id number)IS SELECT rowid FROM HR_ORGANIZATION_INFORMATION
271: WHERE org_information_id = p_org_info_id;
272:
273: CURSOR C2 IS SELECT hr_organization_information_s.nextval FROM sys.dual;
274: l_rowid varchar2(255);
275: l_org_information_id hr_organization_information.organization_id%type;
276: BEGIN
277:

Line 275: l_org_information_id hr_organization_information.organization_id%type;

271: WHERE org_information_id = p_org_info_id;
272:
273: CURSOR C2 IS SELECT hr_organization_information_s.nextval FROM sys.dual;
274: l_rowid varchar2(255);
275: l_org_information_id hr_organization_information.organization_id%type;
276: BEGIN
277:
278: if (X_Org_Information_Id is NULL) then
279: OPEN C2;

Line 284: hr_utility.set_location('HR_ORGANIZATION_INFORMATION',1);

280: FETCH C2 INTO l_Org_Information_Id;
281: CLOSE C2;
282: x_org_information_id := l_org_information_id;
283: end if;
284: hr_utility.set_location('HR_ORGANIZATION_INFORMATION',1);
285:
286: if X_org_information_context = 'FR_ESTAB_INFO' then
287: Validate_SIRET(X_SIRET => X_org_information2);
288: elsif X_org_information_context = 'FR_ESTAB_PREV_INFO' then

Line 313: INSERT INTO HR_ORGANIZATION_INFORMATION(

309: ,p_org_information1 => X_Org_Information1
310: );
311: End if ;
312:
313: INSERT INTO HR_ORGANIZATION_INFORMATION(
314: org_information_id,
315: org_information_context,
316: organization_id,
317: org_information1,

Line 405: hr_utility.set_location('HR_ORGANIZATION_INFORMATION',2);

401: X_Attribute19,
402: X_Attribute20
403:
404: );
405: hr_utility.set_location('HR_ORGANIZATION_INFORMATION',2);
406: OPEN C (l_org_information_id);
407: FETCH C INTO l_Rowid;
408: if (C%NOTFOUND) then
409: CLOSE C;

Line 468: FROM HR_ORGANIZATION_INFORMATION

464: X_Attribute20 VARCHAR2
465: ) IS
466: CURSOR C IS
467: SELECT *
468: FROM HR_ORGANIZATION_INFORMATION
469: WHERE rowid = X_Rowid
470: FOR UPDATE of Org_Information_Id NOWAIT;
471: Recinfo C%ROWTYPE;
472: BEGIN

Line 728: hr_organization_information

724: select
725: org_information1,
726: org_information8
727: from
728: hr_organization_information
729: where
730: org_information_id = X_org_information_id;
731: --
732: CURSOR check_override IS

Line 823: UPDATE HR_ORGANIZATION_INFORMATION

819: );
820: End if ;
821:
822: --
823: UPDATE HR_ORGANIZATION_INFORMATION
824: SET
825: org_information_id = X_Org_Information_Id,
826: org_information_context = X_Org_Information_Context,
827: organization_id = X_Organization_Id,

Line 884: DELETE FROM HR_ORGANIZATION_INFORMATION

880:
881:
882: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
883: BEGIN
884: DELETE FROM HR_ORGANIZATION_INFORMATION
885: WHERE rowid = X_Rowid;
886:
887: if (SQL%NOTFOUND) then
888: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');