eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PR_MILESTONE_PKG dependencies on IGS_PR_MILESTONE_ALL

Line 10: old_references IGS_PR_MILESTONE_ALL%RowType;

6: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_re_val_mil.genp_val_sdtt_sess
7: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
8: -------------------------------------------------------------------------------------------
9: l_rowid VARCHAR2(25);
10: old_references IGS_PR_MILESTONE_ALL%RowType;
11: new_references IGS_PR_MILESTONE_ALL%RowType;
12: PROCEDURE Set_Column_Values (
13: p_action IN VARCHAR2,
14: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 11: new_references IGS_PR_MILESTONE_ALL%RowType;

7: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
8: -------------------------------------------------------------------------------------------
9: l_rowid VARCHAR2(25);
10: old_references IGS_PR_MILESTONE_ALL%RowType;
11: new_references IGS_PR_MILESTONE_ALL%RowType;
12: PROCEDURE Set_Column_Values (
13: p_action IN VARCHAR2,
14: x_rowid IN VARCHAR2 DEFAULT NULL,
15: x_person_id IN NUMBER DEFAULT NULL,

Line 38: FROM IGS_PR_MILESTONE_ALL

34: ) AS
35:
36: CURSOR cur_old_ref_values IS
37: SELECT *
38: FROM IGS_PR_MILESTONE_ALL
39: WHERE rowid = x_rowid;
40:
41: BEGIN
42:

Line 88: -- ON IGS_PR_MILESTONE_ALL

84:
85: -- Trigger description :-
86: -- "OSS_TST".trg_mil_br_iud
87: -- BEFORE INSERT OR DELETE OR UPDATE
88: -- ON IGS_PR_MILESTONE_ALL
89: -- FOR EACH ROW
90:
91: PROCEDURE BeforeRowInsertUpdateDelete1(
92: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 165: -- ON IGS_PR_MILESTONE_ALL

161:
162: -- Trigger description :-
163: -- "OSS_TST".trg_mil_ar_iud
164: -- AFTER INSERT OR DELETE OR UPDATE
165: -- ON IGS_PR_MILESTONE_ALL
166: -- FOR EACH ROW
167:
168: PROCEDURE AfterRowInsertUpdateDelete2(
169: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 254: -- ON IGS_PR_MILESTONE_ALL

250:
251: -- Trigger description :-
252: -- "OSS_TST".trg_mil_as_iu
253: -- AFTER INSERT OR UPDATE
254: -- ON IGS_PR_MILESTONE_ALL
255:
256: PROCEDURE AfterStmtInsertUpdate3(
257: p_inserting IN BOOLEAN DEFAULT FALSE,
258: p_updating IN BOOLEAN DEFAULT FALSE,

Line 395: FROM IGS_PR_MILESTONE_ALL

391: ) RETURN BOOLEAN AS
392:
393: CURSOR cur_rowid IS
394: SELECT rowid
395: FROM IGS_PR_MILESTONE_ALL
396: WHERE person_id = x_person_id
397: AND ca_sequence_number = x_ca_sequence_number
398: AND sequence_number = x_sequence_number
399: FOR UPDATE NOWAIT;

Line 423: FROM IGS_PR_MILESTONE_ALL

419: ) AS
420:
421: CURSOR cur_rowid IS
422: SELECT rowid
423: FROM IGS_PR_MILESTONE_ALL
424: WHERE person_id = x_person_id
425: AND ca_sequence_number = x_sequence_number ;
426:
427: lv_rowid cur_rowid%RowType;

Line 452: FROM IGS_PR_MILESTONE_ALL

448: ) AS
449:
450: CURSOR cur_rowid IS
451: SELECT rowid
452: FROM IGS_PR_MILESTONE_ALL
453: WHERE person_id = x_person_id
454: AND ca_sequence_number = x_ca_sequence_number
455: AND preced_sequence_number = x_sequence_number ;
456:

Line 480: FROM IGS_PR_MILESTONE_ALL

476: ) AS
477:
478: CURSOR cur_rowid IS
479: SELECT rowid
480: FROM IGS_PR_MILESTONE_ALL
481: WHERE milestone_status = x_milestone_status ;
482:
483: lv_rowid cur_rowid%RowType;
484:

Line 506: FROM IGS_PR_MILESTONE_ALL

502: ) AS
503:
504: CURSOR cur_rowid IS
505: SELECT rowid
506: FROM IGS_PR_MILESTONE_ALL
507: WHERE milestone_type = x_milestone_type ;
508:
509: lv_rowid cur_rowid%RowType;
510:

Line 658: cursor C is select ROWID from IGS_PR_MILESTONE_ALL

654: X_COMMENTS in VARCHAR2,
655: X_MODE in VARCHAR2 default 'R',
656: X_ORG_ID in NUMBER
657: ) AS
658: cursor C is select ROWID from IGS_PR_MILESTONE_ALL
659: where PERSON_ID = X_PERSON_ID
660: and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
661: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;
662: X_LAST_UPDATE_DATE DATE;

Line 711: insert into IGS_PR_MILESTONE_ALL (

707: ) ;
708: IF (x_mode = 'S') THEN
709: igs_sc_gen_001.set_ctx('R');
710: END IF;
711: insert into IGS_PR_MILESTONE_ALL (
712: PERSON_ID,
713: CA_SEQUENCE_NUMBER,
714: SEQUENCE_NUMBER,
715: MILESTONE_TYPE,

Line 810: from IGS_PR_MILESTONE_ALL

806: OVRD_NTFCTN_IMMINENT_DAYS,
807: OVRD_NTFCTN_REMINDER_DAYS,
808: OVRD_NTFCTN_RE_REMINDER_DAYS,
809: COMMENTS
810: from IGS_PR_MILESTONE_ALL
811: where ROWID = X_ROWID for update nowait;
812: tlinfo c1%rowtype;
813:
814: begin

Line 926: update IGS_PR_MILESTONE_ALL set

922:
923: IF (x_mode = 'S') THEN
924: igs_sc_gen_001.set_ctx('R');
925: END IF;
926: update IGS_PR_MILESTONE_ALL set
927: MILESTONE_TYPE = NEW_REFERENCES.MILESTONE_TYPE,
928: MILESTONE_STATUS = NEW_REFERENCES.MILESTONE_STATUS,
929: DUE_DT = NEW_REFERENCES.DUE_DT,
930: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,

Line 990: cursor c1 is select rowid from IGS_PR_MILESTONE_ALL

986: X_COMMENTS in VARCHAR2,
987: X_MODE in VARCHAR2 default 'R',
988: X_ORG_ID IN NUMBER
989: ) AS
990: cursor c1 is select rowid from IGS_PR_MILESTONE_ALL
991: where PERSON_ID = X_PERSON_ID
992: and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
993: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
994: ;

Line 1051: delete from IGS_PR_MILESTONE_ALL

1047: );
1048: IF (x_mode = 'S') THEN
1049: igs_sc_gen_001.set_ctx('R');
1050: END IF;
1051: delete from IGS_PR_MILESTONE_ALL
1052: where ROWID = X_ROWID;
1053: if (sql%notfound) then
1054: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1055: igs_ge_msg_stack.add;