DBA Data[Home] [Help]

APPS.PON_RESPONSE_IMPORT_PKG dependencies on PO_UDA_INTERFACE

Line 3401: select count(*) into l_rec_count from po_uda_interface

3397: l_data_present Boolean;
3398: l_rec_count Number;
3399: begin
3400: l_data_present := TRUE;
3401: select count(*) into l_rec_count from po_uda_interface
3402: where pk1_value = p_bid_number and pk2_value = p_line_number and process_status=1;
3403: if ( l_rec_count = 0 ) THEN
3404: l_data_present := FALSE;
3405: end if;

Line 3413: p_transaction_id IN po_uda_interface.transaction_id%TYPE,

3409: PROCEDURE process_spreadsheet_uda_data
3410: (
3411: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
3412: --bug 16654950
3413: p_transaction_id IN po_uda_interface.transaction_id%TYPE,
3414: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3415: p_request_id IN pon_bid_headers.request_id%TYPE,
3416: p_userid IN pon_interface_errors.created_by%TYPE,
3417: x_return_status OUT NOCOPY VARCHAR2