DBA Data[Home] [Help]

APPS.OE_RETROBILL_PVT dependencies on OE_CONC_REQUEST_IFACE

Line 3715: -- 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

3711: --bug5003256
3712: x_error_count := -1;
3713: End Process_Retrobill_Request;
3714:
3715: -- 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
3716: -- Process_Retrobill_Request
3717:
3718: PROCEDURE Oe_Build_Retrobill_Tbl
3719: (

Line 3744: from oe_conc_request_iface

3740: numeric_attribute1,
3741: numeric_attribute2,
3742: numeric_attribute3,
3743: char_attribute1
3744: from oe_conc_request_iface
3745: where request_id = p_request_session_id
3746: FOR UPDATE NOWAIT;
3747:
3748: cursor c_open_retrobill_requests(c_header_id NUMBER,c_line_id NUMBER) is

Line 3886: Delete from oe_conc_request_iface where request_id =p_request_session_id;

3882: END IF;
3883:
3884: -- delete the data from temp table after retrobilling process
3885: IF(p_request_session_id is not NULL) THEN
3886: Delete from oe_conc_request_iface where request_id =p_request_session_id;
3887: END IF;
3888:
3889: x_retrobill_request_id := l_retrobill_request_id;
3890: x_msg_count := OE_MSG_PUB.Count_Msg;