APPS.IGS_PR_MILESTONE_HST_PKG dependencies on IGS_PR_MILESTONE_HST_ALL

Line 4: old_references IGS_PR_MILESTONE_HST_ALL%RowType;

1: package body IGS_PR_MILESTONE_HST_PKG as
2: /* $Header: IGSQI02B.pls 115.6 2002/11/29 03:13:48 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PR_MILESTONE_HST_ALL%RowType;
5: new_references IGS_PR_MILESTONE_HST_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_PR_MILESTONE_HST_ALL%RowType;

1: package body IGS_PR_MILESTONE_HST_PKG as
2: /* $Header: IGSQI02B.pls 115.6 2002/11/29 03:13:48 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PR_MILESTONE_HST_ALL%RowType;
5: new_references IGS_PR_MILESTONE_HST_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 36: FROM IGS_PR_MILESTONE_HST_ALL

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

Line 97: FROM IGS_PR_MILESTONE_HST_ALL

93: ) RETURN BOOLEAN AS
94:
95: CURSOR cur_rowid IS
96: SELECT rowid
97: FROM IGS_PR_MILESTONE_HST_ALL
98: WHERE person_id = x_person_id
99: AND ca_sequence_number = x_ca_sequence_number
100: AND sequence_number = x_sequence_number
101: AND hist_start_dt = x_hist_start_dt

Line 232: cursor C is select ROWID from IGS_PR_MILESTONE_HST_ALL

228: X_COMMENTS in VARCHAR2,
229: X_MODE in VARCHAR2 default 'R',
230: X_ORG_ID IN NUMBER
231: ) AS
232: cursor C is select ROWID from IGS_PR_MILESTONE_HST_ALL
233: where PERSON_ID = X_PERSON_ID
234: and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
235: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
236: and HIST_START_DT = X_HIST_START_DT;

Line 287: insert into IGS_PR_MILESTONE_HST_ALL (

283: x_last_update_login => x_last_update_login,
284: x_org_id=>igs_ge_gen_003.get_org_id
285: ) ;
286:
287: insert into IGS_PR_MILESTONE_HST_ALL (
288: PERSON_ID,
289: CA_SEQUENCE_NUMBER,
290: SEQUENCE_NUMBER,
291: HIST_START_DT,

Line 376: from IGS_PR_MILESTONE_HST_ALL

372: OVRD_NTFCTN_IMMINENT_DAYS,
373: OVRD_NTFCTN_REMINDER_DAYS,
374: OVRD_NTFCTN_RE_REMINDER_DAYS,
375: COMMENTS
376: from IGS_PR_MILESTONE_HST_ALL
377: where ROWID = X_ROWID for update nowait;
378: tlinfo c1%rowtype;
379:
380: begin

Line 503: update IGS_PR_MILESTONE_HST_ALL set

499: x_last_updated_by =>x_last_updated_by,
500: x_last_update_login => x_last_update_login
501: ) ;
502:
503: update IGS_PR_MILESTONE_HST_ALL set
504: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
505: HIST_WHO = NEW_REFERENCES.HIST_WHO,
506: MILESTONE_TYPE = NEW_REFERENCES.MILESTONE_TYPE,
507: MILESTONE_STATUS = NEW_REFERENCES.MILESTONE_STATUS,

Line 547: cursor c1 is select rowid from IGS_PR_MILESTONE_HST_ALL

543: X_COMMENTS in VARCHAR2,
544: X_MODE in VARCHAR2 default 'R',
545: X_ORG_ID IN NUMBER
546: ) AS
547: cursor c1 is select rowid from IGS_PR_MILESTONE_HST_ALL
548: where PERSON_ID = X_PERSON_ID
549: and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
550: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
551: and HIST_START_DT = X_HIST_START_DT

Line 612: delete from IGS_PR_MILESTONE_HST_ALL

608: p_action => 'DELETE',
609: x_rowid => X_ROWID
610: );
611:
612: delete from IGS_PR_MILESTONE_HST_ALL
613: where ROWID = X_ROWID;
614: if (sql%notfound) then
615: raise no_data_found;
616: end if;