eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INL_INTERFACE_PVT dependencies on INL_MATCHES

Line 340: ELSIF p_parent_table_name = 'INL_MATCHES_INT' THEN

336: INTO l_ship_header_int_id
337: FROM inl_ship_lines_int
338: WHERE ship_line_int_id = p_parent_table_id;
339: /* --Bug#11794442 made in procedure Run_MatchPreProcessor
340: ELSIF p_parent_table_name = 'INL_MATCHES_INT' THEN
341: l_debug_info := 'Set Match Interface status to ERROR.';
342: INL_LOGGING_PVT.Log_Statement(
343: p_module_name => g_module_name,
344: p_procedure_name => l_program_name,

Line 347: UPDATE inl_matches_int

343: p_module_name => g_module_name,
344: p_procedure_name => l_program_name,
345: p_debug_info => l_debug_info) ;
346:
347: UPDATE inl_matches_int
348: SET processing_status_code = 'ERROR' ,
349: request_id = L_FND_CONC_REQUEST_ID,
350: last_updated_by = L_FND_USER_ID ,
351: last_update_date = SYSDATE ,

Line 8098: -- Function : Delete a LCM Shipment from inl_ship_holds, inl_associations, inl_matches, inl_match_amount

8094: END Validate_HdrTrxType;
8095:
8096: -- Utility name : Delete_Ship
8097: -- Type : Private
8098: -- Function : Delete a LCM Shipment from inl_ship_holds, inl_associations, inl_matches, inl_match_amount
8099: -- inl_allocations, inl_tax_lines, inl_charge_lines,
8100: -- inl_ship_lines_all, inl_ship_line_groups and inl_ship_headers_all
8101: -- If a Charge/Tax is associated with more than one Shipment, only the associations
8102: -- of the current shipment are going to be deleted

Line 8161: FROM inl_matches m

8157: p_debug_info => l_debug_info) ;
8158:
8159: DELETE FROM inl_match_amounts ma
8160: WHERE EXISTS (SELECT 1
8161: FROM inl_matches m
8162: WHERE m.ship_header_id = p_ship_header_id
8163: AND ma.match_amount_id = m.match_amount_id
8164: )
8165: AND NOT EXISTS (SELECT 1

Line 8166: FROM inl_matches m

8162: WHERE m.ship_header_id = p_ship_header_id
8163: AND ma.match_amount_id = m.match_amount_id
8164: )
8165: AND NOT EXISTS (SELECT 1
8166: FROM inl_matches m
8167: WHERE m.ship_header_id <> p_ship_header_id
8168: AND ma.match_amount_id = m.match_amount_id
8169: )
8170: ;

Line 8179: -- Table inl_matches

8175: p_var_name => 'sql%rowcount',
8176: p_var_value => sql%rowcount
8177: );
8178:
8179: -- Table inl_matches
8180: -- Bug#9279355
8181: l_debug_info := 'Delete inl_matches';
8182: INL_LOGGING_PVT.Log_Statement(
8183: p_module_name => g_module_name,

Line 8181: l_debug_info := 'Delete inl_matches';

8177: );
8178:
8179: -- Table inl_matches
8180: -- Bug#9279355
8181: l_debug_info := 'Delete inl_matches';
8182: INL_LOGGING_PVT.Log_Statement(
8183: p_module_name => g_module_name,
8184: p_procedure_name => l_program_name,
8185: p_debug_info => l_debug_info) ;

Line 8187: DELETE FROM inl_matches m

8183: p_module_name => g_module_name,
8184: p_procedure_name => l_program_name,
8185: p_debug_info => l_debug_info) ;
8186:
8187: DELETE FROM inl_matches m
8188: WHERE m.ship_header_id = p_ship_header_id;
8189:
8190: INL_LOGGING_PVT.Log_Variable(
8191: p_module_name => g_module_name,

Line 9590: FROM inl_matches

9586: p_debug_info => l_debug_info
9587: ) ;
9588: SELECT MIN(match_id)
9589: INTO x_parent_match_id
9590: FROM inl_matches
9591: WHERE to_parent_table_id = p_to_parent_table_id
9592: AND to_parent_table_name = p_to_parent_table_name
9593: AND from_parent_table_id = p_from_parent_table_id
9594: AND from_parent_table_name = p_from_parent_table_name

Line 9669: -- are recorded in interface tables by the INL_MATCHES_GRP package

9665: --
9666: -- Version : Current version 1.0
9667: --
9668: -- Notes : When the information come from AP the amounts variations
9669: -- are recorded in interface tables by the INL_MATCHES_GRP package
9670: -- and the adjustment program wait for final amounts.
9671: -- In order to equalize the information in this proc we:
9672: -- - receive the values of the new match
9673: PROCEDURE Derive_FromAP(

Line 9822: inl_matches mat1,

9818: l_mat_par_mat_id_P ,
9819: l_corr_from_parent_table_name,
9820: l_corr_from_parent_table_id
9821: FROM
9822: inl_matches mat1,
9823: (select *
9824: from inl_matches m2
9825: where NOT (m2.from_parent_table_name = p_from_parent_table_name
9826: AND m2.from_parent_table_id = p_from_parent_table_id)

Line 9824: from inl_matches m2

9820: l_corr_from_parent_table_id
9821: FROM
9822: inl_matches mat1,
9823: (select *
9824: from inl_matches m2
9825: where NOT (m2.from_parent_table_name = p_from_parent_table_name
9826: AND m2.from_parent_table_id = p_from_parent_table_id)
9827: ) mat2
9828: WHERE

Line 9836: FROM inl_matches mat1B

9832: AND mat1.from_parent_table_id = x_new_to_parent_table_id
9833: AND mat1.match_id
9834: =(
9835: SELECT MAX(mat1B.match_id)
9836: FROM inl_matches mat1B
9837: WHERE mat1B.to_parent_table_name = mat1.to_parent_table_name
9838: AND mat1B.to_parent_table_id = mat1.to_parent_table_id
9839: AND mat1B.from_parent_table_name = mat1.from_parent_table_name
9840: AND mat1B.from_parent_table_id = mat1.from_parent_table_id

Line 9847: FROM inl_matches mat1C,

9843: OR mat2.match_id = mat1.match_id
9844: OR mat2.match_id
9845: =(
9846: SELECT MAX(DECODE(mat2.match_id, mat1.match_id, NULL, mat2.match_id))
9847: FROM inl_matches mat1C,
9848: inl_matches mat2C
9849: WHERE mat2C.parent_match_id (+) = mat1C.match_id
9850: AND mat2C.match_type_code (+) = 'CORRECTION'
9851: AND NOT (mat2C.from_parent_table_name = p_from_parent_table_name

Line 9848: inl_matches mat2C

9844: OR mat2.match_id
9845: =(
9846: SELECT MAX(DECODE(mat2.match_id, mat1.match_id, NULL, mat2.match_id))
9847: FROM inl_matches mat1C,
9848: inl_matches mat2C
9849: WHERE mat2C.parent_match_id (+) = mat1C.match_id
9850: AND mat2C.match_type_code (+) = 'CORRECTION'
9851: AND NOT (mat2C.from_parent_table_name = p_from_parent_table_name
9852: AND mat2C.from_parent_table_id = p_from_parent_table_id)

Line 10056: FROM inl_matches

10052: WHERE tax_line_id = x_new_to_parent_table_id;
10053: ELSE -- In case of correction, the table is out of LCM limit
10054: SELECT ship_header_id
10055: INTO x_ship_header_id
10056: FROM inl_matches
10057: WHERE match_id = l_mat_par_mat_id_P;
10058: END IF;
10059: --
10060: -- Standard End of Procedure/Function Logging

Line 10215: FROM inl_matches m

10211: p_debug_info => l_debug_info
10212: ) ;
10213: SELECT COUNT(*)
10214: INTO l_count_unproc_match
10215: FROM inl_matches m
10216: WHERE m.ship_header_id = p_ship_header_id
10217: AND NVL(m.adj_already_generated_flag, 'N') = 'N';
10218:
10219: l_debug_info := p_ship_header_id||' => '|| l_count_unproc_match ||' unprocessed match(es) ';

Line 10322: FROM inl_matches_int mi,

10318: IS
10319: SELECT
10320: MIN(DECODE(mp.process_enabled_flag,'Y',NVL(mi.adj_group_date,p_initial_sysdate),p_initial_sysdate)) adj_group_date, -- OPM Integration
10321: mi.group_id
10322: FROM inl_matches_int mi,
10323: rcv_transactions rt, -- OPM Integration
10324: mtl_parameters mp
10325: WHERE mi.processing_status_code = 'RUNNING' /* Point 1: If any change occur here the other 4 points might be affected */
10326: AND (p_group_id IS NULL

Line 10364: FROM inl_matches_int mi,

10360: mi.transaction_type,
10361: mi.group_id, --BUG#8264388
10362: mi.charge_line_type_id, --BUG#8264388
10363: mi.tax_code --BUG#8264388
10364: FROM inl_matches_int mi,
10365: rcv_transactions rt, -- OPM Integration
10366: mtl_parameters mp -- OPM Integration
10367: WHERE mi.processing_status_code = 'RUNNING'
10368: AND ((pc_group_id IS NULL AND mi.group_id IS NULL)

Line 10420: FROM inl_matches_int mi,

10416: NULL ship_header_id ,
10417: NULL org_id , --Bug#10381495
10418: mi.match_amounts_flag , --BUG#8264388
10419: mi.group_id --BUG#8264388
10420: FROM inl_matches_int mi,
10421: rcv_transactions rt, -- OPM Integration
10422: mtl_parameters mp
10423: WHERE mi.processing_status_code = 'RUNNING' /* Point 1: If any change occur here the other 4 points might be affected */
10424: AND ((pc_group_id IS NULL AND mi.group_id IS NULL)

Line 10442: inl_matches_int mi,

10438: CURSOR c_shipToProcess(pc_group_id NUMBER)IS
10439: SELECT sh.ship_num
10440: FROM inl_ship_lines sl,
10441: inl_ship_headers sh,
10442: inl_matches_int mi,
10443: rcv_transactions rt
10444: WHERE sh.ship_header_id = sl.ship_header_id
10445: AND sl.ship_line_id = rt.lcm_shipment_line_id
10446: AND mi.to_parent_table_name = 'RCV_TRANSACTIONS'

Line 10558: UPDATE inl_matches_int mi

10554: FND_MSG_PUB.ADD;
10555:
10556: l_debug_info := 'Set Interface Status to PENDING for group id: '||distgroupid_List(iGroup).group_id;
10557:
10558: UPDATE inl_matches_int mi
10559: SET mi.processing_status_code = 'PENDING',
10560: mi.request_id = L_FND_CONC_REQUEST_ID,
10561: mi.last_updated_by = L_FND_USER_ID,
10562: mi.last_update_date = SYSDATE,

Line 10768: SELECT inl_matches_s.NEXTVAL

10764: p_debug_info => l_debug_info
10765: ) ;
10766: RAISE L_FND_EXC_UNEXPECTED_ERROR;
10767: ELSE
10768: SELECT inl_matches_s.NEXTVAL
10769: INTO matchesToProcess_List(iMatch).new_match_id
10770: FROM dual; -- BUG#8411723 => MURALI
10771:
10772: INSERT INTO inl_matches(

Line 10772: INSERT INTO inl_matches(

10768: SELECT inl_matches_s.NEXTVAL
10769: INTO matchesToProcess_List(iMatch).new_match_id
10770: FROM dual; -- BUG#8411723 => MURALI
10771:
10772: INSERT INTO inl_matches(
10773: match_id , /* 01 */
10774: adj_group_date , /* 01A*/ --OPM Integration
10775: match_type_code , /* 02 */
10776: ship_header_id , /* 03 */

Line 10887: UPDATE inl_matches_int m

10883: p_debug_info => l_debug_info
10884: ) ;
10885: -- Set processing status to COMPLETED for
10886: -- the current and imported Match Line
10887: UPDATE inl_matches_int m
10888: SET m.processing_status_code = 'COMPLETED' ,
10889: m.request_id = L_FND_CONC_REQUEST_ID,
10890: m.last_updated_by = L_FND_USER_ID ,
10891: m.last_update_date = SYSDATE ,

Line 10980: UPDATE inl_matches_int mi

10976: p_module_name => g_module_name,
10977: p_procedure_name => l_program_name,
10978: p_debug_info => l_debug_info
10979: );
10980: UPDATE inl_matches_int mi
10981: SET mi.processing_status_code = 'ERROR' ,
10982: mi.request_id = L_FND_CONC_REQUEST_ID ,
10983: mi.last_updated_by = L_FND_USER_ID ,
10984: mi.last_update_date = SYSDATE ,

Line 11160: FROM inl_matches

11156: AND p_match_type_code = 'CORRECTION'
11157: THEN
11158: SELECT MIN(match_id)
11159: INTO p_parent_match_id
11160: FROM inl_matches
11161: WHERE from_parent_table_id = p_to_parent_table_id
11162: AND from_parent_table_name = p_to_parent_table_name
11163: ;
11164: END IF;

Line 11253: p_parent_table_name => 'INL_MATCHES_INT',

11249: IF p_charge_line_type_id IS NULL THEN
11250: l_result := L_FND_FALSE;
11251: -- Add a line into inl_ship_errors
11252: Handle_InterfError(
11253: p_parent_table_name => 'INL_MATCHES_INT',
11254: p_parent_table_id => p_match_int_id,
11255: p_column_name => 'CHARGE_LINE_TYPE_ID',
11256: p_column_value => p_charge_line_type_id,
11257: p_error_message_name => 'INL_ERR_OI_MAT_CH_LN_TP_ID_N',

Line 11295: p_parent_table_name => 'INL_MATCHES_INT',

11291: IF l_debug_info IS NOT NULL THEN
11292: l_result := L_FND_FALSE;
11293: -- Add a line into inl_ship_errors
11294: Handle_InterfError(
11295: p_parent_table_name => 'INL_MATCHES_INT',
11296: p_parent_table_id => p_match_int_id,
11297: p_column_name => 'CHARGE_LINE_TYPE_ID',
11298: p_column_value => p_charge_line_type_id,
11299: p_error_message_name => l_debug_info,

Line 11317: p_parent_table_name => 'INL_MATCHES_INT',

11313: THEN
11314: l_result := L_FND_FALSE;
11315: -- Add a line into inl_ship_errors
11316: Handle_InterfError(
11317: p_parent_table_name => 'INL_MATCHES_INT',
11318: p_parent_table_id => p_match_int_id,
11319: p_column_name => 'CHARGE_LINE_TYPE_ID',
11320: p_column_value => p_charge_line_type_id,
11321: p_error_message_name => 'INL_ERR_OI_MAT_CH_LN_TP_ID_NN',

Line 11418: p_parent_table_name => 'INL_MATCHES_INT',

11414: IF NVL(p_parent_match_type_code, p_match_type_code) <> 'ITEM' THEN
11415: l_result := L_FND_FALSE;
11416: -- Add a line into inl_ship_errors
11417: Handle_InterfError(
11418: p_parent_table_name => 'INL_MATCHES_INT',
11419: p_parent_table_id => p_match_int_id,
11420: p_column_name => 'REPLACE_ESTIM_QTY_FLAG',
11421: p_column_value => p_replace_estim_qty_flag,
11422: p_error_message_name => 'INL_ERR_OI_CHK_RPL_EST_QT_FLAG',

Line 11538: FROM inl_matches_int m1

11534: m1.match_int_id ,
11535: m1.matched_qty ,
11536: m1.matched_uom_code ,
11537: m1.replace_estim_qty_flag
11538: FROM inl_matches_int m1
11539: WHERE m1.to_parent_table_name = 'INL_SHIP_LINES'
11540: AND m1.to_parent_table_id = p_ship_line_id
11541: AND m1.match_int_id <> NVL(p_updated_match_id, 0)
11542: AND m1.processing_status_code = 'RUNNING'

Line 11906: p_parent_table_name => 'INL_MATCHES_INT',

11902: p_debug_info => l_debug_info
11903: );
11904: -- Add a line into inl_ship_errors
11905: Handle_InterfError(
11906: p_parent_table_name => 'INL_MATCHES_INT',
11907: p_parent_table_id => p_match_int_id,
11908: p_column_name => 'MATCHED_QTY',
11909: p_column_value => p_matched_qty,
11910: p_error_message_name => 'INL_ERR_OI_MAT_INSUF_EST_QTY',

Line 12025: p_parent_table_name => 'INL_MATCHES_INT',

12021: THEN
12022: l_result := L_FND_FALSE;
12023: -- Add a line into inl_ship_errors
12024: Handle_InterfError(
12025: p_parent_table_name => 'INL_MATCHES_INT',
12026: p_parent_table_id => p_match_int_id,
12027: p_column_name => 'NREC_TAX_AMT',
12028: p_column_value => p_nrec_tax_amt,
12029: p_error_message_name => 'INL_ERR_OI_CHK_NREC_TAX_AMT',

Line 12049: p_parent_table_name => 'INL_MATCHES_INT',

12045: IF p_tax_code IS NULL THEN
12046: l_result := L_FND_FALSE;
12047: -- Add a line into inl_ship_errors
12048: Handle_InterfError(
12049: p_parent_table_name => 'INL_MATCHES_INT',
12050: p_parent_table_id => p_match_int_id,
12051: p_column_name => 'TAX_CODE',
12052: p_column_value => p_tax_code,
12053: p_error_message_name => 'INL_ERR_OI_CHK_TX_CODE_NULL',

Line 12073: p_parent_table_name => 'INL_MATCHES_INT',

12069: IF p_tax_amt_included_flag IS NULL THEN
12070: l_result := L_FND_FALSE;
12071: -- Add a line into inl_ship_errors
12072: Handle_InterfError(
12073: p_parent_table_name => 'INL_MATCHES_INT',
12074: p_parent_table_id => p_match_int_id,
12075: p_column_name => 'TAX_AMT_INCLUDED_FLAG',
12076: p_column_value => p_tax_amt_included_flag,
12077: p_error_message_name => 'INL_ERR_OI_CHK_TX_AMT_FLG_NULL',

Line 12091: p_parent_table_name => 'INL_MATCHES_INT',

12087: ELSIF p_tax_amt_included_flag IS NOT NULL OR p_tax_code IS NOT NULL OR NVL(p_nrec_tax_amt, 0) <> 0 THEN
12088: l_result := L_FND_FALSE;
12089: -- Add a line into inl_ship_errors
12090: Handle_InterfError(
12091: p_parent_table_name => 'INL_MATCHES_INT',
12092: p_parent_table_id => p_match_int_id,
12093: p_column_name => 'TAX_INT_ID',
12094: p_column_value => p_match_int_id,
12095: p_error_message_name => 'INL_ERR_OI_CHK_TX_FIELD_NNULL',

Line 12200: p_parent_table_name => 'INL_MATCHES_INT',

12196: IF p_parent_matched_curr_code <> p_matched_curr_code THEN
12197: l_result := L_FND_FALSE;
12198: -- Add a line into inl_ship_errors
12199: Handle_InterfError(
12200: p_parent_table_name => 'INL_MATCHES_INT',
12201: p_parent_table_id => p_match_int_id,
12202: p_column_name => 'MATCHED_AMT',
12203: p_column_value => p_matched_amt,
12204: p_error_message_name => 'INL_ERR_OI_CHK_CURR_INV',

Line 12230: p_parent_table_name => 'INL_MATCHES_INT',

12226: THEN
12227: l_result := L_FND_FALSE;
12228: -- Add a line into inl_ship_errors
12229: Handle_InterfError(
12230: p_parent_table_name => 'INL_MATCHES_INT',
12231: p_parent_table_id => p_match_int_id,
12232: p_column_name => 'MATCHED_AMT',
12233: p_column_value => p_matched_amt,
12234: p_error_message_name => 'INL_ERR_OI_CHK_AMT_NULL',

Line 12472: p_parent_table_name => 'INL_MATCHES_INT',

12468: p_var_value => l_new_txn_unit_price);
12469: l_result := L_FND_FALSE;
12470: -- Add a line into inl_ship_errors
12471: Handle_InterfError(
12472: p_parent_table_name => 'INL_MATCHES_INT',
12473: p_parent_table_id => p_match_int_id,
12474: p_column_name => 'p_match_int_id',
12475: p_column_value => p_match_int_id,
12476: p_error_message_name => 'INL_ERR_OI_CHK_ELC_UPDATE',

Line 12628: p_parent_table_name => 'INL_MATCHES_INT',

12624: p_var_value => l_count_elc_ong);
12625: l_result := L_FND_FALSE;
12626: -- Add a line into inl_ship_errors
12627: Handle_InterfError(
12628: p_parent_table_name => 'INL_MATCHES_INT',
12629: p_parent_table_id => p_match_int_id,
12630: p_column_name => 'p_match_int_id',
12631: p_column_value => p_match_int_id,
12632: p_error_message_name => 'INL_ERR_OI_CHK_ELC_UPDATE',

Line 12659: FROM inl_matches_int m

12655: WHEN RESOURCE_BUSY THEN
12656:
12657: SELECT m.group_id
12658: INTO l_group_id
12659: FROM inl_matches_int m
12660: WHERE m.match_int_id = p_match_int_id;
12661:
12662: x_return_status := FND_API.g_ret_sts_error;
12663: FND_MESSAGE.set_name('INL','INL_ERR_OI_CHK_LCK_SHIPMENT');

Line 12751: p_parent_table_name => 'INL_MATCHES_INT',

12747: IF p_matched_uom_code IS NULL THEN
12748: l_result := L_FND_FALSE;
12749: -- Add a line into inl_ship_errors
12750: Handle_InterfError(
12751: p_parent_table_name => 'INL_MATCHES_INT',
12752: p_parent_table_id => p_match_int_id,
12753: p_column_name => 'MATCHED_UOM_CODE',
12754: p_column_value => p_matched_uom_code,
12755: p_error_message_name => 'INL_ERR_OI_CHK_UOM_NULL',

Line 12778: p_parent_table_name => 'INL_MATCHES_INT',

12774: WHEN NO_DATA_FOUND THEN
12775: l_result := L_FND_FALSE;
12776: -- Add a line into inl_ship_errors
12777: Handle_InterfError(
12778: p_parent_table_name => 'INL_MATCHES_INT',
12779: p_parent_table_id => p_match_int_id,
12780: p_column_name => 'MATCHED_UOM_CODE',
12781: p_column_value => p_matched_uom_code,
12782: p_error_message_name => 'INL_ERR_OI_CHK_UOM_INV',

Line 12798: p_parent_table_name => 'INL_MATCHES_INT',

12794: IF p_matched_uom_code IS NOT NULL THEN
12795: l_result := L_FND_FALSE;
12796: -- Add a line into inl_ship_errors
12797: Handle_InterfError(
12798: p_parent_table_name => 'INL_MATCHES_INT',
12799: p_parent_table_id => p_match_int_id,
12800: p_column_name => 'MATCHED_UOM_CODE',
12801: p_column_value => p_matched_uom_code,
12802: p_error_message_name => 'INL_ERR_OI_CHK_UOM_NNULL',

Line 12903: p_parent_table_name => 'INL_MATCHES_INT',

12899: IF p_parent_match_id IS NULL THEN
12900: l_result := L_FND_FALSE;
12901: -- Add a line into inl_ship_errors
12902: Handle_InterfError(
12903: p_parent_table_name => 'INL_MATCHES_INT',
12904: p_parent_table_id => p_match_int_id,
12905: p_column_name => 'PARENT_MATCH_ID',
12906: p_column_value => p_parent_match_id,
12907: p_error_message_name => 'INL_ERR_OI_CHK_MAT_ID_NULL',

Line 12924: FROM inl_matches

12920: ELSE
12921: BEGIN
12922: SELECT adj_already_generated_flag
12923: INTO l_adj_alr_gen_flag
12924: FROM inl_matches
12925: WHERE match_id = p_parent_match_id;
12926: EXCEPTION
12927: WHEN NO_DATA_FOUND THEN
12928: l_result := L_FND_FALSE;

Line 12931: p_parent_table_name => 'INL_MATCHES_INT',

12927: WHEN NO_DATA_FOUND THEN
12928: l_result := L_FND_FALSE;
12929: -- Add a line into inl_ship_errors
12930: Handle_InterfError(
12931: p_parent_table_name => 'INL_MATCHES_INT',
12932: p_parent_table_id => p_match_int_id,
12933: p_column_name => 'PARENT_MATCH_ID',
12934: p_column_value => p_parent_match_id,
12935: p_error_message_name => 'INL_ERR_OI_CHK_PAR_MAT_ID_NF',

Line 12953: p_parent_table_name => 'INL_MATCHES_INT',

12949: IF p_parent_match_id IS NOT NULL AND p_existing_match_info_flag <> 'Y' THEN
12950: l_result := L_FND_FALSE;
12951: -- Add a line into inl_ship_errors
12952: Handle_InterfError(
12953: p_parent_table_name => 'INL_MATCHES_INT',
12954: p_parent_table_id => p_match_int_id,
12955: p_column_name => 'PARENT_MATCH_ID',
12956: p_column_value => p_parent_match_id,
12957: p_error_message_name => 'INL_ERR_OI_CHK_MAT_ID_NNULL',

Line 12982: p_parent_table_name => 'INL_MATCHES_INT',

12978: IF p_match_id IS NULL THEN
12979: l_result := L_FND_FALSE;
12980: -- Add a line into inl_ship_errors
12981: Handle_InterfError(
12982: p_parent_table_name => 'INL_MATCHES_INT',
12983: p_parent_table_id => p_match_int_id,
12984: p_column_name => 'MATCH_ID',
12985: p_column_value => p_match_id,
12986: p_error_message_name => 'INL_ERR_OI_CHK_MAT_ID_NULL',

Line 13003: FROM inl_matches

12999: ELSE
13000: BEGIN
13001: SELECT adj_already_generated_flag
13002: INTO l_adj_alr_gen_flag
13003: FROM inl_matches
13004: WHERE match_id = p_match_id;
13005: IF l_adj_alr_gen_flag <> 'N' THEN
13006: l_result := L_FND_FALSE;
13007: -- Add a line into inl_ship_errors

Line 13009: p_parent_table_name => 'INL_MATCHES_INT',

13005: IF l_adj_alr_gen_flag <> 'N' THEN
13006: l_result := L_FND_FALSE;
13007: -- Add a line into inl_ship_errors
13008: Handle_InterfError(
13009: p_parent_table_name => 'INL_MATCHES_INT',
13010: p_parent_table_id => p_match_int_id,
13011: p_column_name => 'MATCH_ID',
13012: p_column_value => p_match_id,
13013: p_error_message_name => 'INL_ERR_OI_CHK_MAT_ADJUSTED',

Line 13028: p_parent_table_name => 'INL_MATCHES_INT',

13024: WHEN NO_DATA_FOUND THEN
13025: l_result := L_FND_FALSE;
13026: -- Add a line into inl_ship_errors
13027: Handle_InterfError(
13028: p_parent_table_name => 'INL_MATCHES_INT',
13029: p_parent_table_id => p_match_int_id,
13030: p_column_name => 'MATCH_ID',
13031: p_column_value => p_match_id,
13032: p_error_message_name => 'INL_ERR_OI_CHK_MAT_ID_NF',

Line 13361: FROM inl_matches

13357: l_idOk := 'Y';
13358: l_INT_importedOk := 'Y';
13359: SELECT ship_header_id
13360: INTO l_ship_header_id
13361: FROM inl_matches
13362: WHERE match_id = p_parent_match_id;
13363: IF p_match_type_code = 'CORRECTION' THEN
13364: l_matchTpCdOk := 'Y';
13365: END IF;

Line 13380: p_parent_table_name => 'INL_MATCHES_INT',

13376: IF(l_nameOk = 'N') THEN
13377: l_result := L_FND_FALSE;
13378: -- Add a line into inl_ship_errors
13379: Handle_InterfError(
13380: p_parent_table_name => 'INL_MATCHES_INT',
13381: p_parent_table_id => p_match_int_id,
13382: p_column_name => 'TO_PARENT_TABLE_NAME',
13383: p_column_value => p_to_parent_table_name,
13384: p_error_message_name => 'INL_ERR_OI_CHK_TO_PAR_TAB_NAME',

Line 13386: p_token1_value => 'INL_MATCHES_INT',

13382: p_column_name => 'TO_PARENT_TABLE_NAME',
13383: p_column_value => p_to_parent_table_name,
13384: p_error_message_name => 'INL_ERR_OI_CHK_TO_PAR_TAB_NAME',
13385: p_token1_name => 'NAME',
13386: p_token1_value => 'INL_MATCHES_INT',
13387: p_token2_name => 'ID',
13388: p_token2_value => p_match_int_id,
13389: x_return_status => l_return_status
13390: ) ;

Line 13400: p_parent_table_name => 'INL_MATCHES_INT',

13396: ELSIF(l_idOk = 'N') THEN
13397: l_result := L_FND_FALSE;
13398: -- Add a line into inl_ship_errors
13399: Handle_InterfError(
13400: p_parent_table_name => 'INL_MATCHES_INT',
13401: p_parent_table_id => p_match_int_id,
13402: p_column_name => 'TO_PARENT_TABLE_NAME',
13403: p_column_value => p_to_parent_table_name,
13404: p_error_message_name => 'INL_ERR_OI_CHK_TO_PAR_TAB_ID',

Line 13406: p_token1_value => 'INL_MATCHES_INT',

13402: p_column_name => 'TO_PARENT_TABLE_NAME',
13403: p_column_value => p_to_parent_table_name,
13404: p_error_message_name => 'INL_ERR_OI_CHK_TO_PAR_TAB_ID',
13405: p_token1_name => 'NAME',
13406: p_token1_value => 'INL_MATCHES_INT',
13407: p_token2_name => 'ID',
13408: p_token2_value => p_match_int_id,
13409: x_return_status => l_return_status
13410: ) ;

Line 13420: p_parent_table_name => 'INL_MATCHES_INT',

13416: IF(l_SHidOk = 'N') THEN
13417: l_result := L_FND_FALSE;
13418: -- Add a line into inl_ship_errors
13419: Handle_InterfError(
13420: p_parent_table_name => 'INL_MATCHES_INT',
13421: p_parent_table_id => p_match_int_id,
13422: p_column_name => 'SHIP_HEADER_ID',
13423: p_column_value => p_ship_header_id,
13424: p_error_message_name => 'INL_ERR_OI_CHK_SHIP_HEADER_ID',

Line 13426: p_token1_value => 'INL_MATCHES_INT',

13422: p_column_name => 'SHIP_HEADER_ID',
13423: p_column_value => p_ship_header_id,
13424: p_error_message_name => 'INL_ERR_OI_CHK_SHIP_HEADER_ID',
13425: p_token1_name => 'NAME',
13426: p_token1_value => 'INL_MATCHES_INT',
13427: p_token2_name => 'ID',
13428: p_token2_value => p_match_int_id,
13429: x_return_status => l_return_status) ;
13430: -- If unexpected errors happen abort

Line 13439: p_parent_table_name => 'INL_MATCHES_INT',

13435: IF(l_matchTpCdOk = 'N') THEN
13436: l_result := L_FND_FALSE;
13437: -- Add a line into inl_ship_errors
13438: Handle_InterfError(
13439: p_parent_table_name => 'INL_MATCHES_INT',
13440: p_parent_table_id => p_match_int_id,
13441: p_column_name => 'MATCH_TYPE_CODE',
13442: p_column_value => p_match_type_code,
13443: p_error_message_name => 'INL_ERR_OI_CHK_MATCH_TP_CD',

Line 13445: p_token1_value => 'INL_MATCHES_INT',

13441: p_column_name => 'MATCH_TYPE_CODE',
13442: p_column_value => p_match_type_code,
13443: p_error_message_name => 'INL_ERR_OI_CHK_MATCH_TP_CD',
13444: p_token1_name => 'NAME',
13445: p_token1_value => 'INL_MATCHES_INT',
13446: p_token2_name => 'ID',
13447: p_token2_value => p_match_int_id,
13448: x_return_status => l_return_status
13449: ) ;

Line 13459: p_parent_table_name => 'INL_MATCHES_INT',

13455: IF(l_INT_importedOk = 'N') THEN
13456: l_result := L_FND_FALSE;
13457: -- Add a line into inl_ship_errors
13458: Handle_InterfError(
13459: p_parent_table_name => 'INL_MATCHES_INT',
13460: p_parent_table_id => p_match_int_id,
13461: p_column_name => 'MATCH_TYPE_CODE',
13462: p_column_value => p_match_type_code,
13463: p_error_message_name => 'INL_ERR_OI_CHK_TO_PAR_TAB_ID2',

Line 13569: p_parent_table_name => 'INL_MATCHES_INT',

13565: IF p_match_id IS NOT NULL THEN
13566: l_result := L_FND_FALSE;
13567: -- Add a line into inl_ship_errors
13568: Handle_InterfError(
13569: p_parent_table_name => 'INL_MATCHES_INT',
13570: p_parent_table_id => p_match_int_id,
13571: p_column_name => 'MATCH_ID',
13572: p_column_value => p_match_id,
13573: p_error_message_name => 'INL_ERR_OI_CHK_MAT_ID_NNULL',

Line 13591: p_parent_table_name => 'INL_MATCHES_INT',

13587: IF p_match_id IS NULL THEN
13588: l_result := L_FND_FALSE;
13589: -- Add a line into inl_ship_errors
13590: Handle_InterfError(
13591: p_parent_table_name => 'INL_MATCHES_INT',
13592: p_parent_table_id => p_match_int_id,
13593: p_column_name => 'MATCH_ID',
13594: p_column_value => p_match_id,
13595: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_ID_NULL',

Line 13613: FROM inl_matches m

13609: SELECT adj_already_generated_flag,
13610: replace_estim_qty_flag
13611: INTO l_adj_already_generated_flag,
13612: l_replace_estim_qty_flag
13613: FROM inl_matches m
13614: WHERE m.match_id = p_match_id;
13615:
13616: INL_LOGGING_PVT.Log_Variable(
13617: p_module_name => g_module_name,

Line 13633: p_parent_table_name => 'INL_MATCHES_INT',

13629: );
13630: l_result := L_FND_FALSE;
13631: -- Add a line into inl_ship_errors
13632: Handle_InterfError(
13633: p_parent_table_name => 'INL_MATCHES_INT',
13634: p_parent_table_id => p_match_int_id,
13635: p_column_name => 'TRANSACTION_TYPE',
13636: p_column_value => p_transaction_type,
13637: p_error_message_name => 'INL_ERR_OI_CHK_PROC_MAT_INVL',

Line 13657: p_parent_table_name => 'INL_MATCHES_INT',

13653: );
13654: l_result := L_FND_FALSE;
13655: -- Add a line into inl_ship_errors
13656: Handle_InterfError(
13657: p_parent_table_name => 'INL_MATCHES_INT',
13658: p_parent_table_id => p_match_int_id,
13659: p_column_name => 'REPLACE_ESTIM_QTY_FLAG',
13660: p_column_value => p_replace_estim_qty_flag,
13661: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_INVL',

Line 13683: FROM inl_matches m1

13679: -- replace_estim_qty_flag = 'Y' and adj_already_generated_flag = 'N'
13680: BEGIN
13681: SELECT m1.match_id
13682: INTO l_other_REQF_Y_match_id
13683: FROM inl_matches m1
13684: WHERE m1.to_parent_table_name = p_to_parent_table_name
13685: AND m1.to_parent_table_id = p_to_parent_table_id
13686: AND m1.match_type_code = 'ITEM'
13687: AND m1.replace_estim_qty_flag = 'Y'

Line 13691: FROM inl_matches m2

13687: AND m1.replace_estim_qty_flag = 'Y'
13688: AND m1.adj_already_generated_flag = 'N'
13689: --For validation purpose, it will consider only the latest and not processed record
13690: AND m1.match_id IN (SELECT MAX(m2.match_id)
13691: FROM inl_matches m2
13692: WHERE m2.to_parent_table_name = m1.to_parent_table_name
13693: AND m2.to_parent_table_id = m1.to_parent_table_id
13694: AND m2.match_type_code = 'ITEM'
13695: AND m2.replace_estim_qty_flag = 'Y'

Line 13721: p_parent_table_name => 'INL_MATCHES_INT',

13717: IF p_match_id < l_other_REQF_Y_match_id THEN
13718: l_result := L_FND_FALSE;
13719: -- Add a line into inl_ship_errors
13720: Handle_InterfError(
13721: p_parent_table_name => 'INL_MATCHES_INT',
13722: p_parent_table_id => p_match_int_id,
13723: p_column_name => 'TRANSACTION_TYPE',
13724: p_column_value => p_transaction_type,
13725: p_error_message_name => 'INL_ERR_OI_CHK_MAT_NO_EFFECT',

Line 13741: p_parent_table_name => 'INL_MATCHES_INT',

13737: ELSE
13738: l_result := L_FND_FALSE;
13739: -- Add a line into inl_ship_errors
13740: Handle_InterfError(
13741: p_parent_table_name => 'INL_MATCHES_INT',
13742: p_parent_table_id => p_match_int_id,
13743: p_column_name => 'TRANSACTION_TYPE',
13744: p_column_value => p_transaction_type,
13745: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_INVL',

Line 13936: p_parent_table_name => 'INL_MATCHES_INT',

13932: );
13933: l_result := L_FND_FALSE;
13934: -- Add a line into inl_ship_errors
13935: Handle_InterfError(
13936: p_parent_table_name => 'INL_MATCHES_INT',
13937: p_parent_table_id => p_match_int_id,
13938: p_column_name => l_field,
13939: p_column_value => l_field_id,
13940: p_error_message_name => 'INL_ERR_OI_CHK_PARTY_INVAL',

Line 13964: p_parent_table_name => 'INL_MATCHES_INT',

13960: IF l_field <> 'x' THEN
13961: l_result := L_FND_FALSE;
13962: -- Add a line into inl_ship_errors
13963: Handle_InterfError(
13964: p_parent_table_name => 'INL_MATCHES_INT',
13965: p_parent_table_id => p_match_int_id,
13966: p_column_name => l_field,
13967: p_column_value => l_field_id,
13968: p_error_message_name => 'INL_ERR_OI_CHK_PARTY_NNULL',

Line 14105: FROM inl_matches

14101: INTO l_parent_match_type_code ,
14102: l_parent_matched_curr_code ,
14103: l_parent_to_parent_table_name,
14104: l_parent_to_parent_table_ID
14105: FROM inl_matches
14106: WHERE match_id = p_match_int_rec.parent_match_id;
14107: ELSE
14108: l_parent_match_type_code := NULL;
14109: l_parent_matched_curr_code := NULL;

Line 14590: UPDATE inl_matches_int m

14586:
14587: RAISE FND_API.G_EXC_ERROR;
14588: END IF;
14589:
14590: UPDATE inl_matches_int m
14591: SET m.request_id = l_fnd_conc_request_id_int
14592: WHERE (nvl(m.request_id,1) > 0
14593: OR m.request_id = -1)
14594: AND m.processing_status_code = 'PENDING'

Line 14620: UPDATE inl_matches_int mi

14616: IF p_group_id IS NULL THEN
14617:
14618: --same origin should be processed together
14619:
14620: UPDATE inl_matches_int mi
14621: SET mi.request_id = l_fnd_conc_request_id_int
14622: WHERE (nvl(mi.request_id,1) > 0
14623: OR mi.request_id = -1)
14624: AND mi.processing_status_code = 'PENDING'

Line 14627: FROM inl_matches_int mi2

14623: OR mi.request_id = -1)
14624: AND mi.processing_status_code = 'PENDING'
14625: AND EXISTS (
14626: SELECT 1
14627: FROM inl_matches_int mi2
14628: WHERE mi2.processing_status_code = 'PENDING'
14629: AND mi2.request_id = l_fnd_conc_request_id_int
14630: AND mi2.from_parent_table_name = mi.from_parent_table_name
14631: AND mi2.from_parent_table_id = mi.from_parent_table_id

Line 14638: UPDATE inl_matches_int mi

14634: l_return_value := l_return_value + NVL(SQL%ROWCOUNT,0);
14635:
14636: --item matches to the same ship_line should be processed together
14637:
14638: UPDATE inl_matches_int mi
14639: SET mi.request_id = l_fnd_conc_request_id_int
14640: WHERE (nvl(mi.request_id,1) > 0
14641: OR mi.request_id = -1)
14642: AND mi.processing_status_code = 'PENDING'

Line 14646: FROM inl_matches_int mi2

14642: AND mi.processing_status_code = 'PENDING'
14643: AND mi.to_parent_table_name = 'RCV_TRANSACTIONS'
14644: AND EXISTS (
14645: SELECT 1
14646: FROM inl_matches_int mi2
14647: WHERE mi2.processing_status_code = 'PENDING'
14648: AND mi2.request_id = l_fnd_conc_request_id_int
14649: AND mi2.match_int_id <> mi.match_int_id
14650: AND mi2.to_parent_table_name = 'RCV_TRANSACTIONS'

Line 14658: UPDATE inl_matches_int mi

14654:
14655:
14656: --same group_id should be processed together
14657:
14658: UPDATE inl_matches_int mi
14659: SET mi.request_id = l_fnd_conc_request_id_int
14660: WHERE (nvl(mi.request_id,1) > 0
14661: OR mi.request_id = -1)
14662: AND mi.processing_status_code = 'PENDING'

Line 14665: FROM inl_matches_int mi2

14661: OR mi.request_id = -1)
14662: AND mi.processing_status_code = 'PENDING'
14663: AND EXISTS (
14664: SELECT 1
14665: FROM inl_matches_int mi2
14666: WHERE mi2.processing_status_code = 'PENDING'
14667: AND mi2.request_id = l_fnd_conc_request_id_int
14668: AND mi2.group_id = mi.group_id
14669: AND mi2.match_int_id <> mi.match_int_id

Line 14682: inl_matches_int mi

14678: (
14679: SELECT DISTINCT
14680: mi.group_id
14681: FROM
14682: inl_matches_int mi
14683: WHERE
14684: mi.processing_status_code = 'PENDING'
14685: AND mi.request_id = l_fnd_conc_request_id_int
14686: AND NOT EXISTS

Line 14703: inl_matches_int mi

14699: p_module_name => g_module_name,
14700: p_procedure_name => l_program_name,
14701: p_debug_info => ' Group unmarked:'||l_non_hrs.group_id);
14702: UPDATE
14703: inl_matches_int mi
14704: SET mi.request_id = ABS(l_fnd_conc_request_id_int)
14705: WHERE mi.group_id = l_non_hrs.group_id
14706: AND mi.processing_status_code = 'PENDING';
14707: l_return_value := l_return_value - NVL(SQL%ROWCOUNT,0);

Line 14794: FROM inl_matches_int

14790: --Bug#16198838/14707257 BEGIN
14791: CURSOR c_unproc_match_int (pc_max_id NUMBER)
14792: IS
14793: SELECT DISTINCT group_id
14794: FROM inl_matches_int
14795: WHERE match_int_id < pc_max_id
14796: AND (nvl(request_id,1) > 0
14797: OR request_id = -1)
14798: AND processing_status_code = 'PENDING'

Line 14841: FROM inl_matches_int m

14837: nrec_tax_amt ,
14838: tax_amt_included_flag,
14839: match_amounts_flag,
14840: null
14841: FROM inl_matches_int m
14842: WHERE (p_group_id IS NULL
14843: OR m.group_id = p_group_id)
14844: AND m.processing_status_code = 'PENDING'
14845: AND m.request_id = l_fnd_conc_request_id_int --Bug#11794442

Line 14877: FROM inl_matches_int;

14873:
14874: --Bug#16198838/14707257
14875: SELECT NVL(MAX(match_int_id),0)
14876: INTO l_max_match_int_id
14877: FROM inl_matches_int;
14878: INL_LOGGING_PVT.Log_Variable(
14879: p_module_name => g_module_name,
14880: p_procedure_name => l_program_name,
14881: p_var_name => 'l_max_match_int_id',

Line 14995: p_parent_table_name => 'INL_MATCHES_INT',

14991: p_procedure_name => l_program_name,
14992: p_debug_info => l_debug_info
14993: );
14994: Reset_InterfError(
14995: p_parent_table_name => 'INL_MATCHES_INT',
14996: p_parent_table_id => match_int_list(i) .match_int_id,
14997: x_return_status => l_return_status
14998: ) ;
14999: -- If any errors happen abort the process.

Line 15052: p_parent_table_name => 'INL_MATCHES_INT',

15048: EXCEPTION
15049: WHEN OTHERS THEN
15050: l_import_validation := FALSE;
15051: Handle_InterfError(
15052: p_parent_table_name => 'INL_MATCHES_INT',
15053: p_parent_table_id => match_int_list(i).match_int_id,
15054: p_column_name => 'match_int_list('||i||').match_int_id',
15055: p_column_value => match_int_list(i).match_int_id,
15056: p_error_message_name => 'INL_FAILED_ON_CONC_SUB',

Line 15096: UPDATE inl_matches_int

15092: p_procedure_name => l_program_name,
15093: p_debug_info => l_debug_info
15094: );
15095:
15096: UPDATE inl_matches_int
15097: SET processing_status_code = 'RUNNING' ,
15098: party_id = match_int_list(i).party_id ,
15099: party_site_id = match_int_list(i).party_site_id ,
15100: -- request_id = L_FND_CONC_REQUEST_ID ,--Bug#11794442

Line 15122: UPDATE inl_matches_int mi

15118: p_module_name => g_module_name,
15119: p_procedure_name => l_program_name,
15120: p_debug_info => l_debug_info
15121: );
15122: UPDATE inl_matches_int mi
15123: SET mi.processing_status_code = 'ERROR' ,
15124: mi.request_id = L_FND_CONC_REQUEST_ID ,
15125: mi.last_updated_by = L_FND_USER_ID ,
15126: mi.last_update_date = SYSDATE ,

Line 15163: p_parent_table_name => 'INL_MATCHES_INT',

15159: p_debug_info => l_debug_info
15160: );
15161:
15162: /* Handle_InterfError(
15163: p_parent_table_name => 'INL_MATCHES_INT',
15164: p_parent_table_id => 0,
15165: p_column_name => 'P_GROUP_ID',
15166: p_column_value => p_group_id,
15167: p_error_message_name => 'INL_NO_RECORDS_FOUND_ERR',

Line 15180: FROM inl_matches_int

15176:
15177: --Bug#16198838/14707257 BEGIN
15178: SELECT NVL(MAX(match_int_id),0)
15179: INTO l_max_match_int_id2
15180: FROM inl_matches_int
15181: WHERE match_int_id < l_max_match_int_id+1
15182: AND (nvl(request_id,1) > 0
15183: OR request_id = -1)
15184: AND processing_status_code = 'PENDING'

Line 15491: l_debug_info := 'Delete from INL_MATCHES_INT';

15487: p_procedure_name => l_program_name,
15488: p_var_name => 'p_group_id',
15489: p_var_value => p_group_id);
15490:
15491: l_debug_info := 'Delete from INL_MATCHES_INT';
15492: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
15493: p_procedure_name => l_program_name,
15494: p_debug_info => l_debug_info) ;
15495:

Line 15496: DELETE FROM inl_matches_int

15492: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
15493: p_procedure_name => l_program_name,
15494: p_debug_info => l_debug_info) ;
15495:
15496: DELETE FROM inl_matches_int
15497: WHERE (p_group_id IS NULL OR group_id = p_group_id)
15498: AND processing_status_code = 'COMPLETED';
15499:
15500: -- Standard check of p_commit.

Line 17596: FROM inl_matches_int m,

17592: l_count_elc_pend_shipment NUMBER;
17593:
17594: CURSOR c_matches_int_error IS
17595: SELECT DISTINCT m.group_id
17596: FROM inl_matches_int m,
17597: rcv_transactions rt,
17598: inl_ship_lines_all sl
17599: WHERE sl.ship_line_id = rt.lcm_shipment_line_id
17600: AND rt.transaction_id = m.to_parent_table_id

Line 17640: FROM inl_matches_int m,

17636: p_var_name => 'group_id',
17637: p_var_value => l_matches_int_error(i).group_id);
17638: SELECT COUNT(1)
17639: INTO l_count_elc_pend_shipment
17640: FROM inl_matches_int m,
17641: rcv_transactions rt,
17642: inl_ship_lines_all sl,
17643: inl_ship_headers_all sh
17644: WHERE sh.ship_header_id = sl.ship_header_id

Line 17657: l_debug_info := 'Update inl_matches_int to PENDING for group ID: ' || l_matches_int_error(i).group_id;

17653: p_var_name => 'l_count_elc_pend_shipment',
17654: p_var_value => l_count_elc_pend_shipment);
17655:
17656: IF NVL(l_count_elc_pend_shipment,0) = 0 THEN
17657: l_debug_info := 'Update inl_matches_int to PENDING for group ID: ' || l_matches_int_error(i).group_id;
17658: INL_LOGGING_PVT.Log_Statement(p_module_name => g_module_name,
17659: p_procedure_name => l_program_name,
17660: p_debug_info => l_debug_info);
17661:

Line 17662: UPDATE inl_matches_int mi

17658: INL_LOGGING_PVT.Log_Statement(p_module_name => g_module_name,
17659: p_procedure_name => l_program_name,
17660: p_debug_info => l_debug_info);
17661:
17662: UPDATE inl_matches_int mi
17663: SET processing_status_code = 'PENDING',
17664: mi.last_updated_by = L_FND_USER_ID,
17665: mi.last_update_date = SYSDATE,
17666: mi.last_update_login = L_FND_LOGIN_ID