20: p_commit IN VARCHAR2 := fnd_api.g_false,
21: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
22: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
23: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
24: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
25: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
26: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
27: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
28: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
22: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
23: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
24: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
25: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
26: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
27: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
28: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
29: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
30: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl,
23: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
24: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
25: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
26: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
27: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
28: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
29: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
30: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl,
31: x_return_status OUT NOCOPY VARCHAR2,
24: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
25: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
26: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
27: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
28: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
29: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
30: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl,
31: x_return_status OUT NOCOPY VARCHAR2,
32: x_msg_count OUT NOCOPY NUMBER,
25: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
26: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
27: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
28: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
29: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
30: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl,
31: x_return_status OUT NOCOPY VARCHAR2,
32: x_msg_count OUT NOCOPY NUMBER,
33: x_msg_data OUT NOCOPY VARCHAR2
39: l_msg_count NUMBER;
40: l_msg_data VARCHAR2(2000);
41: l_return_status VARCHAR2(1);
42:
43: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
44: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
45: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
46: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
47: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
40: l_msg_data VARCHAR2(2000);
41: l_return_status VARCHAR2(1);
42:
43: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
44: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
45: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
46: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
47: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
48: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
41: l_return_status VARCHAR2(1);
42:
43: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
44: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
45: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
46: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
47: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
48: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
49: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
42:
43: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
44: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
45: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
46: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
47: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
48: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
49: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
50: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
43: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
44: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
45: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
46: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
47: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
48: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
49: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
50: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
51: err_indx PLS_INTEGER := 0;
44: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
45: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
46: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
47: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
48: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
49: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
50: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
51: err_indx PLS_INTEGER := 0;
52: l_mass_edit_error_tbl csi_mass_edit_pub.mass_edit_error_tbl;
45: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
46: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
47: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
48: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
49: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
50: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
51: err_indx PLS_INTEGER := 0;
52: l_mass_edit_error_tbl csi_mass_edit_pub.mass_edit_error_tbl;
53: l_error_message VARCHAR2(2000);
46: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
47: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
48: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
49: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
50: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
51: err_indx PLS_INTEGER := 0;
52: l_mass_edit_error_tbl csi_mass_edit_pub.mass_edit_error_tbl;
53: l_error_message VARCHAR2(2000);
54: l_msg_index NUMBER;
771: p_commit IN VARCHAR2 := fnd_api.g_false,
772: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
773: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
774: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
775: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
776: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
777: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
778: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
779: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
773: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
774: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
775: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
776: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
777: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
778: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
779: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
780: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
781: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl,
774: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
775: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
776: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
777: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
778: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
779: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
780: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
781: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl,
782: x_return_status OUT NOCOPY VARCHAR2,
775: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
776: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
777: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
778: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
779: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
780: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
781: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl,
782: x_return_status OUT NOCOPY VARCHAR2,
783: x_msg_count OUT NOCOPY NUMBER,
776: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
777: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
778: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
779: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
780: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
781: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl,
782: x_return_status OUT NOCOPY VARCHAR2,
783: x_msg_count OUT NOCOPY NUMBER,
784: x_msg_data OUT NOCOPY VARCHAR2) IS
787: l_api_name VARCHAR2(30) := 'UPDATE_MASS_EDIT_BATCH_PVT';
788: l_msg_count NUMBER;
789: l_msg_data VARCHAR2(200);
790: l_return_status VARCHAR2(1);
791: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
792: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
793: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
794: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
795: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
788: l_msg_count NUMBER;
789: l_msg_data VARCHAR2(200);
790: l_return_status VARCHAR2(1);
791: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
792: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
793: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
794: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
795: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
796: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
789: l_msg_data VARCHAR2(200);
790: l_return_status VARCHAR2(1);
791: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
792: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
793: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
794: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
795: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
796: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
797: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
790: l_return_status VARCHAR2(1);
791: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
792: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
793: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
794: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
795: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
796: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
797: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
798: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
791: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
792: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
793: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
794: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
795: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
796: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
797: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
798: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
799: l_mass_edit_rec csi_mass_edit_pub.mass_edit_rec;
792: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
793: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
794: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
795: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
796: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
797: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
798: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
799: l_mass_edit_rec csi_mass_edit_pub.mass_edit_rec;
800: err_indx PLS_INTEGER := 0;
793: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
794: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
795: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
796: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
797: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
798: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
799: l_mass_edit_rec csi_mass_edit_pub.mass_edit_rec;
800: err_indx PLS_INTEGER := 0;
801: tld_idx PLS_INTEGER := 0;
794: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
795: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
796: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
797: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
798: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
799: l_mass_edit_rec csi_mass_edit_pub.mass_edit_rec;
800: err_indx PLS_INTEGER := 0;
801: tld_idx PLS_INTEGER := 0;
802: inst_idx PLS_INTEGER := 0;
1436: p_commit IN VARCHAR2 := fnd_api.g_false,
1437: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1438: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1439: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
1440: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl ,
1441: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1442: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1443: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1444: x_return_status OUT NOCOPY VARCHAR2,
1437: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1438: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1439: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
1440: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl ,
1441: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1442: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1443: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1444: x_return_status OUT NOCOPY VARCHAR2,
1445: x_msg_count OUT NOCOPY NUMBER ,
1438: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1439: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
1440: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl ,
1441: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1442: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1443: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1444: x_return_status OUT NOCOPY VARCHAR2,
1445: x_msg_count OUT NOCOPY NUMBER ,
1446: x_msg_data OUT NOCOPY VARCHAR2)
1439: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
1440: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl ,
1441: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1442: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1443: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1444: x_return_status OUT NOCOPY VARCHAR2,
1445: x_msg_count OUT NOCOPY NUMBER ,
1446: x_msg_data OUT NOCOPY VARCHAR2)
1447: IS
1450: l_api_name VARCHAR2(30) := 'GET_MASS_EDIT_DETAILS';
1451: l_msg_count NUMBER;
1452: l_msg_data VARCHAR2(2000);
1453: l_return_status VARCHAR2(1);
1454: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;
1455: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
1456: x_tmp_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
1457: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
1458: x_tmp_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl ;
1451: l_msg_count NUMBER;
1452: l_msg_data VARCHAR2(2000);
1453: l_return_status VARCHAR2(1);
1454: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;
1455: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
1456: x_tmp_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
1457: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
1458: x_tmp_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl ;
1459: x_tmp_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
1452: l_msg_data VARCHAR2(2000);
1453: l_return_status VARCHAR2(1);
1454: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;
1455: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
1456: x_tmp_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
1457: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
1458: x_tmp_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl ;
1459: x_tmp_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
1460: x_tmp_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
1453: l_return_status VARCHAR2(1);
1454: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;
1455: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
1456: x_tmp_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
1457: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
1458: x_tmp_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl ;
1459: x_tmp_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
1460: x_tmp_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
1461:
1454: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;
1455: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
1456: x_tmp_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
1457: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
1458: x_tmp_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl ;
1459: x_tmp_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
1460: x_tmp_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
1461:
1462: BEGIN
1455: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
1456: x_tmp_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
1457: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
1458: x_tmp_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl ;
1459: x_tmp_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
1460: x_tmp_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
1461:
1462: BEGIN
1463:
1456: x_tmp_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
1457: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
1458: x_tmp_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl ;
1459: x_tmp_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
1460: x_tmp_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
1461:
1462: BEGIN
1463:
1464: -- Standard Start of API savepoint