9: Returns a 'Y' or 'N'
10: */
11:
12: FUNCTION check_txn_details_exist(
13: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec)
14: RETURN Boolean ;
15:
16: /*
17: For a given transaction line record,this API gets all the transaction
25: p_api_version IN NUMBER,
26: p_commit IN VARCHAR2 := fnd_api.g_false,
27: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
28: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
29: p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec ,
30: p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec ,
31: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl ,
32: p_get_parties_flag IN VARCHAR2 := fnd_api.g_false,
33: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
26: p_commit IN VARCHAR2 := fnd_api.g_false,
27: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
28: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
29: p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec ,
30: p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec ,
31: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl ,
32: p_get_parties_flag IN VARCHAR2 := fnd_api.g_false,
33: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
34: p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false,
27: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
28: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
29: p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec ,
30: p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec ,
31: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl ,
32: p_get_parties_flag IN VARCHAR2 := fnd_api.g_false,
33: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
34: p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false,
35: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
29: p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec ,
30: p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec ,
31: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl ,
32: p_get_parties_flag IN VARCHAR2 := fnd_api.g_false,
33: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
34: p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false,
35: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
36: p_get_ii_rltns_flag IN VARCHAR2 := fnd_api.g_false,
37: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
31: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl ,
32: p_get_parties_flag IN VARCHAR2 := fnd_api.g_false,
33: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
34: p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false,
35: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
36: p_get_ii_rltns_flag IN VARCHAR2 := fnd_api.g_false,
37: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
38: p_get_org_assgns_flag IN VARCHAR2 := fnd_api.g_false,
39: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
33: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
34: p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false,
35: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
36: p_get_ii_rltns_flag IN VARCHAR2 := fnd_api.g_false,
37: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
38: p_get_org_assgns_flag IN VARCHAR2 := fnd_api.g_false,
39: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
40: p_get_ext_attrib_vals_flag IN VARCHAR2 := fnd_api.g_false,
41: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
35: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
36: p_get_ii_rltns_flag IN VARCHAR2 := fnd_api.g_false,
37: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
38: p_get_org_assgns_flag IN VARCHAR2 := fnd_api.g_false,
39: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
40: p_get_ext_attrib_vals_flag IN VARCHAR2 := fnd_api.g_false,
41: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
42: p_get_csi_attribs_flag IN VARCHAR2 := fnd_api.g_false,
43: x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl,
37: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
38: p_get_org_assgns_flag IN VARCHAR2 := fnd_api.g_false,
39: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
40: p_get_ext_attrib_vals_flag IN VARCHAR2 := fnd_api.g_false,
41: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
42: p_get_csi_attribs_flag IN VARCHAR2 := fnd_api.g_false,
43: x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl,
44: p_get_csi_iea_values_flag IN VARCHAR2 := fnd_api.g_false,
45: x_csi_iea_values_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl,
39: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
40: p_get_ext_attrib_vals_flag IN VARCHAR2 := fnd_api.g_false,
41: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
42: p_get_csi_attribs_flag IN VARCHAR2 := fnd_api.g_false,
43: x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl,
44: p_get_csi_iea_values_flag IN VARCHAR2 := fnd_api.g_false,
45: x_csi_iea_values_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl,
46: p_get_txn_systems_flag IN VARCHAR2 := fnd_api.g_false,
47: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
41: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
42: p_get_csi_attribs_flag IN VARCHAR2 := fnd_api.g_false,
43: x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl,
44: p_get_csi_iea_values_flag IN VARCHAR2 := fnd_api.g_false,
45: x_csi_iea_values_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl,
46: p_get_txn_systems_flag IN VARCHAR2 := fnd_api.g_false,
47: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
48: x_return_status OUT NOCOPY VARCHAR2,
49: x_msg_count OUT NOCOPY NUMBER ,
43: x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl,
44: p_get_csi_iea_values_flag IN VARCHAR2 := fnd_api.g_false,
45: x_csi_iea_values_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl,
46: p_get_txn_systems_flag IN VARCHAR2 := fnd_api.g_false,
47: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
48: x_return_status OUT NOCOPY VARCHAR2,
49: x_msg_count OUT NOCOPY NUMBER ,
50: x_msg_data OUT NOCOPY VARCHAR2);
51:
58: p_api_version IN NUMBER,
59: p_commit IN VARCHAR2 := fnd_api.g_false,
60: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
61: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
62: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
63: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
64: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl ,
65: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
66: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
59: p_commit IN VARCHAR2 := fnd_api.g_false,
60: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
61: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
62: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
63: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
64: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl ,
65: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
66: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
67: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
60: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
61: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
62: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
63: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
64: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl ,
65: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
66: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
67: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
68: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
61: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
62: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
63: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
64: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl ,
65: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
66: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
67: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
68: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
69: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
62: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
63: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
64: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl ,
65: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
66: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
67: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
68: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
69: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
70: x_return_status OUT NOCOPY VARCHAR2,
63: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
64: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl ,
65: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
66: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
67: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
68: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
69: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
70: x_return_status OUT NOCOPY VARCHAR2,
71: x_msg_count OUT NOCOPY NUMBER,
64: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl ,
65: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
66: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
67: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
68: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
69: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
70: x_return_status OUT NOCOPY VARCHAR2,
71: x_msg_count OUT NOCOPY NUMBER,
72: x_msg_data OUT NOCOPY VARCHAR2);
65: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
66: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
67: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
68: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
69: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
70: x_return_status OUT NOCOPY VARCHAR2,
71: x_msg_count OUT NOCOPY NUMBER,
72: x_msg_data OUT NOCOPY VARCHAR2);
73:
83: p_api_version IN NUMBER
84: ,p_commit IN VARCHAR2 := fnd_api.g_false
85: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
86: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
87: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
88: ,p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl
89: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
90: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
91: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
84: ,p_commit IN VARCHAR2 := fnd_api.g_false
85: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
86: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
87: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
88: ,p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl
89: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
90: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
91: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
92: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
85: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
86: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
87: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
88: ,p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl
89: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
90: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
91: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
92: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
93: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
86: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
87: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
88: ,p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl
89: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
90: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
91: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
92: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
93: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
94: ,x_return_status OUT NOCOPY VARCHAR2
87: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
88: ,p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl
89: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
90: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
91: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
92: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
93: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
94: ,x_return_status OUT NOCOPY VARCHAR2
95: ,x_msg_count OUT NOCOPY NUMBER
88: ,p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl
89: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
90: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
91: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
92: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
93: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
94: ,x_return_status OUT NOCOPY VARCHAR2
95: ,x_msg_count OUT NOCOPY NUMBER
96: ,x_msg_data OUT NOCOPY VARCHAR2
89: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
90: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
91: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
92: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
93: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
94: ,x_return_status OUT NOCOPY VARCHAR2
95: ,x_msg_count OUT NOCOPY NUMBER
96: ,x_msg_data OUT NOCOPY VARCHAR2
97: );
118: p_api_version IN NUMBER,
119: p_commit IN VARCHAR2 := fnd_api.g_false,
120: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
121: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
122: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
123: px_new_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
124: p_copy_parties_flag IN varchar2 := fnd_api.g_true,
125: p_copy_pty_accts_flag IN varchar2 := fnd_api.g_true,
126: p_copy_ii_rltns_flag IN varchar2 := fnd_api.g_true,
119: p_commit IN VARCHAR2 := fnd_api.g_false,
120: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
121: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
122: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
123: px_new_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
124: p_copy_parties_flag IN varchar2 := fnd_api.g_true,
125: p_copy_pty_accts_flag IN varchar2 := fnd_api.g_true,
126: p_copy_ii_rltns_flag IN varchar2 := fnd_api.g_true,
127: p_copy_org_assgn_flag IN varchar2 := fnd_api.g_true,
147: p_api_version IN NUMBER
148: ,p_commit IN VARCHAR2 := fnd_api.g_false
149: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
150: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
151: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
152: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
153: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
154: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
155: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
148: ,p_commit IN VARCHAR2 := fnd_api.g_false
149: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
150: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
151: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
152: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
153: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
154: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
155: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
156: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
149: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
150: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
151: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
152: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
153: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
154: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
155: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
156: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
157: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
150: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
151: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
152: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
153: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
154: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
155: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
156: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
157: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
158: ,x_return_status OUT NOCOPY VARCHAR2
151: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
152: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
153: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
154: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
155: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
156: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
157: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
158: ,x_return_status OUT NOCOPY VARCHAR2
159: ,x_msg_count OUT NOCOPY NUMBER
152: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
153: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
154: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
155: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
156: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
157: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
158: ,x_return_status OUT NOCOPY VARCHAR2
159: ,x_msg_count OUT NOCOPY NUMBER
160: ,x_msg_data OUT NOCOPY VARCHAR2
153: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
154: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
155: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
156: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
157: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
158: ,x_return_status OUT NOCOPY VARCHAR2
159: ,x_msg_count OUT NOCOPY NUMBER
160: ,x_msg_data OUT NOCOPY VARCHAR2
161: );
164: p_api_version IN NUMBER,
165: p_commit IN VARCHAR2 := fnd_api.g_false,
166: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
167: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
168: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
169: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
170: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
171: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
172: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
165: p_commit IN VARCHAR2 := fnd_api.g_false,
166: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
167: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
168: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
169: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
170: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
171: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
172: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
173: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
166: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
167: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
168: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
169: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
170: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
171: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
172: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
173: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
174: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
167: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
168: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
169: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
170: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
171: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
172: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
173: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
174: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
175: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
168: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
169: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
170: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
171: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
172: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
173: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
174: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
175: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
176: x_return_status OUT NOCOPY VARCHAR2,
169: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
170: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
171: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
172: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
173: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
174: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
175: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,
170: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
171: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
172: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
173: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
174: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
175: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,
178: x_msg_data OUT NOCOPY VARCHAR2);
171: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
172: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
173: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
174: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
175: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,
178: x_msg_data OUT NOCOPY VARCHAR2);
179: