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 3691: FROM xla_analytical_dtls_b xdtb

3687: ( cp_data_type_code VARCHAR2
3688: )
3689: IS
3690: SELECT xdtb.view_column_num
3691: FROM xla_analytical_dtls_b xdtb
3692: ,xla_analytical_hdrs_b xhtb
3693: WHERE xdtb.analytical_criterion_code = xhtb.analytical_criterion_code
3694: AND xdtb.analytical_criterion_type_code = xhtb.analytical_criterion_type_code
3695: AND xhtb.balancing_flag = p_balance_flag

Line 3699: FROM xla_analytical_dtls_b xdtb2

3695: AND xhtb.balancing_flag = p_balance_flag
3696: AND xdtb.data_type_code = cp_data_type_code
3697: AND NVL(xdtb.view_column_num, -1) =
3698: (SELECT NVL( MIN(xdtb2.view_column_num), -1)
3699: FROM xla_analytical_dtls_b xdtb2
3700: ,xla_analytical_dtls_b xdtb3
3701: ,xla_analytical_hdrs_b xhtb2
3702: WHERE xdtb2.data_type_code = xdtb.data_type_code
3703: AND xdtb2.analytical_criterion_code = xhtb2.analytical_criterion_code

Line 3700: ,xla_analytical_dtls_b xdtb3

3696: AND xdtb.data_type_code = cp_data_type_code
3697: AND NVL(xdtb.view_column_num, -1) =
3698: (SELECT NVL( MIN(xdtb2.view_column_num), -1)
3699: FROM xla_analytical_dtls_b xdtb2
3700: ,xla_analytical_dtls_b xdtb3
3701: ,xla_analytical_hdrs_b xhtb2
3702: WHERE xdtb2.data_type_code = xdtb.data_type_code
3703: AND xdtb2.analytical_criterion_code = xhtb2.analytical_criterion_code
3704: AND xdtb2.analytical_criterion_type_code = xhtb2.analytical_criterion_type_code

Line 3790: FROM xla_analytical_dtls_b xdtb

3786:
3787: --see if slot 1 is free for this data type
3788: SELECT count(*)
3789: INTO l_count_in_slot_1
3790: FROM xla_analytical_dtls_b xdtb
3791: WHERE xdtb.data_type_code = p_data_type_code
3792: AND xdtb.view_column_num = 1;
3793:
3794: --if it is free override the selection

Line 3860: FROM xla_analytical_dtls_b

3856: RETURN INTEGER
3857: IS
3858: CURSOR c IS
3859: SELECT view_column_num
3860: FROM xla_analytical_dtls_b
3861: WHERE analytical_criterion_code = p_anacri_code
3862: AND analytical_criterion_type_code = p_anacri_type_code
3863: AND analytical_detail_code = p_anacri_detail_code
3864: AND data_type_code = p_data_type_code

Line 3939: FROM xla_analytical_dtls_b xdtb

3935: IS
3936: SELECT xdtb.analytical_detail_code
3937: ,xdtb.view_column_num
3938: ,xdtb.data_type_code
3939: FROM xla_analytical_dtls_b xdtb
3940: WHERE xdtb.analytical_criterion_code = cp_anacri_code
3941: AND xdtb.analytical_criterion_type_code = cp_anacri_type_code
3942: AND xdtb.amb_context_code = cp_amb_context_code
3943: ORDER BY xdtb.grouping_order

Line 4145: UPDATE xla_analytical_dtls_b xdtb

4141: ,p_level => C_LEVEL_STATEMENT
4142: );
4143: END IF;
4144:
4145: UPDATE xla_analytical_dtls_b xdtb
4146: SET xdtb.view_column_num = l_view_column_number
4147: WHERE xdtb.analytical_criterion_code = p_anacri_code
4148: AND xdtb.analytical_criterion_type_code = p_anacri_type_code
4149: AND xdtb.amb_context_code = p_amb_context_code

Line 4223: ,xla_analytical_dtls_b xdtb

4219: ,xdtb.analytical_detail_code
4220: ,xdtb.grouping_order
4221: ,xdtb.view_column_num
4222: FROM xla_analytical_hdrs_b xhdb
4223: ,xla_analytical_dtls_b xdtb
4224: WHERE xhdb.display_in_inquiries_flag = 'Y'
4225: AND xdtb.analytical_criterion_code = xhdb.analytical_criterion_code
4226: AND xdtb.analytical_criterion_type_code = xhdb.analytical_criterion_type_code
4227: AND xdtb.amb_context_code = xhdb.amb_context_code