APPS.IGS_AD_PRCS_CAT_STEP_PKG dependencies on IGS_AD_PRCS_CAT

Line 1: package body IGS_AD_PRCS_CAT_STEP_PKG AS

1: package body IGS_AD_PRCS_CAT_STEP_PKG AS
2: /* $Header: IGSAI37B.pls 115.23 2003/10/30 13:20:14 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_PRCS_CAT_STEP_ALL%RowType;
5: new_references IGS_AD_PRCS_CAT_STEP_ALL%RowType;

Line 4: old_references IGS_AD_PRCS_CAT_STEP_ALL%RowType;

1: package body IGS_AD_PRCS_CAT_STEP_PKG AS
2: /* $Header: IGSAI37B.pls 115.23 2003/10/30 13:20:14 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_PRCS_CAT_STEP_ALL%RowType;
5: new_references IGS_AD_PRCS_CAT_STEP_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_AD_PRCS_CAT_STEP_ALL%RowType;

1: package body IGS_AD_PRCS_CAT_STEP_PKG AS
2: /* $Header: IGSAI37B.pls 115.23 2003/10/30 13:20:14 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_PRCS_CAT_STEP_ALL%RowType;
5: new_references IGS_AD_PRCS_CAT_STEP_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,

Line 27: FROM IGS_AD_PRCS_CAT_STEP_ALL

23: ) AS
24:
25: CURSOR cur_old_ref_values IS
26: SELECT *
27: FROM IGS_AD_PRCS_CAT_STEP_ALL
28: WHERE rowid = x_rowid;
29:
30: BEGIN
31:

Line 88: -- ON IGS_AD_PRCS_CAT_STEP

84:
85: -- Trigger description :-
86: -- "OSS_TST".trg_apcs_br_iud
87: -- BEFORE INSERT OR DELETE OR UPDATE
88: -- ON IGS_AD_PRCS_CAT_STEP
89: -- FOR EACH ROW
90:
91: PROCEDURE BeforeRowInsertUpdateDelete1(
92: p_inserting IN BOOLEAN ,

Line 96: v_admission_cat IGS_AD_PRCS_CAT.admission_cat%TYPE;

92: p_inserting IN BOOLEAN ,
93: p_updating IN BOOLEAN ,
94: p_deleting IN BOOLEAN
95: ) AS
96: v_admission_cat IGS_AD_PRCS_CAT.admission_cat%TYPE;
97: v_message_name VARCHAR2(30);
98: BEGIN
99:
100: IF NVL(new_references.step_group_type,'TRACK') <> 'TRACK' THEN

Line 317: IF NOT IGS_AD_PRCS_CAT_PKG.Get_PK_For_Validation (

313: ((new_references.admission_cat IS NULL) OR
314: (new_references.s_admission_process_type IS NULL))) THEN
315: NULL;
316: ELSE
317: IF NOT IGS_AD_PRCS_CAT_PKG.Get_PK_For_Validation (
318: new_references.admission_cat,
319: new_references.s_admission_process_type,
320: 'N'
321: ) THEN

Line 362: FROM IGS_AD_PRCS_CAT_STEP_ALL

358: AS
359:
360: CURSOR cur_rowid IS
361: SELECT rowid
362: FROM IGS_AD_PRCS_CAT_STEP_ALL
363: WHERE admission_cat = x_admission_cat
364: AND s_admission_process_type = x_s_admission_process_type
365: AND s_admission_step_type = x_s_admission_step_type
366: AND step_group_type = x_step_group_type

Line 384: PROCEDURE GET_FK_IGS_AD_PRCS_CAT (

380: Return (FALSE);
381: END IF;
382: END Get_PK_For_Validation;
383:
384: PROCEDURE GET_FK_IGS_AD_PRCS_CAT (
385: x_admission_cat IN VARCHAR2,
386: x_s_admission_process_type IN VARCHAR2
387: ) AS
388:

Line 391: FROM IGS_AD_PRCS_CAT_STEP_ALL

387: ) AS
388:
389: CURSOR cur_rowid IS
390: SELECT rowid
391: FROM IGS_AD_PRCS_CAT_STEP_ALL
392: WHERE admission_cat = x_admission_cat
393: AND s_admission_process_type = x_s_admission_process_type ;
394:
395: lv_rowid cur_rowid%RowType;

Line 410: END GET_FK_IGS_AD_PRCS_CAT;

406: Return;
407: END IF;
408: Close cur_rowid;
409:
410: END GET_FK_IGS_AD_PRCS_CAT;
411:
412: PROCEDURE GET_FK_IGS_LOOKUPS_VIEW(
413: x_s_admission_step_type IN VARCHAR2
414: ) AS

Line 418: FROM IGS_AD_PRCS_CAT_STEP_ALL

414: ) AS
415:
416: CURSOR cur_rowid IS
417: SELECT rowid
418: FROM IGS_AD_PRCS_CAT_STEP_ALL
419: WHERE s_admission_step_type = x_s_admission_step_type
420: AND step_group_type <> 'TRACK';
421:
422: lv_rowid cur_rowid%RowType;

Line 545: cursor C is select ROWID from IGS_AD_PRCS_CAT_STEP_ALL

541: -- the value of function igs_ge_gen_003.get_org_id
542: -- as part of SWCR006 build.
543: ---------------------------------------------------------------------------------------*/
544:
545: cursor C is select ROWID from IGS_AD_PRCS_CAT_STEP_ALL
546: where ADMISSION_CAT = X_ADMISSION_CAT
547: and S_ADMISSION_PROCESS_TYPE = X_S_ADMISSION_PROCESS_TYPE
548: and S_ADMISSION_STEP_TYPE = X_S_ADMISSION_STEP_TYPE
549: and STEP_GROUP_TYPE = X_STEP_GROUP_TYPE;

