APPS.PAY_BEE_SS dependencies on FND_CONCURRENT_REQUESTS

Line 1105: select PHASE_CODE into l_phase_code from fnd_concurrent_requests where request_id=l_request_id;

1101: ,p_batch_id =>l_batch_id);
1102:
1103: -- bee_trace('Request id for validation is '||l_request_id);
1104: -- bee_trace('Request id is ' || l_request_id );
1105: select PHASE_CODE into l_phase_code from fnd_concurrent_requests where request_id=l_request_id;
1106:
1107: -- bee_trace('Initial phase cose is '||l_phase_code);
1108:
1109: --if l_phase_code='P' then

Line 1118: select PHASE_CODE into l_phase_code from fnd_concurrent_requests where request_id=l_request_id;

1114: --end if;
1115: while (l_phase_code<>'C')
1116: loop
1117: dbms_lock.sleep(5);
1118: select PHASE_CODE into l_phase_code from fnd_concurrent_requests where request_id=l_request_id;
1119: -- bee_trace('Phase code is '||l_phase_code);
1120: end loop;
1121:
1122: open batch_validation_messages_cur;

Line 1790: select PHASE_CODE into l_phase_code from fnd_concurrent_requests where request_id=l_request_id;

1786:
1787: -- bee_trace('Req id of actual transfer is '||l_request_id);
1788:
1789:
1790: select PHASE_CODE into l_phase_code from fnd_concurrent_requests where request_id=l_request_id;
1791:
1792: -- bee_trace('Initial phase cose is '||l_phase_code);
1793:
1794:

Line 1799: select PHASE_CODE into l_phase_code from fnd_concurrent_requests where request_id=l_request_id;

1795:
1796: while (l_phase_code<>'C')
1797: loop
1798: dbms_lock.sleep(5);
1799: select PHASE_CODE into l_phase_code from fnd_concurrent_requests where request_id=l_request_id;
1800: -- bee_trace('Phase code is '||l_phase_code);
1801: end loop;
1802:
1803: