468: -- Local Variables
469: l_txn_rec csi_datastructures_pub.transaction_rec;
470:
471: -- Variables for Dummy record details
472: d_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
473: d_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
474: d_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
475: d_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
476: d_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
469: l_txn_rec csi_datastructures_pub.transaction_rec;
470:
471: -- Variables for Dummy record details
472: d_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
473: d_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
474: d_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
475: d_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
476: d_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
477: d_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
470:
471: -- Variables for Dummy record details
472: d_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
473: d_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
474: d_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
475: d_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
476: d_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
477: d_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
478: d_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
471: -- Variables for Dummy record details
472: d_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
473: d_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
474: d_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
475: d_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
476: d_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
477: d_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
478: d_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
479: d_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
472: d_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
473: d_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
474: d_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
475: d_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
476: d_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
477: d_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
478: d_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
479: d_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
480: d_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
473: d_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
474: d_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
475: d_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
476: d_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
477: d_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
478: d_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
479: d_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
480: d_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
481: d_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
474: d_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
475: d_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
476: d_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
477: d_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
478: d_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
479: d_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
480: d_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
481: d_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
482: d_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
475: d_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
476: d_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
477: d_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
478: d_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
479: d_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
480: d_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
481: d_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
482: d_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
483: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
476: d_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
477: d_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
478: d_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
479: d_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
480: d_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
481: d_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
482: d_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
483: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
484: l_msg_count NUMBER;
477: d_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
478: d_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
479: d_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
480: d_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
481: d_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
482: d_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
483: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
484: l_msg_count NUMBER;
485: l_msg_data VARCHAR2(2000);
478: d_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
479: d_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
480: d_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
481: d_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
482: d_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
483: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
484: l_msg_count NUMBER;
485: l_msg_data VARCHAR2(2000);
486:
1495: p_commit IN VARCHAR2 := fnd_api.g_false,
1496: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1497: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1498: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
1499: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
1500: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
1501: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
1502: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1503: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1497: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1498: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
1499: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
1500: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
1501: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
1502: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1503: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1504: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1505: x_mass_edit_error_tbl OUT NOCOPY mass_edit_error_tbl,
1498: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
1499: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
1500: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
1501: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
1502: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1503: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1504: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1505: x_mass_edit_error_tbl OUT NOCOPY mass_edit_error_tbl,
1506: x_return_status OUT NOCOPY VARCHAR2,
1499: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
1500: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
1501: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
1502: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1503: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1504: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1505: x_mass_edit_error_tbl OUT NOCOPY mass_edit_error_tbl,
1506: x_return_status OUT NOCOPY VARCHAR2,
1507: x_msg_count OUT NOCOPY NUMBER,
1500: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
1501: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
1502: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1503: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1504: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1505: x_mass_edit_error_tbl OUT NOCOPY mass_edit_error_tbl,
1506: x_return_status OUT NOCOPY VARCHAR2,
1507: x_msg_count OUT NOCOPY NUMBER,
1508: x_msg_data OUT NOCOPY VARCHAR2
1663: p_commit IN VARCHAR2 := fnd_api.g_false,
1664: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1665: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1666: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
1667: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
1668: px_mass_edit_inst_tbl IN OUT NOCOPY mass_edit_inst_tbl,
1669: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
1670: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1671: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1665: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1666: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
1667: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
1668: px_mass_edit_inst_tbl IN OUT NOCOPY mass_edit_inst_tbl,
1669: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
1670: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1671: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1672: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1673: x_mass_edit_error_tbl OUT NOCOPY mass_edit_error_tbl,
1666: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
1667: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
1668: px_mass_edit_inst_tbl IN OUT NOCOPY mass_edit_inst_tbl,
1669: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
1670: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1671: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1672: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1673: x_mass_edit_error_tbl OUT NOCOPY mass_edit_error_tbl,
1674: x_return_status OUT NOCOPY VARCHAR2,
1667: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
1668: px_mass_edit_inst_tbl IN OUT NOCOPY mass_edit_inst_tbl,
1669: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
1670: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1671: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1672: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1673: x_mass_edit_error_tbl OUT NOCOPY mass_edit_error_tbl,
1674: x_return_status OUT NOCOPY VARCHAR2,
1675: x_msg_count OUT NOCOPY NUMBER,
1668: px_mass_edit_inst_tbl IN OUT NOCOPY mass_edit_inst_tbl,
1669: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
1670: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1671: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1672: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1673: x_mass_edit_error_tbl OUT NOCOPY mass_edit_error_tbl,
1674: x_return_status OUT NOCOPY VARCHAR2,
1675: x_msg_count OUT NOCOPY NUMBER,
1676: x_msg_data OUT NOCOPY VARCHAR2) IS
2082: p_commit IN VARCHAR2 := fnd_api.g_false,
2083: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2084: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2085: px_mass_edit_rec IN OUT NOCOPY mass_edit_rec,
2086: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl ,
2087: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
2088: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
2089: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2090: x_return_status OUT NOCOPY VARCHAR2,
2083: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2084: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2085: px_mass_edit_rec IN OUT NOCOPY mass_edit_rec,
2086: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl ,
2087: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
2088: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
2089: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2090: x_return_status OUT NOCOPY VARCHAR2,
2091: x_msg_count OUT NOCOPY NUMBER ,
2084: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2085: px_mass_edit_rec IN OUT NOCOPY mass_edit_rec,
2086: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl ,
2087: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
2088: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
2089: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2090: x_return_status OUT NOCOPY VARCHAR2,
2091: x_msg_count OUT NOCOPY NUMBER ,
2092: x_msg_data OUT NOCOPY VARCHAR2)
2085: px_mass_edit_rec IN OUT NOCOPY mass_edit_rec,
2086: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl ,
2087: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
2088: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
2089: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
2090: x_return_status OUT NOCOPY VARCHAR2,
2091: x_msg_count OUT NOCOPY NUMBER ,
2092: x_msg_data OUT NOCOPY VARCHAR2)
2093: IS
2315: l_txn_line_id NUMBER;
2316:
2317: upd_system_tbl csi_datastructures_pub.mu_systems_tbl;
2318: l_txn_sys_rec csi_datastructures_pub.system_rec;
2319: l_t_txn_sys_rec csi_t_datastructures_grp.txn_system_rec;
2320: l_mu_new_party_rec mu_new_party_csr%ROWTYPE;
2321: --l_mu_customer_id_rec mu_customer_id_csr%ROWTYPE; -- 7350165
2322: l_mu_system_rec mu_system_csr%ROWTYPE;
2323: l_mu_system_tl_rec mu_system_tl_csr%ROWTYPE;