APPS.AMW_CONTROLS_PAGE_PKG dependencies on AMW_ASSESSMENT_COMPONENTS

Line 163: from amw_assessment_components

159: n number;
160: BEGIN
161: select count(*)
162: into n
163: from amw_assessment_components
164: where object_type = 'CONTROL'
165: and object_id = P_CONTROL_REV_ID
166: and component_code = P_component_CODE;
167:

Line 184: from amw_assessment_components

180: no varchar2(80);
181: BEGIN
182: select count(*)
183: into n
184: from amw_assessment_components
185: where object_type = 'CONTROL'
186: and object_id = P_CONTROL_REV_ID
187: and component_code = P_component_CODE;
188:

Line 592: delete from amw_assessment_components

588: -- initialize return status to success
589: x_return_status := fnd_api.g_ret_sts_success;
590:
591:
592: delete from amw_assessment_components
593: where object_id = p_control_rev_id
594: and object_type = 'CONTROL'
595: and component_code = p_component_code;
596:

Line 606: select amw_assessment_components_s.nextval into l_assessment_component_id from dual;

602: l_last_update_date := SYSDATE;
603: l_last_updated_by := FND_GLOBAL.USER_ID;
604: l_last_update_login := FND_GLOBAL.USER_ID;
605:
606: select amw_assessment_components_s.nextval into l_assessment_component_id from dual;
607:
608: insert into amw_assessment_components (assessment_component_id,
609: component_code,
610: object_type,

Line 608: insert into amw_assessment_components (assessment_component_id,

604: l_last_update_login := FND_GLOBAL.USER_ID;
605:
606: select amw_assessment_components_s.nextval into l_assessment_component_id from dual;
607:
608: insert into amw_assessment_components (assessment_component_id,
609: component_code,
610: object_type,
611: object_id,
612: creation_date,

Line 795: delete from amw_assessment_components

791: end if;
792: */
793: ---end if;
794: ---if(x_return_status = fnd_api.g_ret_sts_success) then
795: delete from amw_assessment_components
796: where object_id = p_control_rev_id
797: and object_type = 'CONTROL';
798: /*
799: if(sql%notfound) then