APPS.PA_PROJECT_ROLE_TYPES_PKG dependencies on PA_PROJECT_ROLE_TYPES_B

Line 46: cursor C is select ROWID from PA_PROJECT_ROLE_TYPES_B

42: X_STATUS_LEVEL IN VARCHAR2
43: ) IS
44:
45:
46: cursor C is select ROWID from PA_PROJECT_ROLE_TYPES_B
47: where PROJECT_ROLE_ID = X_PROJECT_ROLE_ID
48: ;
49:
50:

Line 54: insert into PA_PROJECT_ROLE_TYPES_B (

50:
51:
52: BEGIN
53:
54: insert into PA_PROJECT_ROLE_TYPES_B (
55: PROJECT_ROLE_TYPE,
56: QUERY_LABOR_COST_FLAG,
57: START_DATE_ACTIVE,
58: END_DATE_ACTIVE,

Line 180: FROM pa_project_role_types_b

176:
177: CURSOR c
178: IS
179: SELECT *
180: FROM pa_project_role_types_b
181: WHERE rowid = X_Rowid
182: FOR UPDATE OF project_role_id NOWAIT;
183:
184: Recinfo c%ROWTYPE;

Line 259: update PA_PROJECT_ROLE_TYPES_B set

255:
256:
257: BEGIN
258: --dbms_output.put_line('check 100');
259: update PA_PROJECT_ROLE_TYPES_B set
260: PROJECT_ROLE_TYPE = X_PROJECT_ROLE_TYPE,
261: QUERY_LABOR_COST_FLAG = X_QUERY_LABOR_COST_FLAG,
262: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
263: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 326: FROM pa_project_role_types_b

322:
323: BEGIN
324:
325: SELECT project_role_id INTO x_project_role_id
326: FROM pa_project_role_types_b
327: WHERE ROWID = x_rowid;
328:
329:
330: delete from PA_PROJECT_ROLE_TYPES_TL

Line 337: delete from PA_PROJECT_ROLE_TYPES_B

333: if (sql%notfound) then
334: raise no_data_found;
335: end if;
336:
337: delete from PA_PROJECT_ROLE_TYPES_B
338: where PROJECT_ROLE_ID = X_PROJECT_ROLE_ID;
339:
340: if (sql%notfound) then
341: raise no_data_found;

Line 354: from PA_PROJECT_ROLE_TYPES_B B

350: begin
351: delete from PA_PROJECT_ROLE_TYPES_TL T
352: where not exists
353: (select NULL
354: from PA_PROJECT_ROLE_TYPES_B B
355: where B.PROJECT_ROLE_ID = T.PROJECT_ROLE_ID
356: );
357:
358: update PA_PROJECT_ROLE_TYPES_TL T set (