DBA Data[Home] [Help]

APPS.CSI_MASS_EDIT_PVT dependencies on CSI_T_DATASTRUCTURES_GRP

Line 24: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,

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,

Line 26: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,

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,

Line 27: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_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,

Line 28: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

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,

Line 29: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

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

Line 43: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

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;

Line 44: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_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;

Line 45: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_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;

Line 46: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_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;

Line 47: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_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;

Line 48: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

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;

Line 49: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_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);

Line 50: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_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);
54: l_msg_index NUMBER;

Line 775: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,

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,

Line 777: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,

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,

Line 778: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_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,

Line 779: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

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,

Line 780: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

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

Line 791: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

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;

Line 792: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_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;

Line 793: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_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;

Line 794: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_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;

Line 795: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_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;

Line 796: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

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;

Line 797: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_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;
801: tld_idx PLS_INTEGER := 0;

Line 798: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_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;
802: inst_idx PLS_INTEGER := 0;

Line 1440: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl ,

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,

Line 1441: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

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 ,

Line 1442: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

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)

Line 1443: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

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

Line 1454: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;

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 ;

Line 1455: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;

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 ;

Line 1456: x_tmp_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_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 ;

Line 1457: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_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:

Line 1458: x_tmp_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl ;

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

Line 1459: x_tmp_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;

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:

Line 1460: x_tmp_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;

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