Line 589: insert into IGS_AD_PRCS_CAT_STEP_ALL (

585: x_last_updated_by => X_LAST_UPDATED_BY,
586: x_last_update_login => X_LAST_UPDATE_LOGIN
587: );
588:
589: insert into IGS_AD_PRCS_CAT_STEP_ALL (
590: ORG_ID,
591: ADMISSION_CAT,
592: S_ADMISSION_PROCESS_TYPE,
593: S_ADMISSION_STEP_TYPE,

Line 646: from IGS_AD_PRCS_CAT_STEP_ALL

642: cursor c1 is select
643: MANDATORY_STEP_IND,
644: STEP_TYPE_RESTRICTION_NUM,
645: STEP_ORDER_NUM
646: from IGS_AD_PRCS_CAT_STEP_ALL
647: where ROWID = X_ROWID for update nowait;
648: tlinfo c1%rowtype;
649:
650: begin

Line 736: update IGS_AD_PRCS_CAT_STEP_ALL set

732: x_last_updated_by => X_LAST_UPDATED_BY,
733: x_last_update_login => X_LAST_UPDATE_LOGIN
734: );
735:
736: update IGS_AD_PRCS_CAT_STEP_ALL set
737: MANDATORY_STEP_IND = NEW_REFERENCES.MANDATORY_STEP_IND,
738: STEP_TYPE_RESTRICTION_NUM = NEW_REFERENCES.STEP_TYPE_RESTRICTION_NUM,
739: STEP_ORDER_NUM = NEW_REFERENCES.STEP_ORDER_NUM,
740: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 766: cursor c1 is select rowid from IGS_AD_PRCS_CAT_STEP_ALL

762: X_STEP_ORDER_NUM in NUMBER,
763: X_STEP_GROUP_TYPE in VARCHAR2,
764: X_MODE in VARCHAR2
765: ) AS
766: cursor c1 is select rowid from IGS_AD_PRCS_CAT_STEP_ALL
767: where ADMISSION_CAT = X_ADMISSION_CAT
768: and S_ADMISSION_PROCESS_TYPE = X_S_ADMISSION_PROCESS_TYPE
769: and S_ADMISSION_STEP_TYPE = X_S_ADMISSION_STEP_TYPE
770: and step_group_Type = X_STEP_GROUP_TYPE ;

Line 811: delete from IGS_AD_PRCS_CAT_STEP_ALL

807: x_rowid => X_ROWID,
808: x_org_id => NULL
809: );
810:
811: delete from IGS_AD_PRCS_CAT_STEP_ALL
812: where ROWID = X_ROWID;
813: if (sql%notfound) then
814: raise no_data_found;
815: end if;

Line 822: end IGS_AD_PRCS_CAT_STEP_PKG;

818: x_rowid => X_ROWID
819: );
820: end DELETE_ROW;
821:
822: end IGS_AD_PRCS_CAT_STEP_PKG;