APPS.PA_WORK_TYPES_PKG dependencies on PA_WORK_TYPES_B

Line 42: cursor C is select ROWID from PA_WORK_TYPES_B

38: X_TP_AMT_TYPE_CODE in VARCHAR2,
39: X_UNASSIGNED_FLAG in VARCHAR2
40: ) is
41:
42: cursor C is select ROWID from PA_WORK_TYPES_B
43: where WORK_TYPE_ID = X_WORK_TYPE_ID
44: ;
45: /** Added thses variables for PJI changes **/
46: l_pji_rowid VARCHAR2(1000);

Line 51: insert into PA_WORK_TYPES_B (

47: l_pji_event_id NUMBER;
48:
49: begin
50:
51: insert into PA_WORK_TYPES_B (
52: ATTRIBUTE3,
53: ATTRIBUTE4,
54: ATTRIBUTE5,
55: ATTRIBUTE6,

Line 122: ** for every insert/update/delete in pa_work_types_b **/

118: X_UNASSIGNED_FLAG
119: );
120:
121: /** If PJI is installed then we need to insert record into PA_PJI_PROJ_EVENTS_LOG table
122: ** for every insert/update/delete in pa_work_types_b **/
123: IF ((sql%rowcount > 0) AND (NVL(PA_INSTALL.is_pji_licensed(),'N')='Y')) THEN
124: l_pji_rowid := null;
125: l_pji_event_id := null;
126:

Line 265: from PA_WORK_TYPES_B

261: ATTRIBUTE2,
262: TRAINING_FLAG,
263: TP_AMT_TYPE_CODE,
264: UNASSIGNED_FLAG
265: from PA_WORK_TYPES_B
266: where WORK_TYPE_ID = X_WORK_TYPE_ID
267: for update of WORK_TYPE_ID nowait;
268: recinfo c%rowtype;
269:

Line 420: FROM pa_work_types_b

416: ,START_DATE_ACTIVE
417: ,END_DATE_ACTIVE
418: ,RES_UTIL_CATEGORY_ID
419: ,ORG_UTIL_CATEGORY_ID
420: FROM pa_work_types_b
421: WHERE work_type_id = X_WORK_TYPE_ID;
422:
423: l_wt_old old_worktype_values%ROWTYPE;
424: l_sql_rowcount number;

Line 432: update PA_WORK_TYPES_B set

428: OPEN old_worktype_values;
429: FETCH old_worktype_values INTO l_wt_old;
430: IF old_worktype_values%FOUND then
431:
432: update PA_WORK_TYPES_B set
433: ATTRIBUTE3 = X_ATTRIBUTE3,
434: ATTRIBUTE4 = X_ATTRIBUTE4,
435: ATTRIBUTE5 = X_ATTRIBUTE5,
436: ATTRIBUTE6 = X_ATTRIBUTE6,

Line 468: ** for every insert/update/delete in pa_work_types_b **/

464:
465: l_sql_rowcount := sql%rowcount;
466:
467: /** If PJI is installed then we need to insert record into PA_PJI_PROJ_EVENTS_LOG table
468: ** for every insert/update/delete in pa_work_types_b **/
469: IF ((l_sql_rowcount > 0) AND (NVL(PA_INSTALL.is_pji_licensed(),'N')='Y')) THEN
470: l_pji_rowid := null;
471: l_pji_event_id := null;
472:

Line 558: FROM pa_work_types_b

554: ,START_DATE_ACTIVE
555: ,END_DATE_ACTIVE
556: ,RES_UTIL_CATEGORY_ID
557: ,ORG_UTIL_CATEGORY_ID
558: FROM pa_work_types_b
559: WHERE work_type_id = X_WORK_TYPE_ID;
560:
561: l_wt_old old_worktype_values%ROWTYPE;
562: l_sql_rowcount Number ;

Line 576: ** for every insert/update/delete in pa_work_types_b **/

572:
573: l_sql_rowcount := sql%rowcount ;
574:
575: /** If PJI is installed then we need to insert record into PA_PJI_PROJ_EVENTS_LOG table
576: ** for every insert/update/delete in pa_work_types_b **/
577: IF ((l_sql_rowcount > 0) AND (NVL(PA_INSTALL.is_pji_licensed(),'N')='Y')) THEN
578: l_pji_rowid := null;
579: l_pji_event_id := null;
580:

Line 619: delete from PA_WORK_TYPES_B

615: if (l_sql_rowcount <= 0 ) then
616: raise no_data_found;
617: end if;
618:
619: delete from PA_WORK_TYPES_B
620: where WORK_TYPE_ID = X_WORK_TYPE_ID;
621:
622: if (sql%notfound) then
623: raise no_data_found;

Line 643: from PA_WORK_TYPES_B B

639:
640: delete from PA_WORK_TYPES_TL T
641: where not exists
642: (select NULL
643: from PA_WORK_TYPES_B B
644: where B.WORK_TYPE_ID = T.WORK_TYPE_ID
645: );
646:
647: update PA_WORK_TYPES_TL T set (