APPS.IGS_AS_UNTAS_PATTERN_PKG dependencies on IGS_AS_UNTAS_PATTERN_ALL

Line 6: old_references IGS_AS_UNTAS_PATTERN_ALL%RowType;

2: /* $Header: IGSDI33B.pls 120.0 2005/07/05 12:26:53 appldev noship $ */
3:
4: --
5: l_rowid VARCHAR2(25);
6: old_references IGS_AS_UNTAS_PATTERN_ALL%RowType;
7: new_references IGS_AS_UNTAS_PATTERN_ALL%RowType;
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 7: new_references IGS_AS_UNTAS_PATTERN_ALL%RowType;

3:
4: --
5: l_rowid VARCHAR2(25);
6: old_references IGS_AS_UNTAS_PATTERN_ALL%RowType;
7: new_references IGS_AS_UNTAS_PATTERN_ALL%RowType;
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,
11: x_unit_cd IN VARCHAR2 DEFAULT NULL,

Line 33: FROM IGS_AS_UNTAS_PATTERN_ALL

29: x_org_id IN NUMBER DEFAULT NULL
30: ) as
31: CURSOR cur_old_ref_values IS
32: SELECT *
33: FROM IGS_AS_UNTAS_PATTERN_ALL
34: WHERE rowid = x_rowid;
35: BEGIN
36: l_rowid := x_rowid;
37: -- Code for setting the Old and New Reference Values.

Line 456: FROM IGS_AS_UNTAS_PATTERN_ALL

452: x_ass_pattern_id IN NUMBER
453: ) RETURN BOOLEAN AS
454: CURSOR cur_rowid IS
455: SELECT rowid
456: FROM IGS_AS_UNTAS_PATTERN_ALL
457: WHERE unit_cd = x_unit_cd
458: AND version_number = x_version_number
459: AND cal_type= x_cal_type
460: AND ci_sequence_number = x_ci_sequence_number

Line 482: FROM IGS_AS_UNTAS_PATTERN_ALL

478: x_ass_pattern_id IN NUMBER
479: ) RETURN BOOLEAN AS
480: CURSOR cur_rowid IS
481: SELECT rowid
482: FROM IGS_AS_UNTAS_PATTERN_ALL
483: WHERE ass_pattern_id = x_ass_pattern_id
484: AND ((l_rowid IS NULL) OR (rowid <> l_rowid))
485:
486: FOR UPDATE NOWAIT;

Line 505: FROM IGS_AS_UNTAS_PATTERN_ALL

501: x_location_cd IN VARCHAR2
502: ) as
503: CURSOR cur_rowid IS
504: SELECT rowid
505: FROM IGS_AS_UNTAS_PATTERN_ALL
506: WHERE location_cd = x_location_cd ;
507: lv_rowid cur_rowid%RowType;
508: BEGIN
509: Open cur_rowid;

Line 525: FROM IGS_AS_UNTAS_PATTERN_ALL

521: x_unit_class IN VARCHAR2
522: ) as
523: CURSOR cur_rowid IS
524: SELECT rowid
525: FROM IGS_AS_UNTAS_PATTERN_ALL
526: WHERE unit_class= x_unit_class ;
527: lv_rowid cur_rowid%RowType;
528: BEGIN
529: Open cur_rowid;

Line 545: FROM IGS_AS_UNTAS_PATTERN_ALL

541: x_unit_mode IN VARCHAR2
542: ) as
543: CURSOR cur_rowid IS
544: SELECT rowid
545: FROM IGS_AS_UNTAS_PATTERN_ALL
546: WHERE unit_mode= x_unit_mode ;
547: lv_rowid cur_rowid%RowType;
548: BEGIN
549: Open cur_rowid;

Line 568: FROM IGS_AS_UNTAS_PATTERN_ALL

564: x_ci_sequence_number IN NUMBER
565: ) as
566: CURSOR cur_rowid IS
567: SELECT rowid
568: FROM IGS_AS_UNTAS_PATTERN_ALL
569: WHERE unit_cd = x_unit_cd
570: AND version_number = x_version_number
571: AND cal_type= x_cal_type
572: AND ci_sequence_number = x_ci_sequence_number ;

Line 720: cursor C is select ROWID from IGS_AS_UNTAS_PATTERN_ALL

716: X_ACTION_DT in DATE,
717: X_MODE in VARCHAR2 default 'R',
718: X_ORG_ID IN NUMBER
719: ) as
720: cursor C is select ROWID from IGS_AS_UNTAS_PATTERN_ALL
721: where UNIT_CD = X_UNIT_CD
722: and VERSION_NUMBER = X_VERSION_NUMBER
723: and CAL_TYPE = X_CAL_TYPE
724: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER

Line 788: insert into IGS_AS_UNTAS_PATTERN_ALL (

784: x_last_update_login=>X_LAST_UPDATE_LOGIN,
785: x_org_id => igs_ge_gen_003.get_org_id
786: );
787: --
788: insert into IGS_AS_UNTAS_PATTERN_ALL (
789: UNIT_CD,
790: VERSION_NUMBER,
791: CAL_TYPE,
792: CI_SEQUENCE_NUMBER,

Line 876: from IGS_AS_UNTAS_PATTERN_ALL

872: UNIT_MODE,
873: DFLT_PATTERN_IND,
874: LOGICAL_DELETE_DT,
875: ACTION_DT
876: from IGS_AS_UNTAS_PATTERN_ALL
877: where ROWID = X_ROWID for update nowait;
878: tlinfo c1%rowtype;
879: begin
880: open c1;

Line 997: update IGS_AS_UNTAS_PATTERN_ALL set

993: end if;
994: --
995: --
996: end if;
997: update IGS_AS_UNTAS_PATTERN_ALL set
998: ASS_PATTERN_CD = NEW_REFERENCES.ASS_PATTERN_CD,
999: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
1000: LOCATION_CD = NEW_REFERENCES.LOCATION_CD,
1001: UNIT_CLASS = NEW_REFERENCES.UNIT_CLASS,

Line 1042: cursor c1 is select rowid from IGS_AS_UNTAS_PATTERN_ALL

1038: X_ACTION_DT in DATE,
1039: X_MODE in VARCHAR2 default 'R',
1040: X_ORG_ID IN NUMBER
1041: ) as
1042: cursor c1 is select rowid from IGS_AS_UNTAS_PATTERN_ALL
1043: where UNIT_CD = X_UNIT_CD
1044: and VERSION_NUMBER = X_VERSION_NUMBER
1045: and CAL_TYPE = X_CAL_TYPE
1046: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER

Line 1100: delete from IGS_AS_UNTAS_PATTERN_ALL

1096: p_action => 'DELETE',
1097: x_rowid => X_ROWID
1098: );
1099: --
1100: delete from IGS_AS_UNTAS_PATTERN_ALL
1101: where ROWID = X_ROWID;
1102: if (sql%notfound) then
1103: raise no_data_found;
1104: end if;