eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_FM_REQUEST_GRP dependencies on DUAL

Line 534: select fnd_lobs_s.nextval into x_query_file_id from dual;

530: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_QUERY_NOT_FOUND',p_query_id);
531: RAISE FND_API.G_EXC_ERROR;
532: ELSE
533:
534: select fnd_lobs_s.nextval into x_query_file_id from dual;
535: JTF_FM_UTL_V.PRINT_MESSAGE('GOT FILE ID SEQ from FND_LOBS '|| x_query_file_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
536: JTF_FM_UTL_V.PRINT_MESSAGE('Query Name is :'|| l_query_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
537: --JTF_FM_UTL_V.PRINT_MESSAGE('Query String is :'|| l_query_string,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
538: JTF_FM_UTL_V.PRINT_MESSAGE('Query ID is :'|| l_query_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

Line 3633: SELECT JTF_FM_REQUESTHISTID_S.NEXTVAL INTO x_request_id FROM DUAL;

3629: x_return_status := FND_API.G_RET_STS_SUCCESS;
3630:
3631: JTF_FM_UTL_V.PRINT_MESSAGE('Start_Request called by ' || to_number(FND_GLOBAL.USER_ID) ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
3632:
3633: SELECT JTF_FM_REQUESTHISTID_S.NEXTVAL INTO x_request_id FROM DUAL;
3634:
3635: -- Success message
3636: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3637: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');

Line 3780: -- Select end-of-line character from dual

3776:
3777: -- Standard begin of API savepoint
3778: SAVEPOINT Content_XML;
3779:
3780: -- Select end-of-line character from dual
3781: /* select chr(13) cr, chr(10) lf into b, c from dual;
3782: a:= b||c; */
3783: a := '';
3784:

Line 3781: /* select chr(13) cr, chr(10) lf into b, c from dual;

3777: -- Standard begin of API savepoint
3778: SAVEPOINT Content_XML;
3779:
3780: -- Select end-of-line character from dual
3781: /* select chr(13) cr, chr(10) lf into b, c from dual;
3782: a:= b||c; */
3783: a := '';
3784:
3785: -- Check for API version compatibility

Line 4957: from dual;

4953:
4954: --Modified the following query as per bug 3651321
4955: select to_number(decode(substrb(userenv('CLIENT_INFO'),1,1),' ',null,substrb(userenv('CLIENT_INFO'),1,10)))
4956: into l_org_id
4957: from dual;
4958:
4959: IF (p_request_id IS NULL) THEN
4960: l_Error_Msg := 'Must pass p_request_id parameter';
4961: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 4994: SELECT JTF_FM_REQUESTHISTID_S.NEXTVAL INTO x_request_id FROM DUAL;

4990: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_REQUEST_NOTFOUND' ,p_request_id);
4991: RAISE FND_API.G_EXC_ERROR;
4992: ELSE
4993: -- Get the new request id for the resubmitted Request
4994: SELECT JTF_FM_REQUESTHISTID_S.NEXTVAL INTO x_request_id FROM DUAL;
4995: -- Get the request and response queue names
4996:
4997: SELECT DECODE(l_request_type,'M', MASS_REQUEST_Q, 'B',BATCH_REQUEST_Q,'T',BATCH_REQUEST_Q, REQUEST_QUEUE_NAME)
4998: INTO l_request_queue

Line 5452: from dual;

5448:
5449: --Modified the foolowing query as per bug 3651321
5450: select to_number(decode(substrb(userenv('CLIENT_INFO'),1,1),' ',null,substrb(userenv('CLIENT_INFO'),1,10)))
5451: into l_org_id
5452: from dual;
5453:
5454: -- check if job id is present
5455: IF(p_job_id IS NULL or p_job_id = FND_API.G_MISS_NUM ) THEN
5456: l_ERROR_MSG := 'Must pass job id parmeter';

Line 5518: SELECT JTF_FM_REQUESTHISTID_S.NEXTVAL INTO x_request_id FROM DUAL;

5514: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_REQUEST_NOTFOUND' ,p_request_id);
5515: RAISE FND_API.G_EXC_ERROR;
5516: ELSE
5517: -- Get the new request id for the resubmitted Request
5518: SELECT JTF_FM_REQUESTHISTID_S.NEXTVAL INTO x_request_id FROM DUAL;
5519: -- Get the request and response queue names
5520:
5521: SELECT REQUEST_QUEUE_NAME
5522: INTO l_request_queue

Line 6642: -- SELECT JTF_FM_REQUESTHISTID_S.CURRVAL INTO l_attachment_id FROM DUAL;

6638: l_user_note_count := p_user_note.count;
6639: l_quantity_count := p_quantity.count;
6640: FOR i IN 1..p_content_id.count LOOP
6641: -- Get the Attachment_id based on the currval of the Sequence
6642: -- SELECT JTF_FM_REQUESTHISTID_S.CURRVAL INTO l_attachment_id FROM DUAL;
6643: l_message:='';
6644: l_message := l_message||'';
6645: l_message := l_message||'';
6646:

Line 6956: --INTO l_index FROM DUAL;

6952: JTF_FM_UTL_V.PRINT_MESSAGE (to_char(l_index),JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
6953:
6954: -- Get the greatest index of the last entry in all the address tables.
6955: --SELECT GREATEST(l_email_count, l_printer_count, l_file_path_count, l_fax_count)
6956: --INTO l_index FROM DUAL;
6957:
6958: IF (l_index = 0) THEN
6959: l_Error_Msg := 'Must pass batch address list';
6960: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN