APPS.CS_SERVICEREQUEST_UTIL dependencies on CS_LOOKUPS

Line 2902: -- agains cs_lookups

2898: -- If 1 or more records are found
2899: -- then verify whether the given problem code is present in the records
2900: -- Raise error if no problem code matches the given problem code
2901: -- If 0 records are found in the Query, then validate the given problem code
2902: -- agains cs_lookups
2903: -- --------------------------------------------------------------------------------
2904: -- DJ API Cleanup
2905: -- Changed the validation of Problem code to invoke the problem code
2906: -- validation api cs_sr_prob_code_mapping_pkg.validate_problem_code

Line 4942: FROM CS_LOOKUPS

4938: -- Initialize the return status.
4939: x_return_status := FND_API.G_RET_STS_SUCCESS;
4940:
4941: SELECT 'x' INTO l_dummy
4942: FROM CS_LOOKUPS
4943: WHERE lookup_code = UPPER(p_sr_creation_channel)
4944: AND lookup_type = 'CS_SR_CREATION_CHANNEL'
4945: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
4946: AND TRUNC(NVL(end_date_active, SYSDATE)) ;

Line 5188: FROM CS_LOOKUPS

5184: -- Initialize the return status.
5185: x_return_status := FND_API.G_RET_STS_SUCCESS;
5186:
5187: SELECT 'x' INTO l_test
5188: FROM CS_LOOKUPS
5189: WHERE lookup_code = UPPER(p_contact_type)
5190: AND (lookup_type = 'CS_SR_CONTACT_TYPES')
5191: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
5192: AND TRUNC(NVL(end_date_active, SYSDATE))

Line 5616: FROM CS_LOOKUPS

5612: x_return_status := FND_API.G_RET_STS_SUCCESS;
5613:
5614: -- Verify the request CP against the database.
5615: SELECT 'x' INTO l_dummy
5616: FROM CS_LOOKUPS
5617: WHERE lookup_code = UPPER(p_source_program_code)
5618: AND lookup_type = 'CS_SR_SOURCE_PROGRAMS'
5619: AND enabled_flag = 'Y'
5620: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))

Line 5678: FROM CS_LOOKUPS

5674: x_return_status := FND_API.G_RET_STS_SUCCESS;
5675:
5676: -- Verify the request CP against the database.
5677: SELECT 'x' INTO l_dummy
5678: FROM CS_LOOKUPS
5679: WHERE lookup_code = UPPER(p_INC_DIST_QUAL_UOM)
5680: AND lookup_type = 'CS_SR_DISTANCE_UOM'
5681: AND enabled_flag = 'Y'
5682: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))

Line 5745: FROM CS_LOOKUPS

5741: x_return_status := FND_API.G_RET_STS_SUCCESS;
5742:
5743: -- Verify the request CP against the database.
5744: SELECT 'x' INTO l_dummy
5745: FROM CS_LOOKUPS
5746: WHERE lookup_code = UPPER(p_INC_DIRECTION_QUAL)
5747: AND lookup_type = 'CS_SR_DIRECTIONS'
5748: AND enabled_flag = 'Y'
5749: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))