APPS.BSC_UPDATE_DIM dependencies on BSC_UPDATE_UTIL

Line 76: x_relation_cols IN BSC_UPDATE_UTIL.t_array_of_varchar2,

72: +============================================================================*/
73: FUNCTION Any_Item_Changed_Any_Relation(
74: x_dimension_table IN VARCHAR2,
75: x_temp_table IN VARCHAR2,
76: x_relation_cols IN BSC_UPDATE_UTIL.t_array_of_varchar2,
77: x_num_relation_cols IN NUMBER
78: ) RETURN BOOLEAN;
79:
80:

Line 141: x_deleted_codes IN BSC_UPDATE_UTIL.t_array_of_number,

137: |
138: +============================================================================*/
139: FUNCTION Delete_Codes_Cascade(
140: x_dim_table IN VARCHAR2,
141: x_deleted_codes IN BSC_UPDATE_UTIL.t_array_of_number,
142: x_num_deleted_codes IN NUMBER
143: ) RETURN BOOLEAN;
144:
145:

Line 161: x_deleted_codes1 IN BSC_UPDATE_UTIL.t_array_of_varchar2,

157: FUNCTION Delete_Codes_CascadeMN(
158: x_dim_table IN VARCHAR2,
159: x_key_column1 IN VARCHAR2,
160: x_key_column2 IN VARCHAR2,
161: x_deleted_codes1 IN BSC_UPDATE_UTIL.t_array_of_varchar2,
162: x_deleted_codes2 IN BSC_UPDATE_UTIL.t_array_of_varchar2,
163: x_num_deleted_codes IN NUMBER
164: ) RETURN BOOLEAN;
165:

Line 162: x_deleted_codes2 IN BSC_UPDATE_UTIL.t_array_of_varchar2,

158: x_dim_table IN VARCHAR2,
159: x_key_column1 IN VARCHAR2,
160: x_key_column2 IN VARCHAR2,
161: x_deleted_codes1 IN BSC_UPDATE_UTIL.t_array_of_varchar2,
162: x_deleted_codes2 IN BSC_UPDATE_UTIL.t_array_of_varchar2,
163: x_num_deleted_codes IN NUMBER
164: ) RETURN BOOLEAN;
165:
166:

Line 295: x_aux_fields IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2

291: |
292: +============================================================================*/
293: FUNCTION Get_Aux_Fields_Dim_Table(
294: x_dim_table IN VARCHAR2,
295: x_aux_fields IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2
296: ) RETURN NUMBER;
297:
298:
299: /*===========================================================================+

Line 315: x_child_dimensions IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2

311: |
312: +============================================================================*/
313: FUNCTION Get_Child_Dimensions(
314: x_dimension_table IN VARCHAR2,
315: x_child_dimensions IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2
316: ) RETURN NUMBER;
317:
318:
319: /*===========================================================================+

Line 333: x_parent_columns IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,

329: |
330: +============================================================================*/
331: FUNCTION Get_Dbi_Dim_Parent_Columns(
332: x_dim_short_name IN VARCHAR2,
333: x_parent_columns IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,
334: x_src_parent_columns IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2
335: ) RETURN NUMBER;
336:
337:

Line 334: x_src_parent_columns IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2

330: +============================================================================*/
331: FUNCTION Get_Dbi_Dim_Parent_Columns(
332: x_dim_short_name IN VARCHAR2,
333: x_parent_columns IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,
334: x_src_parent_columns IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2
335: ) RETURN NUMBER;
336:
337:
338: /*===========================================================================+

Line 370: x_indicators IN BSC_UPDATE_UTIL.t_array_of_number,

366: | given indicators.
367: |
368: +============================================================================*/
369: FUNCTION Get_Dbi_Dims_Kpis(
370: x_indicators IN BSC_UPDATE_UTIL.t_array_of_number,
371: x_num_indicators IN NUMBER,
372: x_dbi_dimensions IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,
373: x_num_dbi_dimensions IN OUT NOCOPY NUMBER
374: ) RETURN BOOLEAN;

Line 372: x_dbi_dimensions IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,

368: +============================================================================*/
369: FUNCTION Get_Dbi_Dims_Kpis(
370: x_indicators IN BSC_UPDATE_UTIL.t_array_of_number,
371: x_num_indicators IN NUMBER,
372: x_dbi_dimensions IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,
373: x_num_dbi_dimensions IN OUT NOCOPY NUMBER
374: ) RETURN BOOLEAN;
375:
376:

Line 393: x_deleted_records IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_number

389: +============================================================================*/
390: FUNCTION Get_Deleted_Records(
391: x_dimension_table IN VARCHAR2,
392: x_temp_table IN VARCHAR2,
393: x_deleted_records IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_number
394: ) RETURN NUMBER;
395:
396:
397: /*===========================================================================+

Line 441: x_parent_tables IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,

437: |
438: +============================================================================*/
439: FUNCTION Get_Info_Parents_Dimensions(
440: x_dim_table IN VARCHAR2,
441: x_parent_tables IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,
442: x_parent_keys IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2
443: ) RETURN NUMBER;
444:
445:

Line 442: x_parent_keys IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2

438: +============================================================================*/
439: FUNCTION Get_Info_Parents_Dimensions(
440: x_dim_table IN VARCHAR2,
441: x_parent_tables IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,
442: x_parent_keys IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2
443: ) RETURN NUMBER;
444:
445:
446: /*===========================================================================+

Line 498: x_parent_dimensions IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2

494: |
495: +============================================================================*/
496: FUNCTION Get_Parent_Dimensions(
497: x_dimension_table IN VARCHAR2,
498: x_parent_dimensions IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2
499: ) RETURN NUMBER;
500:
501:
502: /*===========================================================================+

Line 518: x_relation_cols IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2

514: |
515: +============================================================================*/
516: FUNCTION Get_Relation_Cols(
517: x_dimension_table IN VARCHAR2,
518: x_relation_cols IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2
519: ) RETURN NUMBER;
520:
521:
522: /*===========================================================================+

Line 569: x_ids IN BSC_UPDATE_UTIL.t_array_of_number,

565: |
566: +============================================================================*/
567: FUNCTION Insert_Children_Denorm_Table(
568: x_parent_id IN number,
569: x_ids IN BSC_UPDATE_UTIL.t_array_of_number,
570: x_num_ids IN NUMBER,
571: x_level IN NUMBER,
572: x_denorm_table IN VARCHAR2,
573: x_child_col IN VARCHAR2,

Line 742: x_mod_dimensions IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,

738: |
739: +============================================================================*/
740: FUNCTION Refresh_EDW_Dimension(
741: x_dimension_table IN VARCHAR2,
742: x_mod_dimensions IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,
743: x_num_mod_dimensions IN OUT NOCOPY NUMBER,
744: x_checked_dimensions IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,
745: x_num_checked_dimensions IN OUT NOCOPY NUMBER
746: ) RETURN BOOLEAN;

Line 744: x_checked_dimensions IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,

740: FUNCTION Refresh_EDW_Dimension(
741: x_dimension_table IN VARCHAR2,
742: x_mod_dimensions IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,
743: x_num_mod_dimensions IN OUT NOCOPY NUMBER,
744: x_checked_dimensions IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,
745: x_num_checked_dimensions IN OUT NOCOPY NUMBER
746: ) RETURN BOOLEAN;
747:
748:

Line 766: x_dimension_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

762: | Notes:
763: |
764: +============================================================================*/
765: FUNCTION Refresh_EDW_Dimensions(
766: x_dimension_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
767: x_num_dimension_tables IN NUMBER
768: ) RETURN BOOLEAN;
769:
770: