APPS.IGS_AD_SYSSRC_CAT_PKG dependencies on IGS_AD_SYSSRC_CAT

Line 1: PACKAGE BODY igs_ad_syssrc_cat_pkg AS

1: PACKAGE BODY igs_ad_syssrc_cat_pkg AS
2: /* $Header: IGSAI72B.pls 115.13 2003/10/30 13:16:33 akadam ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_syssrc_cat%RowType;
5: new_references igs_ad_syssrc_cat%RowType;

Line 4: old_references igs_ad_syssrc_cat%RowType;

1: PACKAGE BODY igs_ad_syssrc_cat_pkg AS
2: /* $Header: IGSAI72B.pls 115.13 2003/10/30 13:16:33 akadam ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_syssrc_cat%RowType;
5: new_references igs_ad_syssrc_cat%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ad_syssrc_cat%RowType;

1: PACKAGE BODY igs_ad_syssrc_cat_pkg AS
2: /* $Header: IGSAI72B.pls 115.13 2003/10/30 13:16:33 akadam ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_syssrc_cat%RowType;
5: new_references igs_ad_syssrc_cat%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 38: FROM IGS_AD_SYSSRC_CAT

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

Line 168: FROM igs_ad_syssrc_cat

164: ***************************************************************/
165:
166: CURSOR cur_rowid IS
167: SELECT rowid
168: FROM igs_ad_syssrc_cat
169: WHERE category_name = x_category_name
170: AND system_source_type = x_system_source_type AND
171: closed_ind = NVL(x_closed_ind,closed_ind)
172: FOR UPDATE NOWAIT;

Line 205: FROM igs_ad_syssrc_cat

201: || (reverse chronological order - newest change first)
202: */
203: CURSOR cur_rowid IS
204: SELECT rowid
205: FROM igs_ad_syssrc_cat
206: WHERE upper(category_name) = upper(x_category_name)
207: AND upper(system_source_type) = upper(x_system_source_type)
208: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
209:

Line 394: cursor C is select ROWID from IGS_AD_SYSSRC_CAT

390: pkpatel 16-JUN-2001 Added processing for two newly added columns AD_TAB_NAME and INT_TAB_NAME
391: (reverse chronological order - newest change first)
392: ***************************************************************/
393:
394: cursor C is select ROWID from IGS_AD_SYSSRC_CAT
395: where CATEGORY_NAME= X_CATEGORY_NAME
396: and SYSTEM_SOURCE_TYPE = X_SYSTEM_SOURCE_TYPE
397: ;
398: X_LAST_UPDATE_DATE DATE ;

Line 436: insert into IGS_AD_SYSSRC_CAT (

432: x_last_update_date=>X_LAST_UPDATE_DATE,
433: x_last_updated_by=>X_LAST_UPDATED_BY,
434: x_last_update_login=>X_LAST_UPDATE_LOGIN,
435: x_closed_ind=>X_CLOSED_IND);
436: insert into IGS_AD_SYSSRC_CAT (
437: SYSTEM_SOURCE_TYPE
438: ,CATEGORY_NAME
439: ,MANDATORY_IND
440: ,SS_IND

Line 507: from IGS_AD_SYSSRC_CAT

503: DISPLAY_SEQUENCE,
504: AD_TAB_NAME,
505: INT_TAB_NAME,
506: CLOSED_IND
507: from IGS_AD_SYSSRC_CAT
508: where ROWID = X_ROWID
509: for update nowait;
510: tlinfo c1%rowtype;
511: begin

Line 597: update IGS_AD_SYSSRC_CAT set

593: x_last_updated_by=>X_LAST_UPDATED_BY,
594: x_last_update_login=>X_LAST_UPDATE_LOGIN,
595: x_closed_ind=>X_CLOSED_IND);
596:
597: update IGS_AD_SYSSRC_CAT set
598: mandatory_ind=X_MANDATORY_IND,
599: ss_ind=NULL,
600: display_sequence=NULL,
601: ad_tab_name=X_AD_TAB_NAME,

Line 640: cursor c1 is select ROWID from IGS_AD_SYSSRC_CAT

636: pkpatel 16-JUN-2001 Added processing for two newly added columns AD_TAB_NAME and INT_TAB_NAME
637: (reverse chronological order - newest change first)
638: ***************************************************************/
639:
640: cursor c1 is select ROWID from IGS_AD_SYSSRC_CAT
641: where CATEGORY_NAME= X_CATEGORY_NAME
642: and SYSTEM_SOURCE_TYPE = X_SYSTEM_SOURCE_TYPE
643: ;
644: begin

Line 694: delete from IGS_AD_SYSSRC_CAT

690: Before_DML (
691: p_action => 'DELETE',
692: x_rowid => X_ROWID
693: );
694: delete from IGS_AD_SYSSRC_CAT
695: where ROWID = X_ROWID;
696: if (sql%notfound) then
697: raise no_data_found;
698: end if;

Line 704: END igs_ad_syssrc_cat_pkg;

700: p_action => 'DELETE',
701: x_rowid => X_ROWID
702: );
703: end DELETE_ROW;
704: END igs_ad_syssrc_cat_pkg;