DBA Data[Home] [Help]

APPS.ARI_DB_UTILITIES dependencies on FND_CONCURRENT_REQUESTS

Line 982: from fnd_concurrent_requests fcr,

978:
979: /* Verify that the request belongs to this user */
980:
981: select 'Y' into l_valid_user
982: from fnd_concurrent_requests fcr,
983: fnd_concurrent_programs fcp
984: where fcr.request_id = p_request_id
985: and fcr.requested_by = p_user_id
986: and fcp.concurrent_program_id = fcr.concurrent_program_id

Line 993: from fnd_concurrent_requests

989: /* Get the request status */
990:
991: if (l_valid_user = 'Y') then
992: select status_code into l_status
993: from fnd_concurrent_requests
994: where request_id = p_request_id;
995: end if;
996:
997: p_status := l_status;

Line 1664: | table data matching the purge process of FND_CONCURRENT_REQUESTS table.

1660: | PUBLIC procedure PURGE_IREC_PRINT_REQUESTS
1661: |
1662: | DESCRIPTION
1663: | This procedure submits cuncurrent request to purge AR_IREC_PRINT_REQUESTS
1664: | table data matching the purge process of FND_CONCURRENT_REQUESTS table.
1665: | --------------------------------------------------------------------
1666: |
1667: | PSEUDO CODE/LOGIC
1668: |

Line 1705: select min(request_date) into l_fnd_request_date from fnd_concurrent_requests;

1701: fnd_file.put_line( FND_FILE.LOG, 'Begin Procedure ' || l_procedure_name);
1702: fnd_file.put_line( FND_FILE.LOG, '+---------------------------------------------------------------------------+');
1703:
1704: if(p_creation_date is NULL) then
1705: select min(request_date) into l_fnd_request_date from fnd_concurrent_requests;
1706: else
1707: l_fnd_request_date := FND_CONC_DATE.STRING_TO_DATE(p_creation_date); /* Convert character string to date */
1708: if(l_fnd_request_date is NULL) then
1709: