APPS.INL_MATCH_GRP dependencies on INL_MATCHES_INT

Line 24: p_matches_int_tbl IN OUT NOCOPY inl_matches_int_type_tbl,

20: -- Notes :
21: PROCEDURE Create_MatchIntLines(p_api_version IN NUMBER,
22: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
23: p_commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_matches_int_tbl IN OUT NOCOPY inl_matches_int_type_tbl,
25: x_return_status OUT NOCOPY VARCHAR2,
26: x_msg_count OUT NOCOPY NUMBER,
27: x_msg_data OUT NOCOPY VARCHAR2) IS
28:

Line 70: SELECT inl_matches_int_s.NEXTVAL

66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67:
68: IF NVL(p_matches_int_tbl.LAST,0) > 0 THEN
69: FOR i IN NVL(p_matches_int_tbl.FIRST,0)..NVL(p_matches_int_tbl.LAST,0) LOOP
70: SELECT inl_matches_int_s.NEXTVAL
71: INTO p_matches_int_tbl(i).match_int_id
72: FROM dual;
73: IF l_group_id IS NULL then
74: l_group_id := p_matches_int_tbl(i).match_int_id;

Line 84: INSERT INTO inl_matches_int (

80: p_var_name => l_debug_info,
81: p_var_value => p_matches_int_tbl(i).match_id);
82: -- Insert Match Line
83:
84: INSERT INTO inl_matches_int (
85: match_int_id , /* 01 */
86: group_id , /* 02 */
87: processing_status_code , /* 03 */
88: transaction_type , /* 04 */

Line 264: FROM inl_matches_int MInt,

260: i.exchange_rate_type curr_type,
261: i.exchange_date curr_date,
262: NULL tax_cost_factor_id, --Tax Prorate should be the same basis of its charge
263: 'CHARGE' amount_type
264: FROM inl_matches_int MInt,
265: ap_invoices i,
266: ap_invoice_lines l,
267: ap_invoice_distributions d
268: WHERE MInt.from_parent_table_name = 'AP_INVOICE_DISTRIBUTIONS'

Line 294: FROM inl_matches_int MInt,

290: i.exchange_rate_type curr_type,
291: i.exchange_date curr_date,
292: l_prorat.cost_factor_id tax_cost_factor_id, --Tax Prorate should be the same basis of its charge
293: 'TAX' amount_type
294: FROM inl_matches_int MInt,
295: ap_invoices i,
296: ap_invoice_lines l,
297: ap_invoice_distributions d,
298: ap_invoice_distributions d_prorat,

Line 394: UPDATE inl_matches_int MInt

390: SYSDATE , /* 17 */
391: fnd_global.login_id); /* 18 */
392:
393:
394: UPDATE inl_matches_int MInt
395: SET match_amount_int_id = l_match_amount_int_id
396: WHERE MInt.from_parent_table_name = 'AP_INVOICE_DISTRIBUTIONS'
397: AND MInt.match_type_code = c_amounts_rec.match_type_code
398: AND MInt.processing_status_code = 'PENDING'

Line 433: FROM inl_matches_int MInt

429: ;
430:
431: SELECT SUM(MInt.matched_amt)
432: INTO l_match_amount_validation
433: FROM inl_matches_int MInt
434: WHERE MInt.match_amount_int_id = l_match_amount_int_id;
435: IF l_match_amount_validation <> c_amounts_rec.amount THEN
436: l_debug_info := 'l_match_amount_validation ('||l_match_amount_validation||') <> c_amounts_rec.amount ('||c_amounts_rec.amount||')';
437: INL_LOGGING_PVT.Log_Statement (

Line 579: l_matches_int_tbl inl_matches_int_type_tbl;

575: AND d.invoice_id = p_invoice_id
576: ORDER BY invoice_distribution_id;
577:
578: c_distr_rec c_distr%ROWTYPE;
579: l_matches_int_tbl inl_matches_int_type_tbl;
580: i NUMBER;
581: l_invoices_with_charge_tbl inl_int_tbl;
582: l_count_invoices_with_charge NUMBER:=1;
583: BEGIN

Line 650: -- Although the match represents the new amount of the line and not the variation inl_matches_int will have the variation.

646:
647: -- In order to make the Create Adjust process less
648: -- complex, the correction match should use the same
649: -- currency that is used by the corrected match.
650: -- Although the match represents the new amount of the line and not the variation inl_matches_int will have the variation.
651: IF c_distr_rec.line_type = 'CORRECTION'
652: AND (c_distr_rec.dist_match_type <> 'NOT_MATCHED'
653: OR c_distr_rec.correction_type = 'ITEM')
654: THEN