APPS.IGS_AD_SOURCE_CAT_PKG dependencies on IGS_AD_SOURCE_CAT_ALL

Line 4: old_references igs_ad_source_cat_all%RowType;

1: PACKAGE BODY igs_ad_source_cat_pkg AS
2: /* $Header: IGSAI71B.pls 115.22 2003/07/01 10:24:41 pbondugu ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_source_cat_all%RowType;
5: new_references igs_ad_source_cat_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ad_source_cat_all%RowType;

1: PACKAGE BODY igs_ad_source_cat_pkg AS
2: /* $Header: IGSAI71B.pls 115.22 2003/07/01 10:24:41 pbondugu ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_source_cat_all%RowType;
5: new_references igs_ad_source_cat_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 43: FROM IGS_AD_SOURCE_CAT_ALL

39: ***************************************************************/
40:
41: CURSOR cur_old_ref_values IS
42: SELECT *
43: FROM IGS_AD_SOURCE_CAT_ALL
44: WHERE rowid = x_rowid;
45:
46: BEGIN
47:

Line 231: FROM igs_ad_source_cat_all

227: ***************************************************************/
228:
229: CURSOR cur_rowid IS
230: SELECT rowid
231: FROM igs_ad_source_cat_all
232: WHERE src_cat_id = x_src_cat_id
233: FOR UPDATE NOWAIT;
234:
235: lv_rowid cur_rowid%RowType;

Line 268: FROM igs_ad_source_cat_all

264: ***************************************************************/
265:
266: CURSOR cur_rowid IS
267: SELECT rowid
268: FROM igs_ad_source_cat_all
269: WHERE source_type_id = x_source_type_id
270: AND category_name = x_category_name and ((l_rowid is null) or (rowid <> l_rowid))
271:
272: ;

Line 305: FROM igs_ad_source_cat_all

301: ***************************************************************/
302:
303: CURSOR cur_rowid IS
304: SELECT rowid
305: FROM igs_ad_source_cat_all
306: WHERE source_type_id = x_source_type_id ;
307:
308: lv_rowid cur_rowid%RowType;
309:

Line 490: cursor C is select ROWID from IGS_AD_SOURCE_CAT_ALL

486: pkpatel 18-JUN-2001 Modified to add the processing for 3 new ADDED columns DETAIL_LEVEL_IND,AD_TAB_NAME and INT_TAB_NAME
487: (reverse chronological order - newest change first)
488: ***************************************************************/
489:
490: cursor C is select ROWID from IGS_AD_SOURCE_CAT_ALL
491: where SRC_CAT_ID= X_SRC_CAT_ID;
492:
493: X_LAST_UPDATE_DATE DATE ;
494: X_LAST_UPDATED_BY NUMBER ;

Line 540: insert into IGS_AD_SOURCE_CAT_ALL (

536: x_detail_level_ind => NVL(X_DETAIL_LEVEL_IND,'N'),
537: x_ad_tab_name => X_AD_TAB_NAME,
538: x_int_tab_name => X_INT_TAB_NAME
539: );
540: insert into IGS_AD_SOURCE_CAT_ALL (
541: ORG_ID,
542: SRC_CAT_ID
543: ,SOURCE_TYPE_ID
544: ,CATEGORY_NAME

Line 625: from IGS_AD_SOURCE_CAT_ALL

621:
622: cursor c1 is
623: select SOURCE_TYPE_ID, CATEGORY_NAME, MANDATORY_IND, INCLUDE_IND, DISCREPANCY_RULE_CD,
624: SS_IND,DISPLAY_SEQUENCE,DETAIL_LEVEL_IND,AD_TAB_NAME,INT_TAB_NAME
625: from IGS_AD_SOURCE_CAT_ALL
626: where ROWID = X_ROWID
627: for update nowait;
628: tlinfo c1%rowtype;
629: BEGIN

Line 735: update IGS_AD_SOURCE_CAT_ALL set

731: x_detail_level_ind=> X_DETAIL_LEVEL_IND,
732: x_ad_tab_name => X_AD_TAB_NAME,
733: x_int_tab_name => X_INT_TAB_NAME
734: );
735: update IGS_AD_SOURCE_CAT_ALL set
736: MANDATORY_IND = NEW_REFERENCES.MANDATORY_IND,
737: INCLUDE_IND = NEW_REFERENCES.INCLUDE_IND,
738: DISCREPANCY_RULE_CD = NEW_REFERENCES.DISCREPANCY_RULE_CD,
739: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 788: cursor c1 is select ROWID from IGS_AD_SOURCE_CAT_ALL

784: pkpatel 18-JUN-2001 Modified to add the processing for 3 new ADDED columns DETAIL_LEVEL_IND,AD_TAB_NAME and INT_TAB_NAME
785: (reverse chronological order - newest change first)
786: ***************************************************************/
787:
788: cursor c1 is select ROWID from IGS_AD_SOURCE_CAT_ALL
789: where SRC_CAT_ID= X_SRC_CAT_ID
790: ;
791: BEGIN
792: open c1;

Line 853: delete from IGS_AD_SOURCE_CAT_ALL

849: Before_DML (
850: p_action => 'DELETE',
851: x_rowid => X_ROWID
852: );
853: delete from IGS_AD_SOURCE_CAT_ALL
854: where ROWID = X_ROWID;
855: if (sql%notfound) then
856: raise no_data_found;
857: end if;

Line 933: FROM igs_ad_source_cat_all

929: CURSOR c_sysdiscrepancy_attr_del_cur IS
930: SELECT ROWID
931: FROM igs_ad_dscp_attr
932: WHERE src_cat_id = (SELECT src_cat_id
933: FROM igs_ad_source_cat_all
934: WHERE ROWID = X_ROWID);
935:
936: BEGIN
937: