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 ASO_SUP_TMPL_INSTANCE

Line 27: SELECT aso_sup_tmpl_instance_s.NEXTVAL

23:
24: SAVEPOINT create_temp_instance_int;
25:
26: --BEGIN
27: SELECT aso_sup_tmpl_instance_s.NEXTVAL
28: INTO l_template_instance_id
29: FROM DUAL;
30:
31: x_template_instance_id := l_template_instance_id;

Line 33: INSERT INTO aso_sup_tmpl_instance

29: FROM DUAL;
30:
31: x_template_instance_id := l_template_instance_id;
32:
33: INSERT INTO aso_sup_tmpl_instance
34: ( TEMPLATE_INSTANCE_ID,
35: TEMPLATE_ID,
36: OWNER_TABLE_NAME,
37: OWNER_TABLE_ID,

Line 220: l_ownerTableName ASO_SUP_TMPL_INSTANCE.OWNER_TABLE_NAME%TYPE;

216: l_compSectMapId aso_sup_instance_value.SECT_COMP_MAP_ID%TYPE;
217: l_responseValue aso_sup_instance_value.VALUE%TYPE;
218: l_responseId aso_sup_instance_value.RESPONSE_ID%TYPE;
219: l_multAnsFlag VARCHAR2(1);
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') );

Line 221: l_ownerTableId ASO_SUP_TMPL_INSTANCE.OWNER_TABLE_ID%TYPE ;

217: l_responseValue aso_sup_instance_value.VALUE%TYPE;
218: l_responseId aso_sup_instance_value.RESPONSE_ID%TYPE;
219: l_multAnsFlag VARCHAR2(1);
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;

Line 222: l_templateInstance ASO_SUP_TMPL_INSTANCE.TEMPLATE_INSTANCE_ID%TYPE;

218: l_responseId aso_sup_instance_value.RESPONSE_ID%TYPE;
219: l_multAnsFlag VARCHAR2(1);
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') );

Line 223: l_templateId ASO_SUP_TMPL_INSTANCE.TEMPLATE_ID%TYPE ;

219: l_multAnsFlag VARCHAR2(1);
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);

Line 503: FROM ASO_SUP_TMPL_INSTANCE

499: CURSOR c_quote (
500: lc_template_instance_id NUMBER
501: ) IS
502: SELECT owner_table_id,owner_table_name
503: FROM ASO_SUP_TMPL_INSTANCE
504: WHERE template_instance_id = lc_template_instance_id;
505: --AND owner_table_name = 'ASO_QUOTE_HEADERS';
506:
507: l_header_id NUMBER;