APPS.IGS_GE_SEC_CONFIG_PKG dependencies on IGS_GE_CFG_TAB_V

Line 53: || nsidana 9/22/2003 Modified the cursor to pick data from IGS_GE_CFG_TAB_V which

49: || Who When What
50: || KUMMA 30-DEC-2002 2684922, Added Trim around tab_code
51: || (reverse chronological order - newest change first)
52: ||
53: || nsidana 9/22/2003 Modified the cursor to pick data from IGS_GE_CFG_TAB_V which
54: || holds the enabled tab pages for any form.
55: */
56: CURSOR c_tab_exists IS
57: SELECT TRIM(substr(tab_code,(instr(tab_code,'-')+1))) tab_code,config_opt

Line 58: FROM igs_ge_cfg_tab_v

54: || holds the enabled tab pages for any form.
55: */
56: CURSOR c_tab_exists IS
57: SELECT TRIM(substr(tab_code,(instr(tab_code,'-')+1))) tab_code,config_opt
58: FROM igs_ge_cfg_tab_v
59: WHERE responsibility_id = p_responsibility_id
60: AND form_code = p_form_name;
61:
62: j BINARY_INTEGER := 0;

Line 92: || nsidana 9/22/2003 Modified the cursor to pick data from IGS_GE_CFG_TAB_V which

88: || Who When What
89: || KUMMA 30-DEC-2002 2684922, Added Trim around tab_code on both sides in where clause
90: || (reverse chronological order - newest change first)
91: ||
92: || nsidana 9/22/2003 Modified the cursor to pick data from IGS_GE_CFG_TAB_V which
93: || holds the enabled tab pages for any form.
94: || gmaheswa 01/07/2004 Bug : 3294107 Modified cursor c_tab_exists to select row_id instead of rowid
95: || pkpatel 01/08/2003 Bug : 3294107 Added the check config_opt = 'H'
96: */

Line 100: FROM igs_ge_cfg_tab_v

96: */
97:
98: CURSOR c_tab_exists IS
99: SELECT row_id
100: FROM igs_ge_cfg_tab_v
101: WHERE responsibility_id = p_responsibility_id
102: AND form_code = p_form_name
103: AND TRIM(substr(tab_code,(instr(tab_code,'-')+1))) = TRIM(p_tab_name)
104: AND config_opt = 'H';