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 47: insert into PA_ROLE_JOB_BGS (

43: -- hr_utility.trace('P_LAST_UPDATE_LOGIN IS : ' || P_LAST_UPDATE_LOGIN);
44:
45: if P_JOB_ID is not null
46: then
47: insert into PA_ROLE_JOB_BGS (
48: ROLE_JOB_BG_ID,
49: PROJECT_ROLE_ID,
50: BUSINESS_GROUP_ID,
51: JOB_ID,

Line 93: FROM PA_ROLE_JOB_BGS

89:
90: CURSOR c
91: IS
92: SELECT *
93: FROM PA_ROLE_JOB_BGS
94: WHERE ROLE_JOB_BG_ID = P_ROLE_JOB_BG_ID
95: FOR UPDATE NOWAIT;
96:
97: Recinfo c%ROWTYPE;

Line 154: update PA_ROLE_JOB_BGS

150: p_object_version_number := p_object_version_number + 1;
151:
152: if P_JOB_ID is not null
153: then
154: update PA_ROLE_JOB_BGS
155: set
156: BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID,
157: JOB_ID = P_JOB_ID,
158: MIN_JOB_LEVEL = P_MIN_JOB_LEVEL,

Line 194: delete from PA_ROLE_JOB_BGS

190: P_ROLE_JOB_BG_ID,
191: P_OBJECT_VERSION_NUMBER
192: );
193:
194: delete from PA_ROLE_JOB_BGS
195: where ROLE_JOB_BG_ID = P_ROLE_JOB_BG_ID;
196:
197: if (sql%notfound) then
198: raise no_data_found;