APPS.INL_INTERFACE_PVT dependencies on INL_MATCH_AMOUNTS_INT

Line 137: ELSIF p_parent_table_name = 'INL_MATCH_AMOUNTS_INT' THEN

133: program_update_date = SYSDATE ,
134: program_application_id = fnd_global.prog_appl_id
135: WHERE match_int_id = p_parent_table_id
136: AND processing_status_code <> 'ERROR';
137: ELSIF p_parent_table_name = 'INL_MATCH_AMOUNTS_INT' THEN
138: l_debug_info := 'Set Match Amounts Interface status to ERROR.';
139: INL_LOGGING_PVT.Log_Statement(
140: p_module_name => g_module_name,
141: p_procedure_name => l_proc_name,

Line 144: UPDATE inl_match_amounts_int

140: p_module_name => g_module_name,
141: p_procedure_name => l_proc_name,
142: p_debug_info => l_debug_info
143: ) ;
144: UPDATE inl_match_amounts_int
145: SET processing_status_code = 'ERROR' ,
146: request_id = fnd_global.conc_request_id,
147: last_updated_by = fnd_global.user_id ,
148: last_update_date = SYSDATE ,

Line 3979: FROM inl_match_amounts_int

3975: matched_curr_conversion_date,
3976: matched_curr_conversion_rate,
3977: match_amount_int_id,
3978: transaction_type
3979: FROM inl_match_amounts_int
3980: WHERE processing_status_code = 'PENDING'
3981: AND (p_group_id IS NULL
3982: OR p_group_id = group_id)
3983: ;

Line 4126: UPDATE inl_match_Amounts_int m

4122: p_debug_info => l_debug_info
4123: ) ;
4124: -- Set processing status to COMPLETED for
4125: -- the current and imported Match Line
4126: UPDATE inl_match_Amounts_int m
4127: SET m.processing_status_code = 'COMPLETED' ,
4128: m.request_id = fnd_global.conc_request_id,
4129: m.last_updated_by = fnd_global.user_id ,
4130: m.last_update_date = SYSDATE ,

Line 7636: TYPE inl_match_amounts_int_type_tbl IS TABLE OF c_match_amount_int%ROWTYPE INDEX BY BINARY_INTEGER;

7632: WHERE (p_group_id IS NULL
7633: OR m.group_id = p_group_id
7634: )
7635: AND m.processing_status_code = 'PENDING';
7636: TYPE inl_match_amounts_int_type_tbl IS TABLE OF c_match_amount_int%ROWTYPE INDEX BY BINARY_INTEGER;
7637: match_amounts_int_list inl_match_amounts_int_type_tbl;
7638:
7639: -- Cursor to get all PENDING matches from the
7640: -- Interface table based on a given group id

Line 7637: match_amounts_int_list inl_match_amounts_int_type_tbl;

7633: OR m.group_id = p_group_id
7634: )
7635: AND m.processing_status_code = 'PENDING';
7636: TYPE inl_match_amounts_int_type_tbl IS TABLE OF c_match_amount_int%ROWTYPE INDEX BY BINARY_INTEGER;
7637: match_amounts_int_list inl_match_amounts_int_type_tbl;
7638:
7639: -- Cursor to get all PENDING matches from the
7640: -- Interface table based on a given group id
7641: CURSOR c_match_int

Line 7855: p_parent_table_name => 'INL_MATCH_AMOUNTS_INT',

7851: p_procedure_name => l_proc_name,
7852: p_debug_info => l_debug_info
7853: );
7854: Reset_InterfError(
7855: p_parent_table_name => 'INL_MATCH_AMOUNTS_INT',
7856: p_parent_table_id => match_amounts_int_list(i).match_amount_int_id,
7857: x_return_status => l_return_status) ;
7858: -- If any errors happen abort the process.
7859: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 7879: p_parent_table_name => 'INL_MATCH_AMOUNTS_INT',

7875: WHERE m.match_amount_int_id = match_amounts_int_list(i).match_amount_int_id
7876: ;
7877: -- Add a line into inl_ship_errors
7878: Handle_InterfError(
7879: p_parent_table_name => 'INL_MATCH_AMOUNTS_INT',
7880: p_parent_table_id => match_amounts_int_list(i).match_amount_int_id,
7881: p_column_name => 'P_GROUP_ID',
7882: p_column_value => P_GROUP_ID,
7883: p_token1_name => 'AMT1',