APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_WARRANTY_TEMPLATES_B

Line 1288: p_warranty_template_name IN AHL_WARRANTY_TEMPLATES_B.name%TYPE,

1284: PROCEDURE validate_warr_template_name
1285: (
1286: x_return_status OUT NOCOPY VARCHAR2,
1287: x_msg_data OUT NOCOPY VARCHAR2,
1288: p_warranty_template_name IN AHL_WARRANTY_TEMPLATES_B.name%TYPE,
1289: p_x_warranty_template_id IN OUT NOCOPY NUMBER
1290: )
1291: IS
1292: --

Line 1293: CURSOR get_rec_from_value ( c_warranty_template_name AHL_WARRANTY_TEMPLATES_B.name%TYPE ) IS

1289: p_x_warranty_template_id IN OUT NOCOPY NUMBER
1290: )
1291: IS
1292: --
1293: CURSOR get_rec_from_value ( c_warranty_template_name AHL_WARRANTY_TEMPLATES_B.name%TYPE ) IS
1294: SELECT warranty_template_id
1295: FROM AHL_WARRANTY_TEMPLATES_B
1296: WHERE name = c_warranty_template_name
1297: AND enabled_flag = 'Y';

Line 1295: FROM AHL_WARRANTY_TEMPLATES_B

1291: IS
1292: --
1293: CURSOR get_rec_from_value ( c_warranty_template_name AHL_WARRANTY_TEMPLATES_B.name%TYPE ) IS
1294: SELECT warranty_template_id
1295: FROM AHL_WARRANTY_TEMPLATES_B
1296: WHERE name = c_warranty_template_name
1297: AND enabled_flag = 'Y';
1298: --
1299: CURSOR get_rec_from_id ( c_warranty_template_id NUMBER ) IS

Line 1301: FROM AHL_WARRANTY_TEMPLATES_B

1297: AND enabled_flag = 'Y';
1298: --
1299: CURSOR get_rec_from_id ( c_warranty_template_id NUMBER ) IS
1300: SELECT warranty_template_id
1301: FROM AHL_WARRANTY_TEMPLATES_B
1302: WHERE warranty_template_id = c_warranty_template_id
1303: AND enabled_flag = 'Y';
1304: --
1305: l_warranty_template_id AHL_WARRANTY_TEMPLATES_B.name%TYPE;

Line 1305: l_warranty_template_id AHL_WARRANTY_TEMPLATES_B.name%TYPE;

1301: FROM AHL_WARRANTY_TEMPLATES_B
1302: WHERE warranty_template_id = c_warranty_template_id
1303: AND enabled_flag = 'Y';
1304: --
1305: l_warranty_template_id AHL_WARRANTY_TEMPLATES_B.name%TYPE;
1306: --
1307: BEGIN
1308:
1309: -- Initialize Procedure return status to success