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_PS_DSCP_PKG dependencies on IGS_PS_DSCP_ALL

Line 5: old_references IGS_PS_DSCP_ALL%RowType;

1: package body IGS_PS_DSCP_PKG as
2: /* $Header: IGSPI52B.pls 115.6 2002/11/29 02:30:30 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_DSCP_ALL%RowType;
6: new_references IGS_PS_DSCP_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_DSCP_ALL%RowType;

2: /* $Header: IGSPI52B.pls 115.6 2002/11/29 02:30:30 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_DSCP_ALL%RowType;
6: new_references IGS_PS_DSCP_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 28: FROM IGS_PS_DSCP_ALL

24: ) AS
25:
26: CURSOR cur_old_ref_values IS
27: SELECT *
28: FROM IGS_PS_DSCP_ALL
29: WHERE rowid = x_rowid;
30:
31: BEGIN
32:

Line 76: v_description IGS_PS_DSCP_ALL.description%TYPE DEFAULT NULL;

72: p_updating IN BOOLEAN DEFAULT FALSE,
73: p_deleting IN BOOLEAN DEFAULT FALSE
74: ) AS
75: v_message_name VARCHAR2(30);
76: v_description IGS_PS_DSCP_ALL.description%TYPE DEFAULT NULL;
77: v_funding_index_1 IGS_PS_DSCP_ALL.funding_index_1%TYPE DEFAULT NULL;
78: v_funding_index_2 IGS_PS_DSCP_ALL.funding_index_2%TYPE DEFAULT NULL;
79: v_funding_index_3 IGS_PS_DSCP_ALL.funding_index_3%TYPE DEFAULT NULL;
80: v_govt_discipline_group_cd

Line 77: v_funding_index_1 IGS_PS_DSCP_ALL.funding_index_1%TYPE DEFAULT NULL;

73: p_deleting IN BOOLEAN DEFAULT FALSE
74: ) AS
75: v_message_name VARCHAR2(30);
76: v_description IGS_PS_DSCP_ALL.description%TYPE DEFAULT NULL;
77: v_funding_index_1 IGS_PS_DSCP_ALL.funding_index_1%TYPE DEFAULT NULL;
78: v_funding_index_2 IGS_PS_DSCP_ALL.funding_index_2%TYPE DEFAULT NULL;
79: v_funding_index_3 IGS_PS_DSCP_ALL.funding_index_3%TYPE DEFAULT NULL;
80: v_govt_discipline_group_cd
81: IGS_PS_DSCP_ALL.govt_discipline_group_cd%TYPE DEFAULT NULL;

Line 78: v_funding_index_2 IGS_PS_DSCP_ALL.funding_index_2%TYPE DEFAULT NULL;

74: ) AS
75: v_message_name VARCHAR2(30);
76: v_description IGS_PS_DSCP_ALL.description%TYPE DEFAULT NULL;
77: v_funding_index_1 IGS_PS_DSCP_ALL.funding_index_1%TYPE DEFAULT NULL;
78: v_funding_index_2 IGS_PS_DSCP_ALL.funding_index_2%TYPE DEFAULT NULL;
79: v_funding_index_3 IGS_PS_DSCP_ALL.funding_index_3%TYPE DEFAULT NULL;
80: v_govt_discipline_group_cd
81: IGS_PS_DSCP_ALL.govt_discipline_group_cd%TYPE DEFAULT NULL;
82: v_closed_ind IGS_PS_DSCP_ALL.closed_ind%TYPE DEFAULT NULL;

Line 79: v_funding_index_3 IGS_PS_DSCP_ALL.funding_index_3%TYPE DEFAULT NULL;

75: v_message_name VARCHAR2(30);
76: v_description IGS_PS_DSCP_ALL.description%TYPE DEFAULT NULL;
77: v_funding_index_1 IGS_PS_DSCP_ALL.funding_index_1%TYPE DEFAULT NULL;
78: v_funding_index_2 IGS_PS_DSCP_ALL.funding_index_2%TYPE DEFAULT NULL;
79: v_funding_index_3 IGS_PS_DSCP_ALL.funding_index_3%TYPE DEFAULT NULL;
80: v_govt_discipline_group_cd
81: IGS_PS_DSCP_ALL.govt_discipline_group_cd%TYPE DEFAULT NULL;
82: v_closed_ind IGS_PS_DSCP_ALL.closed_ind%TYPE DEFAULT NULL;
83:

Line 81: IGS_PS_DSCP_ALL.govt_discipline_group_cd%TYPE DEFAULT NULL;

77: v_funding_index_1 IGS_PS_DSCP_ALL.funding_index_1%TYPE DEFAULT NULL;
78: v_funding_index_2 IGS_PS_DSCP_ALL.funding_index_2%TYPE DEFAULT NULL;
79: v_funding_index_3 IGS_PS_DSCP_ALL.funding_index_3%TYPE DEFAULT NULL;
80: v_govt_discipline_group_cd
81: IGS_PS_DSCP_ALL.govt_discipline_group_cd%TYPE DEFAULT NULL;
82: v_closed_ind IGS_PS_DSCP_ALL.closed_ind%TYPE DEFAULT NULL;
83:
84: x_rowid varchar2(25);
85: l_org_id NUMBER(15);

Line 82: v_closed_ind IGS_PS_DSCP_ALL.closed_ind%TYPE DEFAULT NULL;

78: v_funding_index_2 IGS_PS_DSCP_ALL.funding_index_2%TYPE DEFAULT NULL;
79: v_funding_index_3 IGS_PS_DSCP_ALL.funding_index_3%TYPE DEFAULT NULL;
80: v_govt_discipline_group_cd
81: IGS_PS_DSCP_ALL.govt_discipline_group_cd%TYPE DEFAULT NULL;
82: v_closed_ind IGS_PS_DSCP_ALL.closed_ind%TYPE DEFAULT NULL;
83:
84: x_rowid varchar2(25);
85: l_org_id NUMBER(15);
86: CURSOR SPDH_CUR IS

Line 287: FROM IGS_PS_DSCP_ALL

283: ) RETURN BOOLEAN AS
284:
285: CURSOR cur_rowid IS
286: SELECT rowid
287: FROM IGS_PS_DSCP_ALL
288: WHERE discipline_group_cd = x_discipline_group_cd
289: FOR UPDATE NOWAIT;
290:
291: lv_rowid cur_rowid%RowType;

Line 312: FROM IGS_PS_DSCP_ALL

308: ) AS
309:
310: CURSOR cur_rowid IS
311: SELECT rowid
312: FROM IGS_PS_DSCP_ALL
313: WHERE govt_discipline_group_cd = x_govt_discipline_group_cd ;
314:
315: lv_rowid cur_rowid%RowType;
316:

Line 434: cursor C is select ROWID from IGS_PS_DSCP_ALL

430: /****************************************************************************
431: sbaliga 13-feb-2002 Assigned igs_ge_gen_003.get_org_id to x_org_id
432: in call to before_dml as part of SWCR006 build.
433: ****************************************************************************/
434: cursor C is select ROWID from IGS_PS_DSCP_ALL
435: where DISCIPLINE_GROUP_CD = X_DISCIPLINE_GROUP_CD;
436: X_LAST_UPDATE_DATE DATE;
437: X_LAST_UPDATED_BY NUMBER;
438: X_LAST_UPDATE_LOGIN NUMBER;

Line 475: insert into IGS_PS_DSCP_ALL (

471: x_last_updated_by => X_LAST_UPDATED_BY,
472: x_last_update_login => X_LAST_UPDATE_LOGIN,
473: x_org_id => igs_ge_gen_003.get_org_id
474: );
475: insert into IGS_PS_DSCP_ALL (
476: DISCIPLINE_GROUP_CD,
477: DESCRIPTION,
478: FUNDING_INDEX_1,
479: FUNDING_INDEX_2,

Line 538: from IGS_PS_DSCP_ALL

534: FUNDING_INDEX_3,
535: GOVT_DISCIPLINE_GROUP_CD,
536: CLOSED_IND,
537: ORG_ID
538: from IGS_PS_DSCP_ALL
539: where ROWID = X_ROWID for update nowait;
540: tlinfo c1%rowtype;
541:
542: begin

Line 626: update IGS_PS_DSCP_ALL set

622: x_last_update_date => X_LAST_UPDATE_DATE,
623: x_last_updated_by => X_LAST_UPDATED_BY,
624: x_last_update_login => X_LAST_UPDATE_LOGIN
625: );
626: update IGS_PS_DSCP_ALL set
627: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
628: FUNDING_INDEX_1 = NEW_REFERENCES.FUNDING_INDEX_1,
629: FUNDING_INDEX_2 = NEW_REFERENCES.FUNDING_INDEX_2,
630: FUNDING_INDEX_3 = NEW_REFERENCES.FUNDING_INDEX_3,

Line 659: cursor c1 is select rowid from IGS_PS_DSCP_ALL

655: X_CLOSED_IND in VARCHAR2,
656: X_MODE in VARCHAR2 default 'R',
657: X_ORG_ID IN NUMBER
658: ) as
659: cursor c1 is select rowid from IGS_PS_DSCP_ALL
660: where DISCIPLINE_GROUP_CD = X_DISCIPLINE_GROUP_CD
661: ;
662: begin
663: open c1;

Line 701: delete from IGS_PS_DSCP_ALL

697: begin
698: Before_DML( p_action => 'DELETE',
699: x_rowid => X_ROWID
700: );
701: delete from IGS_PS_DSCP_ALL
702: where ROWID = X_ROWID;
703: if (sql%notfound) then
704: raise no_data_found;
705: end if;