DBA Data[Home] [Help]

APPS.OE_RETROBILL_PVT dependencies on OE_CONC_REQUEST_IFACE

Line 3329: -- This procedure gets the request_session_id from the UI and builds the pl/sql table from oe_conc_request_iface table and passes it to

3325: --bug5003256
3326: x_error_count := -1;
3327: End Process_Retrobill_Request;
3328:
3329: -- This procedure gets the request_session_id from the UI and builds the pl/sql table from oe_conc_request_iface table and passes it to
3330: -- Process_Retrobill_Request
3331:
3332: PROCEDURE Oe_Build_Retrobill_Tbl
3333: (

Line 3358: from oe_conc_request_iface

3354: numeric_attribute1,
3355: numeric_attribute2,
3356: numeric_attribute3,
3357: char_attribute1
3358: from oe_conc_request_iface
3359: where request_id = p_request_session_id
3360: FOR UPDATE NOWAIT;
3361:
3362: cursor c_open_retrobill_requests(c_header_id NUMBER,c_line_id NUMBER) is

Line 3495: Delete from oe_conc_request_iface where request_id =p_request_session_id;

3491: END IF;
3492:
3493: -- delete the data from temp table after retrobilling process
3494: IF(p_request_session_id is not NULL) THEN
3495: Delete from oe_conc_request_iface where request_id =p_request_session_id;
3496: END IF;
3497:
3498: x_retrobill_request_id := l_retrobill_request_id;
3499: x_msg_count := OE_MSG_PUB.Count_Msg;