DBA Data[Home] [Help]

APPS.ASO_SUP_RESPONSE_PKG dependencies on ASO_SUP_COMP_RESP_MAP

Line 709: from aso_sup_comp_resp_map

705: WHERE RESPONSE_ID = p_RESPONSE_ID;
706:
707: cursor get_mappings is
708: select component_response_ID
709: from aso_sup_comp_resp_map
710: where component_id = P_RESP_COMPONENT_ID
711: and response_id = P_RESPONSE_ID;
712:
713: begin

Line 806: ASO_SUP_COMP_RESP_MAP_PKG.UPDATE_ROW (

802: loop
803: fetch get_mappings into l_component_response_ID;
804: if get_mappings%FOUND THEN
805: -- THIS MEANS RESPONSE has already been used for that component
806: ASO_SUP_COMP_RESP_MAP_PKG.UPDATE_ROW (
807: P_COMPONENT_RESPONSE_ID => l_COMPONENT_RESPONSE_ID,
808: P_LAST_UPDATE_DATE => sysdate ,
809: P_LAST_UPDATED_BY => l_user_id ,
810: P_LAST_UPDATE_LOGIN => l_user_id ,

Line 839: ASO_SUP_COMP_RESP_MAP_PKG.INSERT_ROW (

835: );
836: exit;
837: elsif get_mappings%NOTFOUND THEN
838: -- THIS MEANS RESPONSE has not been used for that component
839: ASO_SUP_COMP_RESP_MAP_PKG.INSERT_ROW (
840: PX_ROWID => row_id1,
841: PX_COMPONENT_RESPONSE_ID => l_COMPONENT_RESPONSE_ID,
842: P_CREATION_DATE => sysdate ,
843: P_CREATED_BY => l_user_id ,