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.ASO_SUP_CAPTURE_DATA_PKG dependencies on FND_PROFILE

Line 224: l_createdBy NUMBER := to_number( fnd_profile.value('USER_ID') );

220: l_ownerTableName ASO_SUP_TMPL_INSTANCE.OWNER_TABLE_NAME%TYPE;
221: l_ownerTableId ASO_SUP_TMPL_INSTANCE.OWNER_TABLE_ID%TYPE ;
222: l_templateInstance ASO_SUP_TMPL_INSTANCE.TEMPLATE_INSTANCE_ID%TYPE;
223: l_templateId ASO_SUP_TMPL_INSTANCE.TEMPLATE_ID%TYPE ;
224: l_createdBy NUMBER := to_number( fnd_profile.value('USER_ID') );
225: l_lastUpdatedBy NUMBER :=l_createdBy;
226: l_lastUpdateLogin NUMBER := to_number( fnd_profile.value('LOGIN_ID') );
227: lx_returnStatus VARCHAR2(50);
228: lx_msgCount NUMBER;

Line 226: l_lastUpdateLogin NUMBER := to_number( fnd_profile.value('LOGIN_ID') );

222: l_templateInstance ASO_SUP_TMPL_INSTANCE.TEMPLATE_INSTANCE_ID%TYPE;
223: l_templateId ASO_SUP_TMPL_INSTANCE.TEMPLATE_ID%TYPE ;
224: l_createdBy NUMBER := to_number( fnd_profile.value('USER_ID') );
225: l_lastUpdatedBy NUMBER :=l_createdBy;
226: l_lastUpdateLogin NUMBER := to_number( fnd_profile.value('LOGIN_ID') );
227: lx_returnStatus VARCHAR2(50);
228: lx_msgCount NUMBER;
229: lx_msgData VARCHAR2(2000);
230: lx_templateInstanceId NUMBER;

Line 479: l_createdBy NUMBER := to_number( fnd_profile.value('USER_ID') );

475: l_compSectMapId aso_sup_instance_value.SECT_COMP_MAP_ID%TYPE;
476: l_responseValue aso_sup_instance_value.VALUE%TYPE;
477: l_responseId aso_sup_instance_value.RESPONSE_ID%TYPE;
478: l_multAnsFlag VARCHAR2(1);
479: l_createdBy NUMBER := to_number( fnd_profile.value('USER_ID') );
480: l_lastUpdatedBy NUMBER :=l_createdBy;
481: l_lastUpdateLogin NUMBER := to_number( fnd_profile.value('LOGIN_ID') );
482: lx_returnStatus VARCHAR2(50);
483: lx_msgCount NUMBER;

Line 481: l_lastUpdateLogin NUMBER := to_number( fnd_profile.value('LOGIN_ID') );

477: l_responseId aso_sup_instance_value.RESPONSE_ID%TYPE;
478: l_multAnsFlag VARCHAR2(1);
479: l_createdBy NUMBER := to_number( fnd_profile.value('USER_ID') );
480: l_lastUpdatedBy NUMBER :=l_createdBy;
481: l_lastUpdateLogin NUMBER := to_number( fnd_profile.value('LOGIN_ID') );
482: lx_returnStatus VARCHAR2(50);
483: lx_msgCount NUMBER;
484: lx_msgData VARCHAR2(2000);
485: l_templateInstance aso_sup_instance_value.template_instance_id%TYPE :=p_template_instance_id;