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)
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 450: x_err_stage := 'Inserting into FA_HIERARCHY_DISTRIBUTIONS table';

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

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

1138: , X_LAST_UPDATED_BY
1139: , X_LAST_UPDATE_LOGIN );
1140: end if;
1141: /** Moved to Create_dist_set procedure **
1142: x_err_stage := 'Inserting into FA_HIERARCHY_DISTRIBUTIONS table';
1143: l_rowid := null;
1144: --dbms_output.put_line('Before Inserting Distributions');
1145: --dbms_output.put_line('count:'||to_char(x_distribution_tab.count));
1146: if( x_distribution_tab.count > 0 ) then