APPS.CSD_MASS_RCV_PVT dependencies on FND_LOOKUPS

Line 2484: -- Validate the Action Type if it exists in fnd_lookups

2480: 'Validate action type'
2481: );
2482: END IF;
2483:
2484: -- Validate the Action Type if it exists in fnd_lookups
2485: IF NOT (csd_process_util.validate_action_type
2486: (p_action_type => p_product_txn_rec.action_type)
2487: )
2488: THEN

Line 2501: -- Validate the repair line ID if it exists in fnd_lookups

2497: 'Validate action code'
2498: );
2499: END IF;
2500:
2501: -- Validate the repair line ID if it exists in fnd_lookups
2502: IF NOT (csd_process_util.validate_action_code
2503: (p_action_code => p_product_txn_rec.action_code)
2504: )
2505: THEN

Line 2564: -- Validate the PROD_TXN_STATUS if it exists in fnd_lookups

2560: || p_product_txn_rec.prod_txn_status
2561: );
2562: END IF;
2563:
2564: -- Validate the PROD_TXN_STATUS if it exists in fnd_lookups
2565: IF (p_product_txn_rec.prod_txn_status IS NOT NULL)
2566: AND (p_product_txn_rec.prod_txn_status <> fnd_api.g_miss_char)
2567: THEN
2568: BEGIN

Line 2571: FROM fnd_lookups

2567: THEN
2568: BEGIN
2569: SELECT 'X'
2570: INTO l_check
2571: FROM fnd_lookups
2572: WHERE lookup_type = 'CSD_PRODUCT_TXN_STATUS'
2573: AND lookup_code = p_product_txn_rec.prod_txn_status;
2574: EXCEPTION
2575: WHEN OTHERS