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_INSTANCE_VALUE

Line 101: FROM aso_sup_instance_value

97:
98: BEGIN
99: SELECT 'Y'
100: INTO l_exists
101: FROM aso_sup_instance_value
102: WHERE template_instance_id = p_template_instance_id
103: AND sect_comp_map_id = p_sect_comp_map_id
104: AND ROWNUM = 1 ;
105: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 115: UPDATE aso_sup_instance_value

111: --IF ( p_multiple_response_flag = 'X') THEN l_exists := 'X'; END IF;
112: END;
113: IF (l_exists = 'Y') THEN
114: BEGIN
115: UPDATE aso_sup_instance_value
116: SET created_by = p_created_by,
117: last_updated_by = p_last_updated_by,
118: last_update_login = p_last_update_login,
119: response_id = p_response_id,

Line 127: INSERT INTO aso_sup_instance_value

123: END;
124: ELSE
125: IF (l_exists = 'N') THEN
126: BEGIN
127: INSERT INTO aso_sup_instance_value
128: (instance_value_id, template_instance_id,
129: sect_comp_map_id, created_by, last_updated_by,
130: last_update_login, response_id, value,
131: last_update_date, creation_date)

Line 175: DELETE FROM aso_sup_instance_value

171:
172: SAVEPOINT delete_data_int;
173:
174: BEGIN
175: DELETE FROM aso_sup_instance_value
176: WHERE template_instance_id = p_template_instance_id
177: AND sect_comp_map_id = p_sect_comp_map_id;
178: END;
179: --COMMIT;

Line 216: l_compSectMapId aso_sup_instance_value.SECT_COMP_MAP_ID%TYPE;

212: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
213: X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
214: X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2) IS
215:
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;

Line 217: l_responseValue aso_sup_instance_value.VALUE%TYPE;

213: X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
214: X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2) IS
215:
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 ;

Line 218: l_responseId aso_sup_instance_value.RESPONSE_ID%TYPE;

214: X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2) IS
215:
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;

Line 475: l_compSectMapId aso_sup_instance_value.SECT_COMP_MAP_ID%TYPE;

471: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
472: X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
473: X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2) IS
474:
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') );

Line 476: l_responseValue aso_sup_instance_value.VALUE%TYPE;

472: X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
473: X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2) IS
474:
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;

Line 477: l_responseId aso_sup_instance_value.RESPONSE_ID%TYPE;

473: X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2) IS
474:
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') );

Line 485: l_templateInstance aso_sup_instance_value.template_instance_id%TYPE :=p_template_instance_id;

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;
486:
487: l_compSectMapIds JTF_NUMBER_TABLE := p_comp_sect_map_id;
488: l_responseIds JTF_NUMBER_TABLE := P_response_id ;
489: l_responseValues JTF_VARCHAR2_TABLE_2000 :=P_response_value;