579: /*END, Bgowrava for forward porting bug#5989740*/
580:
581: /* Bug4562791. Added by Lakshmi Gopalsami */
582: CURSOR c_conc_request_submit_date
583: (cp_Request_id FND_CONCURRENT_REQUESTS.REQUEST_ID%TYPE) IS
584: SELECT REQUEST_DATE
585: FROM FND_CONCURRENT_REQUESTS
586: WHERE request_id = cp_Request_id;
587:
581: /* Bug4562791. Added by Lakshmi Gopalsami */
582: CURSOR c_conc_request_submit_date
583: (cp_Request_id FND_CONCURRENT_REQUESTS.REQUEST_ID%TYPE) IS
584: SELECT REQUEST_DATE
585: FROM FND_CONCURRENT_REQUESTS
586: WHERE request_id = cp_Request_id;
587:
588: ld_request_submit_Date FND_CONCURRENT_REQUESTS.REQUEST_DATE%TYPE;
589:
584: SELECT REQUEST_DATE
585: FROM FND_CONCURRENT_REQUESTS
586: WHERE request_id = cp_Request_id;
587:
588: ld_request_submit_Date FND_CONCURRENT_REQUESTS.REQUEST_DATE%TYPE;
589:
590: /* Bug 5243532. Added by Lakshmi Gopalsami
591: * Define variable for implementing caching logic.
592: */