APPS.JTF_FM_OCM_REND_REQ dependencies on JTF_FM_TEST_REQUESTS

Line 342: SELECT DISTINCT COUNT(REQUEST_ID) INTO l_req_count FROM JTF_FM_TEST_REQUESTS

338:
339: -- First we need to determine whether this is a test request or a
340: -- normal request, as the rules for determining the file id are different.
341:
342: SELECT DISTINCT COUNT(REQUEST_ID) INTO l_req_count FROM JTF_FM_TEST_REQUESTS
343: WHERE REQUEST_ID = p_request_id ;
344:
345: BEGIN
346: IF l_req_count > 0 THEN

Line 1041: SELECT DISTINCT COUNT(REQUEST_ID) INTO l_req_count FROM JTF_FM_TEST_REQUESTS

1037:
1038: -- Query to detemine if this is a test account as the rules for determining
1039: -- content item versions differ between test requests and regular requests
1040:
1041: SELECT DISTINCT COUNT(REQUEST_ID) INTO l_req_count FROM JTF_FM_TEST_REQUESTS
1042: WHERE REQUEST_ID = p_request_id ;
1043:
1044:
1045: BEGIN

Line 1348: DELETE FROM JTF_FM_TEST_REQUESTS WHERE REQUEST_ID = p_request_id;

1344: x_html := x_html || '' || a;
1345: --SPLIT_LINE(x_html,80);
1346: end if;
1347:
1348: DELETE FROM JTF_FM_TEST_REQUESTS WHERE REQUEST_ID = p_request_id;
1349:
1350: JTF_FM_UTL_V.PRINT_MESSAGE('End GET_OCM_REND_DETAILS',
1351: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1352:

Line 2034: INSERT INTO JTF_FM_TEST_REQUESTS (REQUEST_ID) VALUES (x_request_history_id);

2030: know about REQUEST_TYPE 'T'
2031: **/
2032: IF (upper(p_fulfill_electronic_rec.request_type) = 'T') THEN
2033: JTF_FM_UTL_V.PRINT_MESSAGE('THE REQUEST TYPE IS TEST',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
2034: INSERT INTO JTF_FM_TEST_REQUESTS (REQUEST_ID) VALUES (x_request_history_id);
2035: END IF;
2036:
2037: /********************************************************
2038: Following modifications were made for Label but