19: ) IS
20:
21: BEGIN
22:
23: INSERT INTO hz_party_usages_b (
24: party_usage_code,
25: party_usage_type,
26: restrict_manual_assign_flag,
27: restrict_manual_update_flag,
112: ) IS
113:
114: BEGIN
115:
116: UPDATE hz_party_usages_b
117: SET
118: party_usage_type = x_party_usage_type,
119: restrict_manual_assign_flag =
120: DECODE(x_restrict_manual_assign_flag,
178:
179: DELETE FROM hz_party_usages_tl t
180: WHERE NOT EXISTS (
181: SELECT NULL
182: FROM hz_party_usages_b b
183: WHERE b.party_usage_code = t.party_usage_code
184: );
185:
186: UPDATE hz_party_usages_tl t
341: f_ludate DATE; -- entity update date in file
342:
343: CURSOR c_party_usage IS
344: SELECT object_version_number
345: FROM hz_party_usages_b
346: WHERE party_usage_code = x_party_usage_code;
347:
348: db_object_version_number NUMBER;
349: