APPS.CS_CHG_SUB_REST_PKG dependencies on CS_CHG_SUB_RESTRICTIONS

Line 38: select cs_chg_sub_restrictions_s.nextval

34: P_OBJECT_VERSION_NUMBER IN NUMBER,
35: P_SECURITY_GROUP_ID IN NUMBER)
36: IS
37: cursor c1 is
38: select cs_chg_sub_restrictions_s.nextval
39: from dual;
40:
41: BEGIN
42: if ( px_restriction_id IS NULL ) OR ( px_restriction_id = FND_API.G_MISS_NUM) THEN

Line 48: insert into CS_CHG_SUB_RESTRICTIONS (

44: fetch c1 into px_restriction_id;
45: close c1;
46: end if;
47:
48: insert into CS_CHG_SUB_RESTRICTIONS (
49: RESTRICTION_ID, RESTRICTION_TYPE, CONDITION,
50: VALUE_OBJECT_ID, VALUE_AMOUNT, CURRENCY_CODE,
51: START_DATE_ACTIVE, END_DATE_ACTIVE, CREATION_DATE,
52: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,

Line 83: from cs_chg_sub_restrictions

79: P_OBJECT_VERSION_NUMBER IN NUMBER)
80: IS
81: cursor c is
82: select 1
83: from cs_chg_sub_restrictions
84: where restriction_id = p_restriction_id
85: and object_version_number = p_object_version_number
86: for update nowait;
87:

Line 138: UPDATE CS_CHG_SUB_RESTRICTIONS

134: IS
135:
136: BEGIN
137:
138: UPDATE CS_CHG_SUB_RESTRICTIONS
139: SET RESTRICTION_ID = P_RESTRICTION_ID,
140: RESTRICTION_TYPE = P_RESTRICTION_TYPE,
141: CONDITION = P_CONDITION,
142: VALUE_OBJECT_ID = P_VALUE_OBJECT_ID,

Line 183: DELETE FROM cs_chg_sub_restrictions

179: P_RESTRICTION_ID in NUMBER)
180: IS
181: BEGIN
182:
183: DELETE FROM cs_chg_sub_restrictions
184: WHERE restriction_id = p_restriction_id;
185:
186: if (sql%notfound) then
187: raise no_data_found;