14: Returns a 'Y' or 'N'
15: */
16:
17: FUNCTION check_txn_details_exist(
18: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec)
19: RETURN BOOLEAN
20: IS
21:
22: l_found boolean := FALSE;
70: p_api_version IN NUMBER
71: ,p_commit IN VARCHAR2 := fnd_api.g_false
72: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
73: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
74: ,p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec
75: ,p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec
76: ,x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
77: ,p_get_parties_flag IN VARCHAR2 := fnd_api.g_false
78: ,x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
71: ,p_commit IN VARCHAR2 := fnd_api.g_false
72: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
73: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
74: ,p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec
75: ,p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec
76: ,x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
77: ,p_get_parties_flag IN VARCHAR2 := fnd_api.g_false
78: ,x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
79: ,p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false
72: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
73: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
74: ,p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec
75: ,p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec
76: ,x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
77: ,p_get_parties_flag IN VARCHAR2 := fnd_api.g_false
78: ,x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
79: ,p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false
80: ,x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
74: ,p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec
75: ,p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec
76: ,x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
77: ,p_get_parties_flag IN VARCHAR2 := fnd_api.g_false
78: ,x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
79: ,p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false
80: ,x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
81: ,p_get_ii_rltns_flag IN VARCHAR2 := fnd_api.g_false
82: ,x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
76: ,x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
77: ,p_get_parties_flag IN VARCHAR2 := fnd_api.g_false
78: ,x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
79: ,p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false
80: ,x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
81: ,p_get_ii_rltns_flag IN VARCHAR2 := fnd_api.g_false
82: ,x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
83: ,p_get_org_assgns_flag IN VARCHAR2 := fnd_api.g_false
84: ,x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
78: ,x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
79: ,p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false
80: ,x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
81: ,p_get_ii_rltns_flag IN VARCHAR2 := fnd_api.g_false
82: ,x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
83: ,p_get_org_assgns_flag IN VARCHAR2 := fnd_api.g_false
84: ,x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
85: ,p_get_ext_attrib_vals_flag IN VARCHAR2 := fnd_api.g_false
86: ,x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
80: ,x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
81: ,p_get_ii_rltns_flag IN VARCHAR2 := fnd_api.g_false
82: ,x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
83: ,p_get_org_assgns_flag IN VARCHAR2 := fnd_api.g_false
84: ,x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
85: ,p_get_ext_attrib_vals_flag IN VARCHAR2 := fnd_api.g_false
86: ,x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
87: ,p_get_csi_attribs_flag IN VARCHAR2 := fnd_api.g_false
88: ,x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl
82: ,x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
83: ,p_get_org_assgns_flag IN VARCHAR2 := fnd_api.g_false
84: ,x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
85: ,p_get_ext_attrib_vals_flag IN VARCHAR2 := fnd_api.g_false
86: ,x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
87: ,p_get_csi_attribs_flag IN VARCHAR2 := fnd_api.g_false
88: ,x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl
89: ,p_get_csi_iea_values_flag IN VARCHAR2 := fnd_api.g_false
90: ,x_csi_iea_values_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl
84: ,x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
85: ,p_get_ext_attrib_vals_flag IN VARCHAR2 := fnd_api.g_false
86: ,x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
87: ,p_get_csi_attribs_flag IN VARCHAR2 := fnd_api.g_false
88: ,x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl
89: ,p_get_csi_iea_values_flag IN VARCHAR2 := fnd_api.g_false
90: ,x_csi_iea_values_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl
91: ,p_get_txn_systems_flag IN VARCHAR2 := fnd_api.g_false
92: ,x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl
86: ,x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
87: ,p_get_csi_attribs_flag IN VARCHAR2 := fnd_api.g_false
88: ,x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl
89: ,p_get_csi_iea_values_flag IN VARCHAR2 := fnd_api.g_false
90: ,x_csi_iea_values_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl
91: ,p_get_txn_systems_flag IN VARCHAR2 := fnd_api.g_false
92: ,x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl
93: ,x_return_status OUT NOCOPY VARCHAR2
94: ,x_msg_count OUT NOCOPY NUMBER
88: ,x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl
89: ,p_get_csi_iea_values_flag IN VARCHAR2 := fnd_api.g_false
90: ,x_csi_iea_values_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl
91: ,p_get_txn_systems_flag IN VARCHAR2 := fnd_api.g_false
92: ,x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl
93: ,x_return_status OUT NOCOPY VARCHAR2
94: ,x_msg_count OUT NOCOPY NUMBER
95: ,x_msg_data OUT NOCOPY VARCHAR2)
96: IS
106: ---Added (Start) for m-to-m enhancements
107: l_get_ii_rltns_flag VARCHAR2(10);
108: l_indx PLS_INTEGER ;
109: i PLS_INTEGER ;
110: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;
111: l_loop_cnt NUMBER ;
112: x_tmp_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
113: x_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
114: x_tmp_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl ;
108: l_indx PLS_INTEGER ;
109: i PLS_INTEGER ;
110: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;
111: l_loop_cnt NUMBER ;
112: x_tmp_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
113: x_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
114: x_tmp_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl ;
115: x_tmp_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
116: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
109: i PLS_INTEGER ;
110: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;
111: l_loop_cnt NUMBER ;
112: x_tmp_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
113: x_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
114: x_tmp_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl ;
115: x_tmp_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
116: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
117: x_tmp_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
110: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;
111: l_loop_cnt NUMBER ;
112: x_tmp_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
113: x_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
114: x_tmp_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl ;
115: x_tmp_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
116: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
117: x_tmp_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
118: x_tmp_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl ;
111: l_loop_cnt NUMBER ;
112: x_tmp_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
113: x_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
114: x_tmp_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl ;
115: x_tmp_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
116: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
117: x_tmp_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
118: x_tmp_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl ;
119: x_tmp_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
112: x_tmp_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
113: x_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
114: x_tmp_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl ;
115: x_tmp_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
116: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
117: x_tmp_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
118: x_tmp_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl ;
119: x_tmp_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
120: x_tmp_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
113: x_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
114: x_tmp_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl ;
115: x_tmp_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
116: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
117: x_tmp_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
118: x_tmp_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl ;
119: x_tmp_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
120: x_tmp_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
121: l_relation_exists BOOLEAN ;
114: x_tmp_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl ;
115: x_tmp_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
116: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
117: x_tmp_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
118: x_tmp_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl ;
119: x_tmp_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
120: x_tmp_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
121: l_relation_exists BOOLEAN ;
122:
115: x_tmp_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
116: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
117: x_tmp_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
118: x_tmp_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl ;
119: x_tmp_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
120: x_tmp_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
121: l_relation_exists BOOLEAN ;
122:
123: CURSOR txn_line_cur (c_header_id IN NUMBER, c_line_id IN NUMBER)
116: x_tmp_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
117: x_tmp_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
118: x_tmp_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl ;
119: x_tmp_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
120: x_tmp_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
121: l_relation_exists BOOLEAN ;
122:
123: CURSOR txn_line_cur (c_header_id IN NUMBER, c_line_id IN NUMBER)
124: IS
487: p_api_version IN NUMBER
488: ,p_commit IN VARCHAR2 := fnd_api.g_false
489: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
490: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
491: ,px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec
492: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
493: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
494: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
495: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
488: ,p_commit IN VARCHAR2 := fnd_api.g_false
489: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
490: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
491: ,px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec
492: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
493: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
494: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
495: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
496: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
489: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
490: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
491: ,px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec
492: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
493: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
494: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
495: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
496: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
497: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
490: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
491: ,px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec
492: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
493: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
494: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
495: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
496: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
497: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
498: ,px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl
491: ,px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec
492: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
493: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
494: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
495: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
496: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
497: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
498: ,px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl
499: ,x_return_status OUT NOCOPY VARCHAR2
492: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
493: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
494: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
495: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
496: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
497: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
498: ,px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl
499: ,x_return_status OUT NOCOPY VARCHAR2
500: ,x_msg_count OUT NOCOPY NUMBER
493: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
494: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
495: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
496: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
497: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
498: ,px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl
499: ,x_return_status OUT NOCOPY VARCHAR2
500: ,x_msg_count OUT NOCOPY NUMBER
501: ,x_msg_data OUT NOCOPY VARCHAR2
494: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
495: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
496: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
497: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
498: ,px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl
499: ,x_return_status OUT NOCOPY VARCHAR2
500: ,x_msg_count OUT NOCOPY NUMBER
501: ,x_msg_data OUT NOCOPY VARCHAR2
502: )
512:
513: l_count NUMBER;
514:
515: l_txn_line_id NUMBER;
516: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
517: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
518:
519: BEGIN
520:
513: l_count NUMBER;
514:
515: l_txn_line_id NUMBER;
516: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
517: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
518:
519: BEGIN
520:
521: -- Standard Start of API savepoint
700: p_api_version IN NUMBER
701: ,p_commit IN VARCHAR2 := fnd_api.g_false
702: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
703: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
704: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
705: ,p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl
706: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
707: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
708: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
701: ,p_commit IN VARCHAR2 := fnd_api.g_false
702: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
703: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
704: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
705: ,p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl
706: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
707: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
708: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
709: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
702: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
703: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
704: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
705: ,p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl
706: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
707: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
708: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
709: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
710: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
703: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
704: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
705: ,p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl
706: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
707: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
708: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
709: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
710: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
711: ,x_return_status OUT NOCOPY VARCHAR2
704: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
705: ,p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl
706: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
707: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
708: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
709: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
710: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
711: ,x_return_status OUT NOCOPY VARCHAR2
712: ,x_msg_count OUT NOCOPY NUMBER
705: ,p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl
706: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
707: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
708: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
709: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
710: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
711: ,x_return_status OUT NOCOPY VARCHAR2
712: ,x_msg_count OUT NOCOPY NUMBER
713: ,x_msg_data OUT NOCOPY VARCHAR2
706: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
707: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
708: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
709: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
710: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
711: ,x_return_status OUT NOCOPY VARCHAR2
712: ,x_msg_count OUT NOCOPY NUMBER
713: ,x_msg_data OUT NOCOPY VARCHAR2
714: )
1057: p_api_version IN NUMBER,
1058: p_commit IN VARCHAR2 := fnd_api.g_false,
1059: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1060: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1061: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
1062: px_new_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1063: p_copy_parties_flag IN varchar2 := fnd_api.g_true,
1064: p_copy_pty_accts_flag IN varchar2 := fnd_api.g_true,
1065: p_copy_ii_rltns_flag IN varchar2 := fnd_api.g_true,
1058: p_commit IN VARCHAR2 := fnd_api.g_false,
1059: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1060: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1061: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
1062: px_new_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1063: p_copy_parties_flag IN varchar2 := fnd_api.g_true,
1064: p_copy_pty_accts_flag IN varchar2 := fnd_api.g_true,
1065: p_copy_ii_rltns_flag IN varchar2 := fnd_api.g_true,
1066: p_copy_org_assgn_flag IN varchar2 := fnd_api.g_true,
1220: p_api_version IN NUMBER
1221: ,p_commit IN VARCHAR2 := fnd_api.g_false
1222: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1223: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1224: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
1225: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
1226: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
1227: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
1228: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
1221: ,p_commit IN VARCHAR2 := fnd_api.g_false
1222: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1223: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1224: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
1225: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
1226: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
1227: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
1228: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
1229: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
1222: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1223: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1224: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
1225: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
1226: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
1227: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
1228: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
1229: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
1230: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
1223: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1224: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
1225: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
1226: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
1227: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
1228: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
1229: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
1230: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
1231: ,x_return_status OUT NOCOPY VARCHAR2
1224: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
1225: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
1226: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
1227: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
1228: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
1229: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
1230: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
1231: ,x_return_status OUT NOCOPY VARCHAR2
1232: ,x_msg_count OUT NOCOPY NUMBER
1225: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
1226: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
1227: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
1228: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
1229: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
1230: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
1231: ,x_return_status OUT NOCOPY VARCHAR2
1232: ,x_msg_count OUT NOCOPY NUMBER
1233: ,x_msg_data OUT NOCOPY VARCHAR2
1226: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
1227: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
1228: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
1229: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
1230: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
1231: ,x_return_status OUT NOCOPY VARCHAR2
1232: ,x_msg_count OUT NOCOPY NUMBER
1233: ,x_msg_data OUT NOCOPY VARCHAR2
1234: )
1386: p_api_version IN NUMBER,
1387: p_commit IN VARCHAR2 := fnd_api.g_false,
1388: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1389: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1390: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
1391: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1392: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1393: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1394: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1387: p_commit IN VARCHAR2 := fnd_api.g_false,
1388: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1389: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1390: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
1391: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1392: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1393: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1394: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1395: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1388: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1389: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1390: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
1391: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1392: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1393: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1394: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1395: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1396: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1389: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1390: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
1391: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1392: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1393: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1394: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1395: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1396: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1397: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
1390: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
1391: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1392: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1393: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1394: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1395: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1396: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1397: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
1398: x_return_status OUT NOCOPY VARCHAR2,
1391: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1392: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1393: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1394: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1395: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1396: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1397: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
1398: x_return_status OUT NOCOPY VARCHAR2,
1399: x_msg_count OUT NOCOPY NUMBER,
1392: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1393: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1394: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1395: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1396: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1397: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
1398: x_return_status OUT NOCOPY VARCHAR2,
1399: x_msg_count OUT NOCOPY NUMBER,
1400: x_msg_data OUT NOCOPY VARCHAR2) IS
1393: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1394: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1395: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1396: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1397: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
1398: x_return_status OUT NOCOPY VARCHAR2,
1399: x_msg_count OUT NOCOPY NUMBER,
1400: x_msg_data OUT NOCOPY VARCHAR2) IS
1401: