APPS.FA_CUA_HIERARCHY_PKG dependencies on FA_HIERARCHY_DISTRIBUTIONS

Line 181: from FA_HIERARCHY_DISTRIBUTIONS

177: Function valid_dist_set(x_dist_set_id in number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
178: return Boolean
179: is
180: Cursor C is select dist_set_id
181: from FA_HIERARCHY_DISTRIBUTIONS
182: where dist_set_id = x_dist_set_id;
183: l_dist_set_id number;
184: Begin
185: open C;

Line 371: set and the distribution lines in FA_HIERARCHY_DISTRIBUTIONS table */

367: close c;
368: end INSERT_ROW;
369:
370: /* Procedure to validate the distribution table and create the distribution
371: set and the distribution lines in FA_HIERARCHY_DISTRIBUTIONS table */
372: Procedure create_distribution_set
373: ( x_dist_set_id out nocopy number
374: ,x_book_type_code in varchar2
375: ,x_distribution_tab in FA_CUA_HIERARCHY_PKG.distribution_tabtype

Line 452: x_err_stage := 'Inserting into FA_HIERARCHY_DISTRIBUTIONS table';

448: x_err_stage := 'Fetch the next Dist Set ID';
449: open C;
450: fetch C into x_dist_set_id;
451: close c;
452: x_err_stage := 'Inserting into FA_HIERARCHY_DISTRIBUTIONS table';
453: l_rowid := null;
454: --dbms_output.put_line('Before Inserting Distributions');
455: --dbms_output.put_line('count:'||to_char(x_distribution_tab.count));
456: FOR I in 1..x_distribution_tab.count LOOP

Line 1149: x_err_stage := 'Inserting into FA_HIERARCHY_DISTRIBUTIONS table';

1145: , X_LAST_UPDATED_BY
1146: , X_LAST_UPDATE_LOGIN , p_log_level_rec => p_log_level_rec);
1147: end if;
1148: /** Moved to Create_dist_set procedure **
1149: x_err_stage := 'Inserting into FA_HIERARCHY_DISTRIBUTIONS table';
1150: l_rowid := null;
1151: --dbms_output.put_line('Before Inserting Distributions');
1152: --dbms_output.put_line('count:'||to_char(x_distribution_tab.count));
1153: if( x_distribution_tab.count > 0 ) then