2: /* $Header: csivttxs.pls 120.2 2005/09/27 23:13:09 sumathur noship $ */
3:
4:
5: FUNCTION check_txn_details_exist(
6: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec)
7: RETURN BOOLEAN;
8:
9:
10: PROCEDURE create_transaction_dtls(
12: p_commit IN VARCHAR2 := fnd_api.g_false,
13: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
14: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
15: p_split_source_flag IN VARCHAR2 := fnd_api.g_false,
16: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
17: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
18: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl ,
19: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
20: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
13: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
14: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
15: p_split_source_flag IN VARCHAR2 := fnd_api.g_false,
16: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
17: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
18: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl ,
19: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
20: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
21: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
14: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
15: p_split_source_flag IN VARCHAR2 := fnd_api.g_false,
16: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
17: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
18: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl ,
19: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
20: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
21: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
22: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
15: p_split_source_flag IN VARCHAR2 := fnd_api.g_false,
16: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
17: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
18: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl ,
19: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
20: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
21: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
22: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
23: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
16: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
17: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
18: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl ,
19: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
20: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
21: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
22: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
23: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
24: x_return_status OUT NOCOPY VARCHAR2,
17: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
18: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl ,
19: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
20: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
21: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
22: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
23: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
24: x_return_status OUT NOCOPY VARCHAR2,
25: x_msg_count OUT NOCOPY NUMBER ,
18: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl ,
19: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
20: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
21: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
22: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
23: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
24: x_return_status OUT NOCOPY VARCHAR2,
25: x_msg_count OUT NOCOPY NUMBER ,
26: x_msg_data OUT NOCOPY VARCHAR2);
19: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
20: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
21: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
22: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
23: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
24: x_return_status OUT NOCOPY VARCHAR2,
25: x_msg_count OUT NOCOPY NUMBER ,
26: x_msg_data OUT NOCOPY VARCHAR2);
27:
29: p_api_version IN NUMBER
30: ,p_commit IN VARCHAR2 := fnd_api.g_false
31: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
32: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
33: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
34: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
35: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
36: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
37: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
30: ,p_commit IN VARCHAR2 := fnd_api.g_false
31: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
32: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
33: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
34: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
35: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
36: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
37: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
38: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
31: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
32: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
33: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
34: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
35: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
36: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
37: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
38: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
39: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
32: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
33: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
34: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
35: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
36: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
37: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
38: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
39: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
40: ,x_return_status OUT NOCOPY VARCHAR2
33: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
34: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
35: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
36: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
37: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
38: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
39: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
40: ,x_return_status OUT NOCOPY VARCHAR2
41: ,x_msg_count OUT NOCOPY NUMBER
34: ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
35: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
36: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
37: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
38: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
39: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
40: ,x_return_status OUT NOCOPY VARCHAR2
41: ,x_msg_count OUT NOCOPY NUMBER
42: ,x_msg_data OUT NOCOPY VARCHAR2);
35: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
36: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
37: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
38: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
39: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
40: ,x_return_status OUT NOCOPY VARCHAR2
41: ,x_msg_count OUT NOCOPY NUMBER
42: ,x_msg_data OUT NOCOPY VARCHAR2);
43:
60: p_api_version IN NUMBER
61: ,p_commit IN VARCHAR2 := fnd_api.g_false
62: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
63: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
64: ,p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec
65: ,p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec
66: ,x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
67: ,p_get_parties_flag IN VARCHAR2 := fnd_api.g_false
68: ,x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
61: ,p_commit IN VARCHAR2 := fnd_api.g_false
62: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
63: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
64: ,p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec
65: ,p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec
66: ,x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
67: ,p_get_parties_flag IN VARCHAR2 := fnd_api.g_false
68: ,x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
69: ,p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false
62: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
63: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
64: ,p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec
65: ,p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec
66: ,x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
67: ,p_get_parties_flag IN VARCHAR2 := fnd_api.g_false
68: ,x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
69: ,p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false
70: ,x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
64: ,p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec
65: ,p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec
66: ,x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
67: ,p_get_parties_flag IN VARCHAR2 := fnd_api.g_false
68: ,x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
69: ,p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false
70: ,x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
71: ,p_get_ii_rltns_flag IN VARCHAR2 := fnd_api.g_false
72: ,x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
66: ,x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
67: ,p_get_parties_flag IN VARCHAR2 := fnd_api.g_false
68: ,x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
69: ,p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false
70: ,x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
71: ,p_get_ii_rltns_flag IN VARCHAR2 := fnd_api.g_false
72: ,x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
73: ,p_get_org_assgns_flag IN VARCHAR2 := fnd_api.g_false
74: ,x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
68: ,x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
69: ,p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false
70: ,x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
71: ,p_get_ii_rltns_flag IN VARCHAR2 := fnd_api.g_false
72: ,x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
73: ,p_get_org_assgns_flag IN VARCHAR2 := fnd_api.g_false
74: ,x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
75: ,p_get_ext_attrib_vals_flag IN VARCHAR2 := fnd_api.g_false
76: ,x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.
70: ,x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
71: ,p_get_ii_rltns_flag IN VARCHAR2 := fnd_api.g_false
72: ,x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
73: ,p_get_org_assgns_flag IN VARCHAR2 := fnd_api.g_false
74: ,x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
75: ,p_get_ext_attrib_vals_flag IN VARCHAR2 := fnd_api.g_false
76: ,x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.
77: txn_ext_attrib_vals_tbl
78: ,p_get_csi_attribs_flag IN VARCHAR2 := fnd_api.g_false
72: ,x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
73: ,p_get_org_assgns_flag IN VARCHAR2 := fnd_api.g_false
74: ,x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
75: ,p_get_ext_attrib_vals_flag IN VARCHAR2 := fnd_api.g_false
76: ,x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.
77: txn_ext_attrib_vals_tbl
78: ,p_get_csi_attribs_flag IN VARCHAR2 := fnd_api.g_false
79: ,x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl
80: ,p_get_csi_iea_values_flag IN VARCHAR2 := fnd_api.g_false
75: ,p_get_ext_attrib_vals_flag IN VARCHAR2 := fnd_api.g_false
76: ,x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.
77: txn_ext_attrib_vals_tbl
78: ,p_get_csi_attribs_flag IN VARCHAR2 := fnd_api.g_false
79: ,x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl
80: ,p_get_csi_iea_values_flag IN VARCHAR2 := fnd_api.g_false
81: ,x_csi_iea_values_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl
82: ,p_get_txn_systems_flag IN VARCHAR2 := fnd_api.g_false
83: ,x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl
77: txn_ext_attrib_vals_tbl
78: ,p_get_csi_attribs_flag IN VARCHAR2 := fnd_api.g_false
79: ,x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl
80: ,p_get_csi_iea_values_flag IN VARCHAR2 := fnd_api.g_false
81: ,x_csi_iea_values_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl
82: ,p_get_txn_systems_flag IN VARCHAR2 := fnd_api.g_false
83: ,x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl
84: ,x_return_status OUT NOCOPY VARCHAR2
85: ,x_msg_count OUT NOCOPY NUMBER
79: ,x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl
80: ,p_get_csi_iea_values_flag IN VARCHAR2 := fnd_api.g_false
81: ,x_csi_iea_values_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl
82: ,p_get_txn_systems_flag IN VARCHAR2 := fnd_api.g_false
83: ,x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl
84: ,x_return_status OUT NOCOPY VARCHAR2
85: ,x_msg_count OUT NOCOPY NUMBER
86: ,x_msg_data OUT NOCOPY VARCHAR2);
87:
89: p_api_version IN NUMBER,
90: p_commit IN VARCHAR2 := fnd_api.g_false,
91: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
92: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
93: p_upd_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
94: p_upd_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
95: px_crt_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
96: px_crt_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
97: x_return_status OUT NOCOPY VARCHAR2,
90: p_commit IN VARCHAR2 := fnd_api.g_false,
91: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
92: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
93: p_upd_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
94: p_upd_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
95: px_crt_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
96: px_crt_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
91: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
92: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
93: p_upd_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
94: p_upd_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
95: px_crt_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
96: px_crt_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
99: x_msg_data OUT NOCOPY VARCHAR2);
92: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
93: p_upd_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
94: p_upd_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
95: px_crt_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
96: px_crt_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
99: x_msg_data OUT NOCOPY VARCHAR2);
100:
102: p_api_version IN NUMBER,
103: p_commit IN VARCHAR2 := fnd_api.g_false,
104: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
105: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
106: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
107: px_new_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
108: p_copy_parties_flag IN varchar2 := fnd_api.g_true,
109: p_copy_pty_accts_flag IN varchar2 := fnd_api.g_true,
110: p_copy_ii_rltns_flag IN varchar2 := fnd_api.g_true,
103: p_commit IN VARCHAR2 := fnd_api.g_false,
104: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
105: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
106: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
107: px_new_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
108: p_copy_parties_flag IN varchar2 := fnd_api.g_true,
109: p_copy_pty_accts_flag IN varchar2 := fnd_api.g_true,
110: p_copy_ii_rltns_flag IN varchar2 := fnd_api.g_true,
111: p_copy_org_assgn_flag IN varchar2 := fnd_api.g_true,
119: p_api_version IN NUMBER,
120: p_commit IN VARCHAR2 := fnd_api.g_false,
121: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
122: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
123: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
124: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
125: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
126: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
127: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
120: p_commit IN VARCHAR2 := fnd_api.g_false,
121: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
122: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
123: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
124: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
125: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
126: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
127: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
128: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
121: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
122: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
123: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
124: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
125: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
126: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
127: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
128: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
129: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
122: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
123: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
124: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
125: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
126: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
127: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
128: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
129: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
130: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
123: p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
124: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
125: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
126: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
127: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
128: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
129: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
130: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
131: x_return_status OUT NOCOPY VARCHAR2,
124: px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
125: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
126: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
127: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
128: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
129: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
130: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
131: x_return_status OUT NOCOPY VARCHAR2,
132: x_msg_count OUT NOCOPY NUMBER,
125: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
126: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
127: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
128: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
129: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
130: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
131: x_return_status OUT NOCOPY VARCHAR2,
132: x_msg_count OUT NOCOPY NUMBER,
133: x_msg_data OUT NOCOPY VARCHAR2 ) ;
126: x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
127: x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
128: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
129: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
130: x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
131: x_return_status OUT NOCOPY VARCHAR2,
132: x_msg_count OUT NOCOPY NUMBER,
133: x_msg_data OUT NOCOPY VARCHAR2 ) ;
134: