APPS.PA_ROLE_JOB_BG_PKG dependencies on PA_ROLE_JOB_BGS

Line 26: select PA_ROLE_JOB_BGS_S.nextval

22: -- Initialize object version number.
23: p_object_version_number := 1;
24:
25: -- Get the next sequence number for the primary key.
26: select PA_ROLE_JOB_BGS_S.nextval
27: into P_ROLE_JOB_BG_ID
28: from sys.dual;
29:
30: -- hr_utility.trace('before insert');

Line 45: insert into PA_ROLE_JOB_BGS (

41: -- hr_utility.trace('P_LAST_UPDATE_DATE IS : ' || P_LAST_UPDATE_DATE);
42: -- hr_utility.trace('P_LAST_UPDATED_BY IS : ' || P_LAST_UPDATED_BY);
43: -- hr_utility.trace('P_LAST_UPDATE_LOGIN IS : ' || P_LAST_UPDATE_LOGIN);
44:
45: insert into PA_ROLE_JOB_BGS (
46: ROLE_JOB_BG_ID,
47: PROJECT_ROLE_ID,
48: BUSINESS_GROUP_ID,
49: JOB_ID,

Line 86: FROM PA_ROLE_JOB_BGS

82:
83: CURSOR c
84: IS
85: SELECT *
86: FROM PA_ROLE_JOB_BGS
87: WHERE ROLE_JOB_BG_ID = P_ROLE_JOB_BG_ID
88: FOR UPDATE NOWAIT;
89:
90: Recinfo c%ROWTYPE;

Line 145: update PA_ROLE_JOB_BGS

141:
142: -- Increment the object version number.
143: p_object_version_number := p_object_version_number + 1;
144:
145: update PA_ROLE_JOB_BGS
146: set
147: BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID,
148: JOB_ID = P_JOB_ID,
149: MIN_JOB_LEVEL = P_MIN_JOB_LEVEL,

Line 180: delete from PA_ROLE_JOB_BGS

176: P_ROLE_JOB_BG_ID,
177: P_OBJECT_VERSION_NUMBER
178: );
179:
180: delete from PA_ROLE_JOB_BGS
181: where ROLE_JOB_BG_ID = P_ROLE_JOB_BG_ID;
182:
183: if (sql%notfound) then
184: raise no_data_found;