13: , X_CREATED_BY in number
14: , X_LAST_UPDATE_DATE in date
15: , X_LAST_UPDATED_BY in number
16: , X_LAST_UPDATE_LOGIN in number
17: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
18: is
19: Cursor C1 is Select ROWID from FA_HIERARCHY_DISTRIBUTIONS
20: where distribution_id = x_distribution_id;
21: CURSOR C is Select FA_HIERARCHY_DISTRIBUTIONS_S.nextval from sys.dual;
71: , x_distribution_line_percentage in number
72: , x_code_combination_id in number
73: , x_location_id in number
74: , x_assigned_to in number
75: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
76: is
77: Cursor C1 is
78: Select
79: book_type_code
131: , x_assigned_to in number
132: , X_LAST_UPDATE_DATE in date
133: , X_LAST_UPDATED_BY in number
134: , X_LAST_UPDATE_LOGIN in number
135: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
136: is
137: Begin
138: update FA_HIERARCHY_DISTRIBUTIONS
139: set
152: End update_row;
153:
154: procedure DELETE_ROW (
155: x_rowid in varchar2
156: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
157: is
158: Begin
159: delete from FA_HIERARCHY_DISTRIBUTIONS
160: where rowid = x_rowid;