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_SC_GRANTS_PVT dependencies on IGS_SC_VARS

Line 312: l_select_text := replace_string(ltrim(p_select_text),':PARTY_ID','igs_sc_vars.get_partyid');

308: l_debug_str := 'Table Name: '||p_table_name||','||'Select Text: '||p_select_text;
309: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
310: END IF;
311:
312: l_select_text := replace_string(ltrim(p_select_text),':PARTY_ID','igs_sc_vars.get_partyid');
313:
314: l_select_text := replace_string(ltrim(l_select_text),':USER_ID','igs_sc_vars.get_userid');
315:
316: l_select_text := replace_string(ltrim(l_select_text),':TBL_ALIAS','tstal');

Line 314: l_select_text := replace_string(ltrim(l_select_text),':USER_ID','igs_sc_vars.get_userid');

310: END IF;
311:
312: l_select_text := replace_string(ltrim(p_select_text),':PARTY_ID','igs_sc_vars.get_partyid');
313:
314: l_select_text := replace_string(ltrim(l_select_text),':USER_ID','igs_sc_vars.get_userid');
315:
316: l_select_text := replace_string(ltrim(l_select_text),':TBL_ALIAS','tstal');
317:
318: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 881: l_attr_select := replace_string(ltrim(l_user_attrib.select_text),':PARTY_ID','igs_sc_vars.get_partyid');

877: IF l_user_attrib.static_type = 'D' AND l_user_attrib.user_attrib_type <> 'F' THEN
878:
879: -- Dynamic attribute - we need to append the actual select for this attribute
880:
881: l_attr_select := replace_string(ltrim(l_user_attrib.select_text),':PARTY_ID','igs_sc_vars.get_partyid');
882:
883: l_attr_select := replace_string(ltrim(l_attr_select),':USER_ID','igs_sc_vars.get_userid');
884:
885: -- Replace table alias value with our alias, generated based on attribute id

Line 883: l_attr_select := replace_string(ltrim(l_attr_select),':USER_ID','igs_sc_vars.get_userid');

879: -- Dynamic attribute - we need to append the actual select for this attribute
880:
881: l_attr_select := replace_string(ltrim(l_user_attrib.select_text),':PARTY_ID','igs_sc_vars.get_partyid');
882:
883: l_attr_select := replace_string(ltrim(l_attr_select),':USER_ID','igs_sc_vars.get_userid');
884:
885: -- Replace table alias value with our alias, generated based on attribute id
886:
887: l_usr_select := replace_string(ltrim(l_attr_select),':TBL_ALIAS',l_usr_alias);

Line 892: l_attr_select := replace_string(ltrim(l_user_attrib.select_text),':PARTY_ID','igs_sc_vars.get_partyid');

888:
889:
890: ELSIF l_user_attrib.static_type = 'D' AND l_user_attrib.user_attrib_type = 'F' THEN
891:
892: l_attr_select := replace_string(ltrim(l_user_attrib.select_text),':PARTY_ID','igs_sc_vars.get_partyid');
893:
894: l_usr_const := replace_string(ltrim(l_attr_select),':USER_ID','igs_sc_vars.get_userid');
895:
896: ELSIF l_user_attrib.user_attrib_type = 'M' THEN

Line 894: l_usr_const := replace_string(ltrim(l_attr_select),':USER_ID','igs_sc_vars.get_userid');

890: ELSIF l_user_attrib.static_type = 'D' AND l_user_attrib.user_attrib_type = 'F' THEN
891:
892: l_attr_select := replace_string(ltrim(l_user_attrib.select_text),':PARTY_ID','igs_sc_vars.get_partyid');
893:
894: l_usr_const := replace_string(ltrim(l_attr_select),':USER_ID','igs_sc_vars.get_userid');
895:
896: ELSIF l_user_attrib.user_attrib_type = 'M' THEN
897:
898: -- If yes then construct for multi-value attribute

Line 901: l_usr_select :='SELECT '||l_usr_alias||'.attr_value FROM igs_sc_usr_att_vals '||l_usr_alias||' WHERE '||l_usr_alias||'.user_id=igs_sc_vars.get_userid AND '

897:
898: -- If yes then construct for multi-value attribute
899: -- Add select from values table
900:
901: l_usr_select :='SELECT '||l_usr_alias||'.attr_value FROM igs_sc_usr_att_vals '||l_usr_alias||' WHERE '||l_usr_alias||'.user_id=igs_sc_vars.get_userid AND '
902: ||l_usr_alias||'.user_attrib_id='||c_grant_cond_rec.user_attrib_id;
903:
904: ELSE
905: --Simply get value for an attribute using API and append

Line 907: l_usr_const := 'igs_sc_vars.get_att('||c_grant_cond_rec.user_attrib_id||')';

903:
904: ELSE
905: --Simply get value for an attribute using API and append
906:
907: l_usr_const := 'igs_sc_vars.get_att('||c_grant_cond_rec.user_attrib_id||')';
908:
909:
910: END IF; -- Multy value attribute end
911:

Line 1280: l_user_id := igs_sc_vars.get_userid;

1276: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1277: END IF;
1278:
1279: g_alias_number :=0;
1280: l_user_id := igs_sc_vars.get_userid;
1281: g_user_id := l_user_id;
1282: -- Check if object exists in the tables and assigned to a group
1283:
1284: