APPS.IGS_RE_THS_PNL_MR_HS_PKG dependencies on IGS_RE_THS_PNL_MR_HS_ALL

Line 4: old_references IGS_RE_THS_PNL_MR_HS_ALL%RowType;

1: package body IGS_RE_THS_PNL_MR_HS_PKG as
2: /* $Header: IGSRI22B.pls 115.5 2002/11/29 03:37:32 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_RE_THS_PNL_MR_HS_ALL%RowType;
5: new_references IGS_RE_THS_PNL_MR_HS_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_RE_THS_PNL_MR_HS_ALL%RowType;

1: package body IGS_RE_THS_PNL_MR_HS_PKG as
2: /* $Header: IGSRI22B.pls 115.5 2002/11/29 03:37:32 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_RE_THS_PNL_MR_HS_ALL%RowType;
5: new_references IGS_RE_THS_PNL_MR_HS_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 36: FROM IGS_RE_THS_PNL_MR_HS_ALL

32: ) AS
33:
34: CURSOR cur_old_ref_values IS
35: SELECT *
36: FROM IGS_RE_THS_PNL_MR_HS_ALL
37: WHERE rowid = x_rowid;
38:
39: BEGIN
40:

Line 164: FROM IGS_RE_THS_PNL_MR_HS_ALL

160: AS
161:
162: CURSOR cur_rowid IS
163: SELECT rowid
164: FROM IGS_RE_THS_PNL_MR_HS_ALL
165: WHERE ca_person_id = x_ca_person_id
166: AND ca_sequence_number = x_ca_sequence_number
167: AND the_sequence_number = x_the_sequence_number
168: AND creation_dt = x_creation_dt

Line 302: cursor C is select ROWID from IGS_RE_THS_PNL_MR_HS_ALL

298: X_RECOMMENDATION_SUMMARY in VARCHAR2,
299: X_MODE in VARCHAR2 default 'R',
300: X_ORG_ID IN NUMBER
301: ) as
302: cursor C is select ROWID from IGS_RE_THS_PNL_MR_HS_ALL
303: where CA_PERSON_ID = X_CA_PERSON_ID
304: and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
305: and THE_SEQUENCE_NUMBER = X_THE_SEQUENCE_NUMBER
306: and CREATION_DT = X_CREATION_DT

Line 359: insert into IGS_RE_THS_PNL_MR_HS_ALL (

355: x_last_update_login => X_LAST_UPDATE_LOGIN,
356: x_org_id => igs_ge_gen_003.get_org_id
357: );
358:
359: insert into IGS_RE_THS_PNL_MR_HS_ALL (
360: CA_PERSON_ID,
361: CA_SEQUENCE_NUMBER,
362: THE_SEQUENCE_NUMBER,
363: CREATION_DT,

Line 447: from IGS_RE_THS_PNL_MR_HS_ALL

443: THESIS_RESULT_CD,
444: PAID_DT,
445: TRACKING_ID,
446: RECOMMENDATION_SUMMARY
447: from IGS_RE_THS_PNL_MR_HS_ALL
448: where ROWID = X_ROWID
449: for update nowait;
450: tlinfo c1%rowtype;
451:

Line 567: update IGS_RE_THS_PNL_MR_HS_ALL set

563: x_last_update_date => X_LAST_UPDATE_DATE,
564: x_last_update_login => X_LAST_UPDATE_LOGIN
565: );
566:
567: update IGS_RE_THS_PNL_MR_HS_ALL set
568: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
569: HIST_WHO = NEW_REFERENCES.HIST_WHO,
570: PANEL_MEMBER_TYPE = NEW_REFERENCES.PANEL_MEMBER_TYPE,
571: CONFIRMED_DT = NEW_REFERENCES.CONFIRMED_DT,

Line 610: cursor c1 is select rowid from IGS_RE_THS_PNL_MR_HS_ALL

606: X_RECOMMENDATION_SUMMARY in VARCHAR2,
607: X_MODE in VARCHAR2 default 'R',
608: X_ORG_ID in NUMBER
609: ) as
610: cursor c1 is select rowid from IGS_RE_THS_PNL_MR_HS_ALL
611: where CA_PERSON_ID = X_CA_PERSON_ID
612: and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
613: and THE_SEQUENCE_NUMBER = X_THE_SEQUENCE_NUMBER
614: and CREATION_DT = X_CREATION_DT

Line 677: delete from IGS_RE_THS_PNL_MR_HS_ALL

673: p_action => 'DELETE',
674: x_rowid => X_ROWID
675: );
676:
677: delete from IGS_RE_THS_PNL_MR_HS_ALL
678: where ROWID = X_ROWID;
679: if (sql%notfound) then
680: raise no_data_found;
681: end if;