DBA Data[Home] [Help]

APPS.AMW_CONTROLS_PAGE_PKG dependencies on AMW_CONTROL_ASSOCIATIONS

Line 677: select control_association_id from amw_control_associations

673: l_last_updated_by number;
674: l_last_update_login number;
675:
676: cursor get_association_row(l_object_type in varchar2,l_control_id in varchar2, l_pk1 in varchar2) is
677: select control_association_id from amw_control_associations
678: where object_type = l_object_type
679: and pk1 = l_pk1
680: and control_id = l_control_id;
681:

Line 704: delete from amw_control_associations

700: FETCH get_association_row INTO l_control_association_id;
701: CLOSE get_association_row;
702:
703: if(l_control_association_id.control_association_id is not null)then
704: delete from amw_control_associations
705: where control_association_id = l_control_association_id.control_association_id;
706:
707: if (sql%notfound) then
708: raise no_data_found;

Line 758: select control_association_id from amw_control_associations

754: l_last_updated_by number;
755: l_last_update_login number;
756:
757: cursor get_association_row(l_object_type in varchar2,l_control_id in varchar2, l_pk1 in varchar2) is
758: select control_association_id from amw_control_associations
759: where object_type = l_object_type
760: and pk1 = l_pk1
761: and control_id = l_control_id;
762: