APPS.IGS_GR_AWD_CRM_UT_ST_PKG dependencies on IGS_GR_AWD_CRM_UT_ST

Line 1: package body IGS_GR_AWD_CRM_UT_ST_PKG as

1: package body IGS_GR_AWD_CRM_UT_ST_PKG as
2: /* $Header: IGSGI05B.pls 115.4 2002/11/29 00:34:43 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_GR_AWD_CRM_UT_ST%RowType;

Line 5: old_references IGS_GR_AWD_CRM_UT_ST%RowType;

1: package body IGS_GR_AWD_CRM_UT_ST_PKG as
2: /* $Header: IGSGI05B.pls 115.4 2002/11/29 00:34:43 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_GR_AWD_CRM_UT_ST%RowType;
6: new_references IGS_GR_AWD_CRM_UT_ST%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_GR_AWD_CRM_UT_ST%RowType;

2: /* $Header: IGSGI05B.pls 115.4 2002/11/29 00:34:43 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_GR_AWD_CRM_UT_ST%RowType;
6: new_references IGS_GR_AWD_CRM_UT_ST%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 30: FROM IGS_GR_AWD_CRM_UT_ST

26: ) AS
27:
28: CURSOR cur_old_ref_values IS
29: SELECT *
30: FROM IGS_GR_AWD_CRM_UT_ST
31: WHERE rowid = x_rowid;
32:
33: BEGIN
34:

Line 77: -- ON IGS_GR_AWD_CRM_UT_ST

73:
74: -- Trigger description :-
75: -- "OSS_TST".trg_acus_br_iud
76: -- BEFORE INSERT OR DELETE OR UPDATE
77: -- ON IGS_GR_AWD_CRM_UT_ST
78: -- FOR EACH ROW
79:
80: PROCEDURE BeforeRowInsertUpdateDelete1(
81: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 261: FROM IGS_GR_AWD_CRM_UT_ST

257: ) RETURN BOOLEAN AS
258:
259: CURSOR cur_rowid IS
260: SELECT rowid
261: FROM IGS_GR_AWD_CRM_UT_ST
262: WHERE grd_cal_type = x_grd_cal_type
263: AND grd_ci_sequence_number = x_grd_ci_sequence_number
264: AND ceremony_number = x_ceremony_number
265: AND award_course_cd = x_award_course_cd

Line 300: FROM IGS_GR_AWD_CRM_UT_ST

296: ) AS
297:
298: CURSOR cur_rowid IS
299: SELECT rowid
300: FROM IGS_GR_AWD_CRM_UT_ST
301: WHERE grd_cal_type = x_grd_cal_type
302: AND grd_ci_sequence_number = x_grd_ci_sequence_number
303: AND ceremony_number = x_ceremony_number
304: AND award_course_cd = x_award_course_cd

Line 333: FROM IGS_GR_AWD_CRM_UT_ST

329: ) AS
330:
331: CURSOR cur_rowid IS
332: SELECT rowid
333: FROM IGS_GR_AWD_CRM_UT_ST
334: WHERE unit_set_cd = x_unit_set_cd
335: AND us_version_number = x_version_number ;
336:
337: lv_rowid cur_rowid%RowType;

Line 470: cursor C is select ROWID from IGS_GR_AWD_CRM_UT_ST

466: X_US_VERSION_NUMBER in NUMBER,
467: X_ORDER_IN_GROUP in NUMBER,
468: X_MODE in VARCHAR2 default 'R'
469: ) AS
470: cursor C is select ROWID from IGS_GR_AWD_CRM_UT_ST
471: where GRD_CAL_TYPE = X_GRD_CAL_TYPE
472: and GRD_CI_SEQUENCE_NUMBER = X_GRD_CI_SEQUENCE_NUMBER
473: and CEREMONY_NUMBER = X_CEREMONY_NUMBER
474: and AWARD_COURSE_CD = X_AWARD_COURSE_CD

Line 523: insert into IGS_GR_AWD_CRM_UT_ST (

519: x_last_updated_by => X_LAST_UPDATED_BY,
520: x_last_update_login => X_LAST_UPDATE_LOGIN
521: );
522:
523: insert into IGS_GR_AWD_CRM_UT_ST (
524: GRD_CAL_TYPE,
525: GRD_CI_SEQUENCE_NUMBER,
526: CEREMONY_NUMBER,
527: AWARD_COURSE_CD,

Line 582: from IGS_GR_AWD_CRM_UT_ST

578: X_ORDER_IN_GROUP in NUMBER
579: ) AS
580: cursor c1 is select
581: ORDER_IN_GROUP
582: from IGS_GR_AWD_CRM_UT_ST
583: where ROWID = X_ROWID for update nowait;
584: tlinfo c1%rowtype;
585:
586: begin

Line 664: update IGS_GR_AWD_CRM_UT_ST set

660: x_last_updated_by => X_LAST_UPDATED_BY,
661: x_last_update_login => X_LAST_UPDATE_LOGIN
662: );
663:
664: update IGS_GR_AWD_CRM_UT_ST set
665: ORDER_IN_GROUP = NEW_REFERENCES.ORDER_IN_GROUP,
666: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
667: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
668: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 691: cursor c1 is select rowid from IGS_GR_AWD_CRM_UT_ST

687: X_US_VERSION_NUMBER in NUMBER,
688: X_ORDER_IN_GROUP in NUMBER,
689: X_MODE in VARCHAR2 default 'R'
690: ) AS
691: cursor c1 is select rowid from IGS_GR_AWD_CRM_UT_ST
692: where GRD_CAL_TYPE = X_GRD_CAL_TYPE
693: and GRD_CI_SEQUENCE_NUMBER = X_GRD_CI_SEQUENCE_NUMBER
694: and CEREMONY_NUMBER = X_CEREMONY_NUMBER
695: and AWARD_COURSE_CD = X_AWARD_COURSE_CD

Line 749: delete from IGS_GR_AWD_CRM_UT_ST

745: p_action => 'DELETE',
746: x_rowid => X_ROWID
747: );
748:
749: delete from IGS_GR_AWD_CRM_UT_ST
750: where ROWID = X_ROWID;
751: if (sql%notfound) then
752: raise no_data_found;
753: end if;

Line 769: FROM IGS_GR_AWD_CRM_UT_ST

765: X_order_in_group IN NUMBER
766: ) RETURN BOOLEAN AS
767: CURSOR cur_rowid IS
768: SELECT rowid
769: FROM IGS_GR_AWD_CRM_UT_ST
770: WHERE grd_cal_type = x_grd_cal_type
771: AND grd_ci_sequence_number = x_grd_ci_sequence_number
772: AND ceremony_number = x_ceremony_number
773: AND award_course_cd = x_award_course_cd

Line 892: end IGS_GR_AWD_CRM_UT_ST_PKG;

888: END IF;
889:
890: END Check_Constraints;
891:
892: end IGS_GR_AWD_CRM_UT_ST_PKG;