APPS.CS_SERVICEREQUEST_UTIL dependencies on CS_LOOKUPS

Line 2900: -- agains cs_lookups

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

Line 4940: FROM CS_LOOKUPS

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

Line 5186: FROM CS_LOOKUPS

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

Line 5614: FROM CS_LOOKUPS

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

Line 5676: FROM CS_LOOKUPS

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

Line 5743: FROM CS_LOOKUPS

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