APPS.AMW_CONTROLS_PAGE_PKG dependencies on AMW_CONTROL_ASSERTIONS

Line 110: from amw_control_assertions

106: n number;
107: BEGIN
108: select count(*)
109: into n
110: from amw_control_assertions
111: where control_rev_id = P_CONTROL_REV_ID
112: and assertion_code = P_ASSERTION_CODE;
113:
114: if n > 0 then

Line 130: from amw_control_assertions

126: no varchar2(80);
127: BEGIN
128: select count(*)
129: into n
130: from amw_control_assertions
131: where control_rev_id = P_CONTROL_REV_ID
132: and assertion_code = P_ASSERTION_CODE;
133:
134: select meaning

Line 498: delete from amw_control_assertions

494: -- initialize return status to success
495: x_return_status := fnd_api.g_ret_sts_success;
496:
497:
498: delete from amw_control_assertions
499: where control_rev_id = p_control_rev_id
500: and assertion_code = p_assertion_code;
501:
502:

Line 511: select amw_control_assertions_s.nextval into l_control_assertion_id from dual;

507: l_last_update_date := SYSDATE;
508: l_last_updated_by := FND_GLOBAL.USER_ID;
509: l_last_update_login := FND_GLOBAL.USER_ID;
510:
511: select amw_control_assertions_s.nextval into l_control_assertion_id from dual;
512:
513: insert into amw_control_assertions (control_assertion_id,
514: control_rev_id,
515: assertion_code,

Line 513: insert into amw_control_assertions (control_assertion_id,

509: l_last_update_login := FND_GLOBAL.USER_ID;
510:
511: select amw_control_assertions_s.nextval into l_control_assertion_id from dual;
512:
513: insert into amw_control_assertions (control_assertion_id,
514: control_rev_id,
515: assertion_code,
516: creation_date,
517: created_by,

Line 787: delete from amw_control_assertions where control_rev_id = p_control_rev_id;

783: raise no_data_found;
784: end if;
785: */
786: ---if(x_return_status = fnd_api.g_ret_sts_success) then
787: delete from amw_control_assertions where control_rev_id = p_control_rev_id;
788: /*
789: if(sql%notfound) then
790: raise no_data_found;
791: end if;