APPS.AMS_LST_RULE_USAGES dependencies on AMS_LIST_RULE_USAGES

Line 21: SELECT ams_list_rule_usages_s.NEXTVAL

17: l_api_name constant varchar2(30) := 'create_list_rule_usages';
18: l_api_version CONSTANT NUMBER := 1.0;
19: l_list_rule_usage_id number;
20: CURSOR c_get_id is
21: SELECT ams_list_rule_usages_s.NEXTVAL
22: FROM DUAL;
23:
24: BEGIN
25:

Line 49: delete from ams_list_rule_usages

45: FETCH c_get_id INTO l_list_rule_usage_Id;
46: CLOSE c_get_id;
47:
48: x_list_rule_usage_id := l_list_rule_usage_Id;
49: delete from ams_list_rule_usages
50: where list_header_id = p_list_header_id;
51:
52: INSERT INTO ams_list_rule_usages (
53: list_rule_usage_id ,

Line 52: INSERT INTO ams_list_rule_usages (

48: x_list_rule_usage_id := l_list_rule_usage_Id;
49: delete from ams_list_rule_usages
50: where list_header_id = p_list_header_id;
51:
52: INSERT INTO ams_list_rule_usages (
53: list_rule_usage_id ,
54: list_header_id ,
55: list_rule_id ,
56: last_update_date ,