APPS.XLA_ANALYTICAL_CRITERIA_PKG dependencies on XLA_ANALYTICAL_DTLS_B

Line 81: --Offset to add to the view column number contained in xla_analytical_dtls_b

77: --Total number of slots available
78: C_MAX_MAPPABLE_DETAILS CONSTANT INTEGER := C_MAX_MAPPABLE_VARCHAR_DETAILS
79: +C_MAX_MAPPABLE_DATE_DETAILS
80: +C_MAX_MAPPABLE_NUMBER_DETAILS;
81: --Offset to add to the view column number contained in xla_analytical_dtls_b
82: --to get the actual column position in xla_analytical_criteria_v
83: C_MAPPABLE_VARCHAR_OFFSET CONSTANT INTEGER := 0;
84: C_MAPPABLE_DATE_OFFSET CONSTANT INTEGER := C_MAPPABLE_VARCHAR_OFFSET
85: +C_MAX_MAPPABLE_VARCHAR_DETAILS;

Line 3856: FROM xla_analytical_dtls_b xdtb

3852: ( cp_data_type_code VARCHAR2
3853: )
3854: IS
3855: SELECT xdtb.view_column_num
3856: FROM xla_analytical_dtls_b xdtb
3857: ,xla_analytical_hdrs_b xhtb
3858: WHERE xdtb.analytical_criterion_code = xhtb.analytical_criterion_code
3859: AND xdtb.analytical_criterion_type_code = xhtb.analytical_criterion_type_code
3860: AND xhtb.balancing_flag = p_balance_flag

Line 3864: FROM xla_analytical_dtls_b xdtb2

3860: AND xhtb.balancing_flag = p_balance_flag
3861: AND xdtb.data_type_code = cp_data_type_code
3862: AND NVL(xdtb.view_column_num, -1) =
3863: (SELECT NVL( MIN(xdtb2.view_column_num), -1)
3864: FROM xla_analytical_dtls_b xdtb2
3865: ,xla_analytical_dtls_b xdtb3
3866: ,xla_analytical_hdrs_b xhtb2
3867: WHERE xdtb2.data_type_code = xdtb.data_type_code
3868: AND xdtb2.analytical_criterion_code = xhtb2.analytical_criterion_code

Line 3865: ,xla_analytical_dtls_b xdtb3

3861: AND xdtb.data_type_code = cp_data_type_code
3862: AND NVL(xdtb.view_column_num, -1) =
3863: (SELECT NVL( MIN(xdtb2.view_column_num), -1)
3864: FROM xla_analytical_dtls_b xdtb2
3865: ,xla_analytical_dtls_b xdtb3
3866: ,xla_analytical_hdrs_b xhtb2
3867: WHERE xdtb2.data_type_code = xdtb.data_type_code
3868: AND xdtb2.analytical_criterion_code = xhtb2.analytical_criterion_code
3869: AND xdtb2.analytical_criterion_type_code = xhtb2.analytical_criterion_type_code

Line 3955: FROM xla_analytical_dtls_b xdtb

3951:
3952: --see if slot 1 is free for this data type
3953: SELECT count(*)
3954: INTO l_count_in_slot_1
3955: FROM xla_analytical_dtls_b xdtb
3956: WHERE xdtb.data_type_code = p_data_type_code
3957: AND xdtb.view_column_num = 1;
3958:
3959: --if it is free override the selection

Line 4025: FROM xla_analytical_dtls_b

4021: RETURN INTEGER
4022: IS
4023: CURSOR c IS
4024: SELECT view_column_num
4025: FROM xla_analytical_dtls_b
4026: WHERE analytical_criterion_code = p_anacri_code
4027: AND analytical_criterion_type_code = p_anacri_type_code
4028: AND analytical_detail_code = p_anacri_detail_code
4029: AND data_type_code = p_data_type_code

Line 4104: FROM xla_analytical_dtls_b xdtb

4100: IS
4101: SELECT xdtb.analytical_detail_code
4102: ,xdtb.view_column_num
4103: ,xdtb.data_type_code
4104: FROM xla_analytical_dtls_b xdtb
4105: WHERE xdtb.analytical_criterion_code = cp_anacri_code
4106: AND xdtb.analytical_criterion_type_code = cp_anacri_type_code
4107: AND xdtb.amb_context_code = cp_amb_context_code
4108: ORDER BY xdtb.grouping_order

Line 4310: UPDATE xla_analytical_dtls_b xdtb

4306: ,p_level => C_LEVEL_STATEMENT
4307: );
4308: END IF;
4309:
4310: UPDATE xla_analytical_dtls_b xdtb
4311: SET xdtb.view_column_num = l_view_column_number
4312: WHERE xdtb.analytical_criterion_code = p_anacri_code
4313: AND xdtb.analytical_criterion_type_code = p_anacri_type_code
4314: AND xdtb.amb_context_code = p_amb_context_code

Line 4388: ,xla_analytical_dtls_b xdtb

4384: ,xdtb.analytical_detail_code
4385: ,xdtb.grouping_order
4386: ,xdtb.view_column_num
4387: FROM xla_analytical_hdrs_b xhdb
4388: ,xla_analytical_dtls_b xdtb
4389: WHERE xhdb.display_in_inquiries_flag = 'Y'
4390: AND xdtb.analytical_criterion_code = xhdb.analytical_criterion_code
4391: AND xdtb.analytical_criterion_type_code = xhdb.analytical_criterion_type_code
4392: AND xdtb.amb_context_code = xhdb.amb_context_code