APPS.INL_INTERFACE_PVT dependencies on INL_MATCH_AMOUNTS

Line 8151: -- Table inl_match_amounts

8147: p_var_name => 'sql%rowcount',
8148: p_var_value => sql%rowcount
8149: );
8150:
8151: -- Table inl_match_amounts
8152: -- Bug#9279355
8153: l_debug_info := 'Delete inl_match_amounts';
8154: INL_LOGGING_PVT.Log_Statement(
8155: p_module_name => g_module_name,

Line 8153: l_debug_info := 'Delete inl_match_amounts';

8149: );
8150:
8151: -- Table inl_match_amounts
8152: -- Bug#9279355
8153: l_debug_info := 'Delete inl_match_amounts';
8154: INL_LOGGING_PVT.Log_Statement(
8155: p_module_name => g_module_name,
8156: p_procedure_name => l_program_name,
8157: p_debug_info => l_debug_info) ;

Line 8159: DELETE FROM inl_match_amounts ma

8155: p_module_name => g_module_name,
8156: p_procedure_name => l_program_name,
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

Line 10613: SELECT inl_match_Amounts_s.NEXTVAL

10609: ) ;
10610:
10611: RAISE L_FND_EXC_UNEXPECTED_ERROR;
10612: ELSE
10613: SELECT inl_match_Amounts_s.NEXTVAL
10614: INTO matchAmountsToProcess_List(iMatch).new_match_Amount_id
10615: FROM dual; -- BUG#8411723 => MURALI
10616:
10617: INL_LOGGING_PVT.Log_Variable(

Line 10624: INSERT INTO inl_match_Amounts(

10620: p_var_name => 'matchAmountsToProcess_List(iMatch).new_match_Amount_id',
10621: p_var_value => matchAmountsToProcess_List(iMatch).new_match_Amount_id
10622: ) ;
10623:
10624: INSERT INTO inl_match_Amounts(
10625: match_amount_id ,
10626: adj_group_date ,-- OPM Integration
10627: matched_amt ,
10628: matched_curr_code ,

Line 10839: FROM inl_match_amounts ima

10835: matchesToProcess_List(iMatch).tax_amt_included_flag , /* 24 */
10836: DECODE(matchesToProcess_List(iMatch).match_amounts_flag,
10837: 'Y',
10838: (SELECT ima.match_amount_id
10839: FROM inl_match_amounts ima
10840: WHERE ima.group_id = matchesToProcess_List(iMatch).group_id
10841: AND nvl(ima.charge_line_type_id,-9) = nvl(matchesToProcess_List(iMatch).charge_line_type_id,-9)
10842: AND nvl(ima.tax_code,'XxX') = nvl(matchesToProcess_List(iMatch).tax_code,'XxX')
10843: AND ima.matched_curr_code = matchesToProcess_List(iMatch).matched_curr_code