APPS.CUG_SR_TASK_TYPE_DETS_PKG dependencies on CUG_SR_TASK_TYPE_DETS_B

Line 48: cursor C is select ROWID from CUG_SR_TASK_TYPE_DETS_B

44: X_LAST_UPDATE_DATE in DATE,
45: X_LAST_UPDATED_BY in NUMBER,
46: X_LAST_UPDATE_LOGIN in NUMBER
47: ) is
48: cursor C is select ROWID from CUG_SR_TASK_TYPE_DETS_B
49: where SR_TASK_TYPE_DET_ID = X_SR_TASK_TYPE_DET_ID
50: ;
51: begin
52: insert into CUG_SR_TASK_TYPE_DETS_B (

Line 52: insert into CUG_SR_TASK_TYPE_DETS_B (

48: cursor C is select ROWID from CUG_SR_TASK_TYPE_DETS_B
49: where SR_TASK_TYPE_DET_ID = X_SR_TASK_TYPE_DET_ID
50: ;
51: begin
52: insert into CUG_SR_TASK_TYPE_DETS_B (
53: ASSIGNED_BY_ID,
54: ASSIGNEE_TYPE_CODE,
55: TASK_PRIORITY_ID,
56: PLANNED_START_OFFSET,

Line 250: from CUG_SR_TASK_TYPE_DETS_B

246: PRIVATE_FLAG,
247: PUBLISH_FLAG,
248: ATTRIBUTE1,
249: ATTRIBUTE5
250: from CUG_SR_TASK_TYPE_DETS_B
251: where SR_TASK_TYPE_DET_ID = X_SR_TASK_TYPE_DET_ID
252: for update of SR_TASK_TYPE_DET_ID nowait;
253: recinfo c%rowtype;
254:

Line 402: update CUG_SR_TASK_TYPE_DETS_B set

398: X_LAST_UPDATED_BY in NUMBER,
399: X_LAST_UPDATE_LOGIN in NUMBER
400: ) is
401: begin
402: update CUG_SR_TASK_TYPE_DETS_B set
403: ASSIGNED_BY_ID = X_ASSIGNED_BY_ID,
404: ASSIGNEE_TYPE_CODE = X_ASSIGNEE_TYPE_CODE,
405: TASK_PRIORITY_ID = X_TASK_PRIORITY_ID,
406: PLANNED_START_OFFSET = X_PLANNED_START_OFFSET,

Line 472: delete from CUG_SR_TASK_TYPE_DETS_B

468: if (sql%notfound) then
469: raise no_data_found;
470: end if;
471:
472: delete from CUG_SR_TASK_TYPE_DETS_B
473: where SR_TASK_TYPE_DET_ID = X_SR_TASK_TYPE_DET_ID;
474:
475: if (sql%notfound) then
476: raise no_data_found;

Line 486: from CUG_SR_TASK_TYPE_DETS_B B

482: begin
483: delete from CUG_SR_TASK_TYPE_DETS_TL T
484: where not exists
485: (select NULL
486: from CUG_SR_TASK_TYPE_DETS_B B
487: where B.SR_TASK_TYPE_DET_ID = T.SR_TASK_TYPE_DET_ID
488: );
489:
490: update CUG_SR_TASK_TYPE_DETS_TL T set (