[Home] [Help]
15: csi_t_gen_utility_pvt.add(p_message);
16: END debug;
17:
18: FUNCTION check_txn_details_exist(
19: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec)
20: RETURN BOOLEAN
21: IS
22: l_debug_level number;
23: l_api_name varchar2(30) := 'check_txn_details_exist';
20: RETURN BOOLEAN
21: IS
22: l_debug_level number;
23: l_api_name varchar2(30) := 'check_txn_details_exist';
24: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
25: l_found BOOLEAN := FALSE;
26: l_select_stmt varchar2(4000);
27: l_lines_where_clause varchar2(2000);
28: l_cursor_id integer;
137: p_commit IN VARCHAR2 := fnd_api.g_false,
138: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
139: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
140: p_split_source_flag IN VARCHAR2 := fnd_api.g_false,
141: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
142: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
143: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
144: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
145: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
138: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
139: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
140: p_split_source_flag IN VARCHAR2 := fnd_api.g_false,
141: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
142: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
143: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
144: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
145: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
146: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
139: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
140: p_split_source_flag IN VARCHAR2 := fnd_api.g_false,
141: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
142: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
143: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
144: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
145: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
146: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
147: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
140: p_split_source_flag IN VARCHAR2 := fnd_api.g_false,
141: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
142: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
143: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
144: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
145: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
146: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
147: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
148: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
141: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
142: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
143: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
144: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
145: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
146: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
147: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
148: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
149: x_return_status OUT NOCOPY VARCHAR2,
142: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
143: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
144: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
145: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
146: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
147: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
148: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
143: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
144: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
145: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
146: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
147: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
148: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2)
144: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
145: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
146: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
147: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
148: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2)
152: IS
160: l_msg_data VARCHAR2(2000);
161:
162: l_td_found char;
163: l_txn_line_id NUMBER;
164: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
165: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
166: l_txn_ii_rltns_rec csi_t_datastructures_grp.txn_ii_rltns_rec;
167:
168: l_txn_system_rec csi_t_datastructures_grp.txn_system_rec;
161:
162: l_td_found char;
163: l_txn_line_id NUMBER;
164: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
165: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
166: l_txn_ii_rltns_rec csi_t_datastructures_grp.txn_ii_rltns_rec;
167:
168: l_txn_system_rec csi_t_datastructures_grp.txn_system_rec;
169: l_txn_system_id NUMBER;
162: l_td_found char;
163: l_txn_line_id NUMBER;
164: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
165: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
166: l_txn_ii_rltns_rec csi_t_datastructures_grp.txn_ii_rltns_rec;
167:
168: l_txn_system_rec csi_t_datastructures_grp.txn_system_rec;
169: l_txn_system_id NUMBER;
170:
164: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
165: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
166: l_txn_ii_rltns_rec csi_t_datastructures_grp.txn_ii_rltns_rec;
167:
168: l_txn_system_rec csi_t_datastructures_grp.txn_system_rec;
169: l_txn_system_id NUMBER;
170:
171: l_txn_source_name csi_txn_types.source_transaction_type%type;
172: l_obj_tld_id NUMBER ;
789: p_api_version IN NUMBER
790: ,p_commit IN VARCHAR2 := fnd_api.g_false
791: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
792: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
793: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
794: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
795: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
796: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
797: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
790: ,p_commit IN VARCHAR2 := fnd_api.g_false
791: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
792: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
793: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
794: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
795: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
796: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
797: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
798: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
791: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
792: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
793: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
794: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
795: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
796: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
797: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
798: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
799: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
792: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
793: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
794: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
795: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
796: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
797: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
798: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
799: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
800: ,x_return_status OUT NOCOPY VARCHAR2
793: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
794: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
795: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
796: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
797: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
798: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
799: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
800: ,x_return_status OUT NOCOPY VARCHAR2
801: ,x_msg_count OUT NOCOPY NUMBER
794: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
795: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
796: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
797: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
798: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
799: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
800: ,x_return_status OUT NOCOPY VARCHAR2
801: ,x_msg_count OUT NOCOPY NUMBER
802: ,x_msg_data OUT NOCOPY VARCHAR2)
795: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
796: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
797: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
798: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
799: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
800: ,x_return_status OUT NOCOPY VARCHAR2
801: ,x_msg_count OUT NOCOPY NUMBER
802: ,x_msg_data OUT NOCOPY VARCHAR2)
803: IS
809: l_return_status VARCHAR2(1) := FND_API.G_ret_sts_success;
810: l_msg_count NUMBER;
811: l_msg_data VARCHAR2(2000);
812:
813: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
814: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
815: l_u_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
816: l_d_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
817: l_c_tld_ind binary_integer;
810: l_msg_count NUMBER;
811: l_msg_data VARCHAR2(2000);
812:
813: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
814: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
815: l_u_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
816: l_d_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
817: l_c_tld_ind binary_integer;
818: l_u_tld_ind binary_integer;
811: l_msg_data VARCHAR2(2000);
812:
813: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
814: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
815: l_u_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
816: l_d_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
817: l_c_tld_ind binary_integer;
818: l_u_tld_ind binary_integer;
819: l_d_tld_ind binary_integer;
812:
813: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
814: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
815: l_u_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
816: l_d_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
817: l_c_tld_ind binary_integer;
818: l_u_tld_ind binary_integer;
819: l_d_tld_ind binary_integer;
820:
817: l_c_tld_ind binary_integer;
818: l_u_tld_ind binary_integer;
819: l_d_tld_ind binary_integer;
820:
821: l_c_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
822: l_u_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
823: l_d_pty_ids_tbl csi_t_datastructures_grp.txn_party_ids_tbl;
824: l_c_pty_ind binary_integer;
825: l_u_pty_ind binary_integer;
818: l_u_tld_ind binary_integer;
819: l_d_tld_ind binary_integer;
820:
821: l_c_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
822: l_u_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
823: l_d_pty_ids_tbl csi_t_datastructures_grp.txn_party_ids_tbl;
824: l_c_pty_ind binary_integer;
825: l_u_pty_ind binary_integer;
826: l_d_pty_ind binary_integer;
819: l_d_tld_ind binary_integer;
820:
821: l_c_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
822: l_u_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
823: l_d_pty_ids_tbl csi_t_datastructures_grp.txn_party_ids_tbl;
824: l_c_pty_ind binary_integer;
825: l_u_pty_ind binary_integer;
826: l_d_pty_ind binary_integer;
827:
824: l_c_pty_ind binary_integer;
825: l_u_pty_ind binary_integer;
826: l_d_pty_ind binary_integer;
827:
828: l_c_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
829: l_u_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
830: l_d_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
831: l_c_pa_ind binary_integer;
832: l_u_pa_ind binary_integer;
825: l_u_pty_ind binary_integer;
826: l_d_pty_ind binary_integer;
827:
828: l_c_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
829: l_u_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
830: l_d_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
831: l_c_pa_ind binary_integer;
832: l_u_pa_ind binary_integer;
833: l_d_pa_ind binary_integer;
826: l_d_pty_ind binary_integer;
827:
828: l_c_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
829: l_u_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
830: l_d_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
831: l_c_pa_ind binary_integer;
832: l_u_pa_ind binary_integer;
833: l_d_pa_ind binary_integer;
834:
831: l_c_pa_ind binary_integer;
832: l_u_pa_ind binary_integer;
833: l_d_pa_ind binary_integer;
834:
835: l_c_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
836: l_u_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
837: l_c_ea_ind binary_integer;
838: l_u_ea_ind binary_integer;
839:
832: l_u_pa_ind binary_integer;
833: l_d_pa_ind binary_integer;
834:
835: l_c_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
836: l_u_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
837: l_c_ea_ind binary_integer;
838: l_u_ea_ind binary_integer;
839:
840: l_c_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
836: l_u_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
837: l_c_ea_ind binary_integer;
838: l_u_ea_ind binary_integer;
839:
840: l_c_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
841: l_u_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
842: l_c_oa_ind binary_integer;
843: l_u_oa_ind binary_integer;
844:
837: l_c_ea_ind binary_integer;
838: l_u_ea_ind binary_integer;
839:
840: l_c_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
841: l_u_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
842: l_c_oa_ind binary_integer;
843: l_u_oa_ind binary_integer;
844:
845: l_c_ii_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
841: l_u_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
842: l_c_oa_ind binary_integer;
843: l_u_oa_ind binary_integer;
844:
845: l_c_ii_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
846: l_u_ii_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
847: l_c_ii_ind binary_integer;
848:
849: l_indx PLS_INTEGER ;
842: l_c_oa_ind binary_integer;
843: l_u_oa_ind binary_integer;
844:
845: l_c_ii_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
846: l_u_ii_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
847: l_c_ii_ind binary_integer;
848:
849: l_indx PLS_INTEGER ;
850: i PLS_INTEGER ;
847: l_c_ii_ind binary_integer;
848:
849: l_indx PLS_INTEGER ;
850: i PLS_INTEGER ;
851: x_tmp_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
852: x_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
853: x_tmp_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl ;
854: x_tmp_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
855: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
848:
849: l_indx PLS_INTEGER ;
850: i PLS_INTEGER ;
851: x_tmp_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
852: x_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
853: x_tmp_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl ;
854: x_tmp_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
855: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
856: x_tmp_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
849: l_indx PLS_INTEGER ;
850: i PLS_INTEGER ;
851: x_tmp_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
852: x_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
853: x_tmp_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl ;
854: x_tmp_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
855: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
856: x_tmp_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
857: x_tmp_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
850: i PLS_INTEGER ;
851: x_tmp_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
852: x_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
853: x_tmp_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl ;
854: x_tmp_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
855: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
856: x_tmp_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
857: x_tmp_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
858: x_tmp_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
851: x_tmp_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
852: x_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
853: x_tmp_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl ;
854: x_tmp_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
855: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
856: x_tmp_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
857: x_tmp_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
858: x_tmp_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
859: l_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
852: x_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
853: x_tmp_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl ;
854: x_tmp_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
855: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
856: x_tmp_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
857: x_tmp_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
858: x_tmp_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
859: l_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
860: l_exists VARCHAR2(1);
853: x_tmp_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl ;
854: x_tmp_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
855: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
856: x_tmp_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
857: x_tmp_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
858: x_tmp_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
859: l_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
860: l_exists VARCHAR2(1);
861:
854: x_tmp_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
855: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
856: x_tmp_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
857: x_tmp_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
858: x_tmp_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
859: l_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
860: l_exists VARCHAR2(1);
861:
862: BEGIN
855: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
856: x_tmp_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
857: x_tmp_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
858: x_tmp_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
859: l_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
860: l_exists VARCHAR2(1);
861:
862: BEGIN
863: -- Standard Start of API savepoint
1657: l_ea_ind BINARY_INTEGER;
1658:
1659:
1660: /* table type definitions */
1661: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1662: l_line_dtl_ids_tbl csi_t_datastructures_grp.txn_line_detail_ids_tbl;
1663: l_party_ids_tbl csi_t_datastructures_grp.txn_party_ids_tbl;
1664: l_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
1665: l_ii_rltns_ids_tbl csi_t_datastructures_grp.txn_ii_rltns_ids_tbl;
1658:
1659:
1660: /* table type definitions */
1661: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1662: l_line_dtl_ids_tbl csi_t_datastructures_grp.txn_line_detail_ids_tbl;
1663: l_party_ids_tbl csi_t_datastructures_grp.txn_party_ids_tbl;
1664: l_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
1665: l_ii_rltns_ids_tbl csi_t_datastructures_grp.txn_ii_rltns_ids_tbl;
1666: l_org_assgn_ids_tbl csi_t_datastructures_grp.txn_org_assgn_ids_tbl;
1659:
1660: /* table type definitions */
1661: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1662: l_line_dtl_ids_tbl csi_t_datastructures_grp.txn_line_detail_ids_tbl;
1663: l_party_ids_tbl csi_t_datastructures_grp.txn_party_ids_tbl;
1664: l_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
1665: l_ii_rltns_ids_tbl csi_t_datastructures_grp.txn_ii_rltns_ids_tbl;
1666: l_org_assgn_ids_tbl csi_t_datastructures_grp.txn_org_assgn_ids_tbl;
1667: l_ext_attrib_ids_tbl csi_t_datastructures_grp.txn_ext_attrib_ids_tbl;
1660: /* table type definitions */
1661: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1662: l_line_dtl_ids_tbl csi_t_datastructures_grp.txn_line_detail_ids_tbl;
1663: l_party_ids_tbl csi_t_datastructures_grp.txn_party_ids_tbl;
1664: l_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
1665: l_ii_rltns_ids_tbl csi_t_datastructures_grp.txn_ii_rltns_ids_tbl;
1666: l_org_assgn_ids_tbl csi_t_datastructures_grp.txn_org_assgn_ids_tbl;
1667: l_ext_attrib_ids_tbl csi_t_datastructures_grp.txn_ext_attrib_ids_tbl;
1668:
1661: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1662: l_line_dtl_ids_tbl csi_t_datastructures_grp.txn_line_detail_ids_tbl;
1663: l_party_ids_tbl csi_t_datastructures_grp.txn_party_ids_tbl;
1664: l_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
1665: l_ii_rltns_ids_tbl csi_t_datastructures_grp.txn_ii_rltns_ids_tbl;
1666: l_org_assgn_ids_tbl csi_t_datastructures_grp.txn_org_assgn_ids_tbl;
1667: l_ext_attrib_ids_tbl csi_t_datastructures_grp.txn_ext_attrib_ids_tbl;
1668:
1669: l_txn_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
1662: l_line_dtl_ids_tbl csi_t_datastructures_grp.txn_line_detail_ids_tbl;
1663: l_party_ids_tbl csi_t_datastructures_grp.txn_party_ids_tbl;
1664: l_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
1665: l_ii_rltns_ids_tbl csi_t_datastructures_grp.txn_ii_rltns_ids_tbl;
1666: l_org_assgn_ids_tbl csi_t_datastructures_grp.txn_org_assgn_ids_tbl;
1667: l_ext_attrib_ids_tbl csi_t_datastructures_grp.txn_ext_attrib_ids_tbl;
1668:
1669: l_txn_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
1670:
1663: l_party_ids_tbl csi_t_datastructures_grp.txn_party_ids_tbl;
1664: l_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
1665: l_ii_rltns_ids_tbl csi_t_datastructures_grp.txn_ii_rltns_ids_tbl;
1666: l_org_assgn_ids_tbl csi_t_datastructures_grp.txn_org_assgn_ids_tbl;
1667: l_ext_attrib_ids_tbl csi_t_datastructures_grp.txn_ext_attrib_ids_tbl;
1668:
1669: l_txn_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
1670:
1671:
1665: l_ii_rltns_ids_tbl csi_t_datastructures_grp.txn_ii_rltns_ids_tbl;
1666: l_org_assgn_ids_tbl csi_t_datastructures_grp.txn_org_assgn_ids_tbl;
1667: l_ext_attrib_ids_tbl csi_t_datastructures_grp.txn_ext_attrib_ids_tbl;
1668:
1669: l_txn_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
1670:
1671:
1672: CURSOR td_cur IS
1673: SELECT txn_line_detail_id
2129:
2130: /* Overloaded routine added and used : Bug 2543266 */
2131:
2132: PROCEDURE get_txn_systems(
2133: p_txn_line_dtl_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,
2134: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
2135: x_return_status OUT NOCOPY varchar2)
2136: IS
2137:
2130: /* Overloaded routine added and used : Bug 2543266 */
2131:
2132: PROCEDURE get_txn_systems(
2133: p_txn_line_dtl_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,
2134: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
2135: x_return_status OUT NOCOPY varchar2)
2136: IS
2137:
2138: l_txn_system_id number ;
2231: Commented for Bug 2543266 . Using overloaded routine above instead.
2232:
2233: PROCEDURE get_txn_systems(
2234: p_txn_system_id_list in varchar2,
2235: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
2236: x_return_status OUT NOCOPY varchar2)
2237: IS
2238:
2239: l_select_stmt varchar2(2000);
2237: IS
2238:
2239: l_select_stmt varchar2(2000);
2240: l_sys_cur_id integer;
2241: l_sys_rec csi_t_datastructures_grp.txn_system_rec;
2242: l_processed_rows number := 0;
2243: l_ind binary_integer;
2244:
2245: BEGIN
2360: p_api_version IN NUMBER
2361: ,p_commit IN VARCHAR2 := fnd_api.g_false
2362: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2363: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
2364: ,p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec
2365: ,p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec
2366: ,x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
2367: ,p_get_parties_flag IN VARCHAR2 := fnd_api.g_false
2368: ,x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
2361: ,p_commit IN VARCHAR2 := fnd_api.g_false
2362: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2363: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
2364: ,p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec
2365: ,p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec
2366: ,x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
2367: ,p_get_parties_flag IN VARCHAR2 := fnd_api.g_false
2368: ,x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
2369: ,p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false
2362: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2363: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
2364: ,p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec
2365: ,p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec
2366: ,x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
2367: ,p_get_parties_flag IN VARCHAR2 := fnd_api.g_false
2368: ,x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
2369: ,p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false
2370: ,x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
2364: ,p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec
2365: ,p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec
2366: ,x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
2367: ,p_get_parties_flag IN VARCHAR2 := fnd_api.g_false
2368: ,x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
2369: ,p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false
2370: ,x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
2371: ,p_get_ii_rltns_flag IN VARCHAR2 := fnd_api.g_false
2372: ,x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
2366: ,x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
2367: ,p_get_parties_flag IN VARCHAR2 := fnd_api.g_false
2368: ,x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
2369: ,p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false
2370: ,x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
2371: ,p_get_ii_rltns_flag IN VARCHAR2 := fnd_api.g_false
2372: ,x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
2373: ,p_get_org_assgns_flag IN VARCHAR2 := fnd_api.g_false
2374: ,x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
2368: ,x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
2369: ,p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false
2370: ,x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
2371: ,p_get_ii_rltns_flag IN VARCHAR2 := fnd_api.g_false
2372: ,x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
2373: ,p_get_org_assgns_flag IN VARCHAR2 := fnd_api.g_false
2374: ,x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
2375: ,p_get_ext_attrib_vals_flag IN VARCHAR2 := fnd_api.g_false
2376: ,x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
2370: ,x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
2371: ,p_get_ii_rltns_flag IN VARCHAR2 := fnd_api.g_false
2372: ,x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
2373: ,p_get_org_assgns_flag IN VARCHAR2 := fnd_api.g_false
2374: ,x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
2375: ,p_get_ext_attrib_vals_flag IN VARCHAR2 := fnd_api.g_false
2376: ,x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
2377: ,p_get_csi_attribs_flag IN VARCHAR2 := fnd_api.g_false
2378: ,x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl
2372: ,x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
2373: ,p_get_org_assgns_flag IN VARCHAR2 := fnd_api.g_false
2374: ,x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
2375: ,p_get_ext_attrib_vals_flag IN VARCHAR2 := fnd_api.g_false
2376: ,x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
2377: ,p_get_csi_attribs_flag IN VARCHAR2 := fnd_api.g_false
2378: ,x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl
2379: ,p_get_csi_iea_values_flag IN VARCHAR2 := fnd_api.g_false
2380: ,x_csi_iea_values_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl
2374: ,x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
2375: ,p_get_ext_attrib_vals_flag IN VARCHAR2 := fnd_api.g_false
2376: ,x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
2377: ,p_get_csi_attribs_flag IN VARCHAR2 := fnd_api.g_false
2378: ,x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl
2379: ,p_get_csi_iea_values_flag IN VARCHAR2 := fnd_api.g_false
2380: ,x_csi_iea_values_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl
2381: ,p_get_txn_systems_flag IN VARCHAR2 := fnd_api.g_false
2382: ,x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl
2376: ,x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
2377: ,p_get_csi_attribs_flag IN VARCHAR2 := fnd_api.g_false
2378: ,x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl
2379: ,p_get_csi_iea_values_flag IN VARCHAR2 := fnd_api.g_false
2380: ,x_csi_iea_values_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl
2381: ,p_get_txn_systems_flag IN VARCHAR2 := fnd_api.g_false
2382: ,x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl
2383: ,x_return_status OUT NOCOPY VARCHAR2
2384: ,x_msg_count OUT NOCOPY NUMBER
2378: ,x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl
2379: ,p_get_csi_iea_values_flag IN VARCHAR2 := fnd_api.g_false
2380: ,x_csi_iea_values_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl
2381: ,p_get_txn_systems_flag IN VARCHAR2 := fnd_api.g_false
2382: ,x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl
2383: ,x_return_status OUT NOCOPY VARCHAR2
2384: ,x_msg_count OUT NOCOPY NUMBER
2385: ,x_msg_data OUT NOCOPY VARCHAR2)
2386: IS
2396: l_txn_line_id_list varchar2(1000);
2397: l_instance_id_list varchar2(1000);
2398: l_txn_system_id_list varchar2(1000);
2399:
2400: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2401: l_txn_party_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2402: l_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2403: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2404: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2397: l_instance_id_list varchar2(1000);
2398: l_txn_system_id_list varchar2(1000);
2399:
2400: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2401: l_txn_party_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2402: l_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2403: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2404: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2405: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2398: l_txn_system_id_list varchar2(1000);
2399:
2400: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2401: l_txn_party_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2402: l_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2403: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2404: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2405: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2406: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2399:
2400: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2401: l_txn_party_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2402: l_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2403: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2404: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2405: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2406: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2407: l_csi_ea_vals_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2400: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2401: l_txn_party_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2402: l_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2403: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2404: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2405: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2406: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2407: l_csi_ea_vals_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2408: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2401: l_txn_party_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2402: l_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2403: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2404: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2405: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2406: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2407: l_csi_ea_vals_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2408: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2409: l_index NUMBER := 0 ;
2402: l_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2403: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2404: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2405: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2406: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2407: l_csi_ea_vals_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2408: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2409: l_index NUMBER := 0 ;
2410: l_txn_line_id NUMBER ;
2403: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2404: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2405: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2406: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2407: l_csi_ea_vals_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2408: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2409: l_index NUMBER := 0 ;
2410: l_txn_line_id NUMBER ;
2411: l_relation_exists BOOLEAN ;
2404: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2405: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2406: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2407: l_csi_ea_vals_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2408: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2409: l_index NUMBER := 0 ;
2410: l_txn_line_id NUMBER ;
2411: l_relation_exists BOOLEAN ;
2412:
2817: END get_transaction_details;
2818:
2819: FUNCTION check_td_for_create(
2820: p_txn_line_dtl_id in number,
2821: p_txn_line_dtl_tbl in csi_t_datastructures_grp.txn_line_detail_tbl)
2822: RETURN boolean
2823: IS
2824: l_return boolean := FALSE;
2825: BEGIN
2840: p_api_version IN NUMBER,
2841: p_commit IN VARCHAR2 := fnd_api.g_false,
2842: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2843: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2844: p_upd_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
2845: p_upd_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
2846: px_crt_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
2847: px_crt_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2848: x_return_status OUT NOCOPY VARCHAR2,
2841: p_commit IN VARCHAR2 := fnd_api.g_false,
2842: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2843: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2844: p_upd_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
2845: p_upd_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
2846: px_crt_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
2847: px_crt_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2848: x_return_status OUT NOCOPY VARCHAR2,
2849: x_msg_count OUT NOCOPY NUMBER,
2842: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2843: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2844: p_upd_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
2845: p_upd_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
2846: px_crt_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
2847: px_crt_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2848: x_return_status OUT NOCOPY VARCHAR2,
2849: x_msg_count OUT NOCOPY NUMBER,
2850: x_msg_data OUT NOCOPY VARCHAR2)
2843: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2844: p_upd_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
2845: p_upd_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
2846: px_crt_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
2847: px_crt_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2848: x_return_status OUT NOCOPY VARCHAR2,
2849: x_msg_count OUT NOCOPY NUMBER,
2850: x_msg_data OUT NOCOPY VARCHAR2)
2851: IS
2864: l_c_ii_ind binary_integer;
2865: l_c_oa_ind binary_integer;
2866: l_c_ea_ind binary_integer;
2867:
2868: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2869: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2870:
2871: l_c_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2872: l_c_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2865: l_c_oa_ind binary_integer;
2866: l_c_ea_ind binary_integer;
2867:
2868: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2869: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2870:
2871: l_c_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2872: l_c_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2873: l_c_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2867:
2868: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2869: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2870:
2871: l_c_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2872: l_c_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2873: l_c_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2874: l_c_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2875: l_c_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2868: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2869: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2870:
2871: l_c_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2872: l_c_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2873: l_c_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2874: l_c_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2875: l_c_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2876: l_c_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2869: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2870:
2871: l_c_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2872: l_c_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2873: l_c_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2874: l_c_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2875: l_c_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2876: l_c_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2877: l_c_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2870:
2871: l_c_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2872: l_c_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2873: l_c_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2874: l_c_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2875: l_c_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2876: l_c_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2877: l_c_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2878:
2871: l_c_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2872: l_c_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2873: l_c_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2874: l_c_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2875: l_c_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2876: l_c_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2877: l_c_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2878:
2879: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2872: l_c_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2873: l_c_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2874: l_c_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2875: l_c_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2876: l_c_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2877: l_c_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2878:
2879: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2880: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2873: l_c_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2874: l_c_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2875: l_c_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2876: l_c_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2877: l_c_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2878:
2879: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2880: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2881: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2875: l_c_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2876: l_c_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2877: l_c_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2878:
2879: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2880: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2881: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2882: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2883: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2876: l_c_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2877: l_c_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2878:
2879: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2880: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2881: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2882: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2883: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2884: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2877: l_c_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2878:
2879: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2880: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2881: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2882: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2883: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2884: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2885: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2878:
2879: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2880: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2881: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2882: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2883: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2884: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2885: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2886: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2879: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2880: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2881: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2882: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2883: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2884: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2885: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2886: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2887: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2880: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2881: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2882: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2883: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2884: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2885: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2886: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2887: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2888:
2881: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2882: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2883: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2884: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2885: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2886: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2887: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2888:
2889: l_ln_id_ind binary_integer;
2882: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2883: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2884: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2885: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2886: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2887: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2888:
2889: l_ln_id_ind binary_integer;
2890:
2883: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2884: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2885: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2886: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2887: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2888:
2889: l_ln_id_ind binary_integer;
2890:
2891: l_line_dtl_ids_tbl csi_t_datastructures_grp.txn_line_detail_ids_tbl;
2887: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2888:
2889: l_ln_id_ind binary_integer;
2890:
2891: l_line_dtl_ids_tbl csi_t_datastructures_grp.txn_line_detail_ids_tbl;
2892: l_txn_line_id csi_t_transaction_lines.transaction_line_id%type;
2893:
2894: l_create boolean := FALSE;
2895:
3191: p_api_version IN NUMBER,
3192: p_commit IN VARCHAR2 := fnd_api.g_false,
3193: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3194: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
3195: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
3196: px_new_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
3197: p_copy_parties_flag IN varchar2 := fnd_api.g_true,
3198: p_copy_pty_accts_flag IN varchar2 := fnd_api.g_true,
3199: p_copy_ii_rltns_flag IN varchar2 := fnd_api.g_true,
3192: p_commit IN VARCHAR2 := fnd_api.g_false,
3193: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3194: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
3195: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
3196: px_new_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
3197: p_copy_parties_flag IN varchar2 := fnd_api.g_true,
3198: p_copy_pty_accts_flag IN varchar2 := fnd_api.g_true,
3199: p_copy_ii_rltns_flag IN varchar2 := fnd_api.g_true,
3200: p_copy_org_assgn_flag IN varchar2 := fnd_api.g_true,
3212: l_return_status VARCHAR2(1) := FND_API.G_ret_sts_success;
3213: l_msg_count NUMBER;
3214: l_msg_data VARCHAR2(2000);
3215:
3216: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3217: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3218: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3219: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3220: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3213: l_msg_count NUMBER;
3214: l_msg_data VARCHAR2(2000);
3215:
3216: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3217: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3218: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3219: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3220: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3221: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3214: l_msg_data VARCHAR2(2000);
3215:
3216: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3217: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3218: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3219: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3220: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3221: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3222: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3215:
3216: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3217: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3218: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3219: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3220: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3221: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3222: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3223: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3216: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3217: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3218: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3219: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3220: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3221: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3222: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3223: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3224: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3217: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3218: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3219: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3220: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3221: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3222: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3223: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3224: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3225:
3218: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3219: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3220: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3221: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3222: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3223: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3224: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3225:
3226: l_txn_line_id csi_t_transaction_lines.transaction_line_id%type;
3219: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3220: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3221: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3222: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3223: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3224: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3225:
3226: l_txn_line_id csi_t_transaction_lines.transaction_line_id%type;
3227: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3220: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3221: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3222: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3223: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3224: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3225:
3226: l_txn_line_id csi_t_transaction_lines.transaction_line_id%type;
3227: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3228: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3223: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3224: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3225:
3226: l_txn_line_id csi_t_transaction_lines.transaction_line_id%type;
3227: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3228: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3229:
3230: BEGIN
3231:
3224: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3225:
3226: l_txn_line_id csi_t_transaction_lines.transaction_line_id%type;
3227: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3228: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3229:
3230: BEGIN
3231:
3232: -- Standard Start of API savepoint
3434: p_api_version IN NUMBER,
3435: p_commit IN VARCHAR2 := fnd_api.g_false,
3436: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3437: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
3438: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
3439: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
3440: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
3441: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
3442: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
3435: p_commit IN VARCHAR2 := fnd_api.g_false,
3436: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3437: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
3438: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
3439: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
3440: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
3441: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
3442: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
3443: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
3436: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3437: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
3438: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
3439: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
3440: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
3441: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
3442: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
3443: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
3444: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3437: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
3438: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
3439: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
3440: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
3441: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
3442: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
3443: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
3444: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3445: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
3438: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
3439: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
3440: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
3441: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
3442: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
3443: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
3444: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3445: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
3446: x_return_status OUT NOCOPY VARCHAR2,
3439: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
3440: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
3441: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
3442: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
3443: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
3444: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3445: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
3446: x_return_status OUT NOCOPY VARCHAR2,
3447: x_msg_count OUT NOCOPY NUMBER,
3440: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
3441: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
3442: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
3443: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
3444: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3445: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
3446: x_return_status OUT NOCOPY VARCHAR2,
3447: x_msg_count OUT NOCOPY NUMBER,
3448: x_msg_data OUT NOCOPY VARCHAR2
3441: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
3442: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
3443: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
3444: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3445: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
3446: x_return_status OUT NOCOPY VARCHAR2,
3447: x_msg_count OUT NOCOPY NUMBER,
3448: x_msg_data OUT NOCOPY VARCHAR2
3449: ) IS
3448: x_msg_data OUT NOCOPY VARCHAR2
3449: ) IS
3450:
3451: l_item_control_rec csi_order_ship_pub.item_control_rec;
3452: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3453: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3454: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3455: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3456: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3449: ) IS
3450:
3451: l_item_control_rec csi_order_ship_pub.item_control_rec;
3452: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3453: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3454: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3455: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3456: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3457: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3450:
3451: l_item_control_rec csi_order_ship_pub.item_control_rec;
3452: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3453: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3454: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3455: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3456: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3457: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3458: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3451: l_item_control_rec csi_order_ship_pub.item_control_rec;
3452: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3453: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3454: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3455: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3456: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3457: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3458: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3459: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3452: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3453: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3454: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3455: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3456: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3457: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3458: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3459: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3460: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3453: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3454: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3455: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3456: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3457: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3458: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3459: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3460: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3461: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3454: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3455: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3456: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3457: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3458: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3459: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3460: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3461: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3462: l_txn_line_id csi_t_transaction_lines.transaction_line_id%type;
3455: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3456: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3457: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3458: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3459: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3460: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3461: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3462: l_txn_line_id csi_t_transaction_lines.transaction_line_id%type;
3463: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3456: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3457: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3458: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3459: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3460: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3461: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3462: l_txn_line_id csi_t_transaction_lines.transaction_line_id%type;
3463: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3464:
3457: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3458: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3459: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3460: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3461: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3462: l_txn_line_id csi_t_transaction_lines.transaction_line_id%type;
3463: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3464:
3465: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3459: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3460: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3461: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3462: l_txn_line_id csi_t_transaction_lines.transaction_line_id%type;
3463: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3464:
3465: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3466: l_msg_count number;
3467: l_msg_data varchar2(2000);