APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_LOOKUPS

Line 2601: FROM csi_lookups

2597:
2598: BEGIN
2599: SELECT meaning
2600: INTO p_instance_header_tbl(tab_row).accounting_class
2601: FROM csi_lookups
2602: WHERE lookup_code = p_instance_header_tbl(tab_row).accounting_class_code
2603: AND lookup_type = l_acct_lookup_type;
2604: EXCEPTION
2605: WHEN OTHERS THEN

Line 2612: FROM csi_lookups

2608:
2609: BEGIN
2610: SELECT meaning
2611: INTO p_instance_header_tbl(tab_row).instance_type_name
2612: FROM csi_lookups
2613: WHERE lookup_code = p_instance_header_tbl(tab_row).instance_type_code
2614: AND lookup_type = l_inst_lookup_type;
2615: EXCEPTION
2616: WHEN OTHERS THEN

Line 2623: FROM csi_lookups

2619:
2620: BEGIN
2621: SELECT meaning
2622: INTO p_instance_header_tbl(tab_row).instance_usage_name
2623: FROM csi_lookups
2624: WHERE lookup_code = p_instance_header_tbl(tab_row).instance_usage_code
2625: AND lookup_type = l_usage_lookup_type;
2626: EXCEPTION
2627: WHEN OTHERS THEN

Line 2635: FROM csi_lookups

2631:
2632: BEGIN
2633: SELECT meaning
2634: INTO p_instance_header_tbl(tab_row).operational_status_name
2635: FROM csi_lookups
2636: WHERE lookup_code = p_instance_header_tbl(tab_row).operational_status_code
2637: AND lookup_type = l_op_status_lookup_type;
2638: EXCEPTION
2639: WHEN OTHERS THEN

Line 2647: FROM csi_lookups

2643: IF p_instance_header_tbl(tab_row).version_label IS NOT NULL THEN
2644: BEGIN
2645: SELECT meaning
2646: INTO p_instance_header_tbl(tab_row).version_label_meaning
2647: FROM csi_lookups
2648: WHERE lookup_code = p_instance_header_tbl(tab_row).version_label
2649: AND lookup_type = l_ver_label_lookup_type;
2650: EXCEPTION
2651: WHEN OTHERS THEN

Line 2909: FROM csi_lookups

2905: THEN
2906: BEGIN
2907: SELECT meaning
2908: INTO p_instance_header_tbl(tab_row).maintainable
2909: FROM csi_lookups
2910: WHERE lookup_code = DECODE(p_instance_header_tbl(tab_row).maintainable_flag,'Y','YES','N','NO')
2911: AND lookup_type = l_yesno_lookup_type;
2912: EXCEPTION WHEN OTHERS THEN
2913: NULL;