APPS.IGS_GE_S_HELP_CTRL_PKG dependencies on IGS_GE_S_HELP_CTRL

Line 1: package body IGS_GE_S_HELP_CTRL_PKG as

1: package body IGS_GE_S_HELP_CTRL_PKG as
2: /* $Header: IGSMI09B.pls 115.3 2002/11/29 01:11:20 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_GE_S_HELP_CTRL%RowType;

Line 5: old_references IGS_GE_S_HELP_CTRL%RowType;

1: package body IGS_GE_S_HELP_CTRL_PKG as
2: /* $Header: IGSMI09B.pls 115.3 2002/11/29 01:11:20 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_GE_S_HELP_CTRL%RowType;
6: new_references IGS_GE_S_HELP_CTRL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_GE_S_HELP_CTRL%RowType;

2: /* $Header: IGSMI09B.pls 115.3 2002/11/29 01:11:20 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_GE_S_HELP_CTRL%RowType;
6: new_references IGS_GE_S_HELP_CTRL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 31: FROM IGS_GE_S_HELP_CTRL

27: ) as
28:
29: CURSOR cur_old_ref_values IS
30: SELECT *
31: FROM IGS_GE_S_HELP_CTRL
32: WHERE rowid = x_rowid;
33:
34: BEGIN
35:

Line 102: FROM IGS_GE_S_HELP_CTRL

98: ) RETURN BOOLEAN as
99:
100: CURSOR cur_rowid IS
101: SELECT rowid
102: FROM IGS_GE_S_HELP_CTRL
103: WHERE s_control_num = x_s_control_num
104: FOR UPDATE NOWAIT;
105:
106: lv_rowid cur_rowid%RowType;

Line 228: cursor C is select ROWID from IGS_GE_S_HELP_CTRL

224: X_LINK3_BUTTON_LABEL in VARCHAR2,
225: X_LINK3_BASE_URL in VARCHAR2,
226: X_MODE in VARCHAR2 default 'R'
227: ) as
228: cursor C is select ROWID from IGS_GE_S_HELP_CTRL
229: where S_CONTROL_NUM = NEW_REFERENCES.S_CONTROL_NUM;
230: X_LAST_UPDATE_DATE DATE;
231: X_LAST_UPDATED_BY NUMBER;
232: X_LAST_UPDATE_LOGIN NUMBER;

Line 273: insert into IGS_GE_S_HELP_CTRL (

269: x_last_update_date => X_LAST_UPDATE_DATE,
270: x_last_update_login => X_LAST_UPDATE_LOGIN
271: );
272:
273: insert into IGS_GE_S_HELP_CTRL (
274: S_CONTROL_NUM,
275: BASE_URL,
276: OWS_ENABLED_IND,
277: TOC_URL,

Line 347: from IGS_GE_S_HELP_CTRL

343: LINK2_BUTTON_LABEL,
344: LINK2_BASE_URL,
345: LINK3_BUTTON_LABEL,
346: LINK3_BASE_URL
347: from IGS_GE_S_HELP_CTRL
348: where ROWID = X_ROWID
349: for update nowait;
350: tlinfo c1%rowtype;
351:

Line 461: update IGS_GE_S_HELP_CTRL set

457: x_last_update_date => X_LAST_UPDATE_DATE,
458: x_last_update_login => X_LAST_UPDATE_LOGIN
459: );
460:
461: update IGS_GE_S_HELP_CTRL set
462: BASE_URL = NEW_REFERENCES.BASE_URL,
463: OWS_ENABLED_IND = NEW_REFERENCES.OWS_ENABLED_IND,
464: TOC_URL = NEW_REFERENCES.TOC_URL,
465: INDEX_URL = NEW_REFERENCES.INDEX_URL,

Line 501: cursor c1 is select rowid from IGS_GE_S_HELP_CTRL

497: X_LINK3_BUTTON_LABEL in VARCHAR2,
498: X_LINK3_BASE_URL in VARCHAR2,
499: X_MODE in VARCHAR2 default 'R'
500: ) as
501: cursor c1 is select rowid from IGS_GE_S_HELP_CTRL
502: where S_CONTROL_NUM = NVL(X_S_CONTROL_NUM,1)
503: ;
504:
505: begin

Line 551: delete from IGS_GE_S_HELP_CTRL

547: Before_DML (
548: p_action => 'DELETE',
549: x_rowid => X_ROWID
550: );
551: delete from IGS_GE_S_HELP_CTRL
552: where ROWID = X_ROWID;
553: if (sql%notfound) then
554: raise no_data_found;
555: end if;

Line 563: end IGS_GE_S_HELP_CTRL_PKG;

559: );
560:
561: end DELETE_ROW;
562:
563: end IGS_GE_S_HELP_CTRL_PKG;