DBA Data[Home] [Help]

APPS.ASO_SUP_COMPONENT_PKG dependencies on ASO_SUP_SECT_COMP_MAP

Line 771: from aso_sup_sect_comp_map

767: WHERE COMPONENT_ID = P_COMPONENT_ID;
768:
769: cursor get_mappings is
770: select sect_comp_map_id
771: from aso_sup_sect_comp_map
772: where section_id = P_COMP_SECTION_ID
773: and component_id = P_COMPONENT_ID;
774:
775: begin

Line 880: ASO_SUP_SECT_COMP_MAP_PKG.UPDATE_ROW (

876: loop
877: fetch get_mappings into l_SECT_COMP_MAP_ID;
878: if get_mappings%FOUND THEN
879: -- this means the component has already been used in this section
880: ASO_SUP_SECT_COMP_MAP_PKG.UPDATE_ROW (
881: P_SECT_COMP_MAP_ID => l_SECT_COMP_MAP_ID ,
882: P_LAST_UPDATE_DATE => sysdate ,
883: P_LAST_UPDATED_BY => l_user_id ,
884: P_LAST_UPDATE_LOGIN => l_user_id ,

Line 919: ASO_SUP_SECT_COMP_MAP_PKG.INSERT_ROW (

915: exit;
916: elsif get_mappings%NOTFOUND THEN
917: -- this means the component has NOT been used in this section
918:
919: ASO_SUP_SECT_COMP_MAP_PKG.INSERT_ROW (
920: PX_ROWID => row_id1,
921: PX_SECT_COMP_MAP_ID => l_SECT_COMP_MAP_ID ,
922: P_CREATION_DATE => sysdate ,
923: P_CREATED_BY => l_user_id ,