APPS.CN_INVOICE_CHANGES_PVT dependencies on CN_INVOICE_CHANGES_PKG

Line 681: l_insert_rec cn_invoice_changes_pkg.invoice_changes_all_rec_type;

677: l_api_version CONSTANT NUMBER := 1.0;
678: --
679: l_invoice_change_id NUMBER;
680: -- PL/SQL tables and records
681: l_insert_rec cn_invoice_changes_pkg.invoice_changes_all_rec_type;
682: --
683: CURSOR c1(
684: l_comm_lines_api_id NUMBER) IS
685: SELECT invoice_change_id

Line 715: cn_invoice_changes_pkg.delete_row(c1_rec.invoice_change_id);

711: IF (NVL(p_exist_data_check,'Y') = 'Y') THEN
712: FOR i IN p_existing_data.FIRST..p_existing_data.LAST
713: LOOP
714: FOR c1_rec IN c1(p_existing_data(i).comm_lines_api_id) LOOP
715: cn_invoice_changes_pkg.delete_row(c1_rec.invoice_change_id);
716: END LOOP;
717: END LOOP;
718: END IF;
719: -- Create new records in the same table.

Line 736: cn_invoice_changes_pkg.insert_row(

732: l_insert_rec.revenue_type := p_new_data(i).revenue_type;
733: l_insert_rec.split_pct := p_new_data(i).split_pct;
734: l_insert_rec.comm_lines_api_id := p_new_data(i).comm_lines_api_id;
735: --
736: cn_invoice_changes_pkg.insert_row(
737: p_invoice_changes_all_rec => l_insert_rec);
738: --
739: END LOOP;
740: END IF;

Line 1749: l_insert_rec cn_invoice_changes_pkg.invoice_changes_all_rec_type;

1745: l_api_version CONSTANT NUMBER := 1.0;
1746: l_invoice_change_id NUMBER;
1747: l_counter NUMBER := 0;
1748: -- PL/SQL tables and records
1749: l_insert_rec cn_invoice_changes_pkg.invoice_changes_all_rec_type;
1750: --
1751: BEGIN
1752: -- Standard Start of API savepoint
1753: SAVEPOINT capture_deal_invoice;

Line 1776: cn_invoice_changes_pkg.delete_row(c2_rec.invoice_change_id);

1772: IF ((c2_rec.revenue_type = 'NONREVENUE') AND
1773: (p_split_nonrevenue_line = 'N'))THEN
1774: NULL;
1775: ELSE
1776: cn_invoice_changes_pkg.delete_row(c2_rec.invoice_change_id);
1777: END IF;
1778: END LOOP;
1779: END IF;
1780: FOR c1_rec IN c1

Line 1909: l_insert_rec cn_invoice_changes_pkg.invoice_changes_all_rec_type;

1905: l_adjust_comments VARCHAR2(300);
1906: l_process_audit_id cn_process_audits.process_audit_id%TYPE;
1907: l_trx_type VARCHAR2(30);
1908: -- PL/SQL tables and records
1909: l_insert_rec cn_invoice_changes_pkg.invoice_changes_all_rec_type;
1910: l_invoice_tbl invoice_tbl;
1911: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;
1912: l_adj_tbl cn_get_tx_data_pub.adj_tbl_type;
1913: --

Line 1962: cn_invoice_changes_pkg.insert_row(

1958: l_insert_rec.revenue_type := c1_rec.revenue_type;
1959: l_insert_rec.split_pct := c1_rec.split_pct;
1960: l_insert_rec.comm_lines_api_id := c1_rec.comm_lines_api_id;
1961: --
1962: cn_invoice_changes_pkg.insert_row(
1963: p_invoice_changes_all_rec => l_insert_rec);
1964: --
1965: UPDATE cn_comm_lines_api
1966: SET adjust_status = 'INVLOAD'