8: p_commit IN VARCHAR2 := fnd_api.g_false,
9: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
10: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
11: p_txn_line_dtl_index IN NUMBER,
12: p_txn_line_dtl_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
13: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
14: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
15: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
16: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
9: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
10: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
11: p_txn_line_dtl_index IN NUMBER,
12: p_txn_line_dtl_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
13: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
14: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
15: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
16: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
17: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
10: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
11: p_txn_line_dtl_index IN NUMBER,
12: p_txn_line_dtl_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
13: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
14: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
15: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
16: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
17: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
18: x_return_status OUT NOCOPY VARCHAR2,
11: p_txn_line_dtl_index IN NUMBER,
12: p_txn_line_dtl_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
13: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
14: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
15: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
16: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
17: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
18: x_return_status OUT NOCOPY VARCHAR2,
19: x_msg_count OUT NOCOPY NUMBER,
12: p_txn_line_dtl_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
13: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
14: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
15: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
16: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
17: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
18: x_return_status OUT NOCOPY VARCHAR2,
19: x_msg_count OUT NOCOPY NUMBER,
20: x_msg_data OUT NOCOPY VARCHAR2);
13: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
14: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
15: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
16: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
17: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
18: x_return_status OUT NOCOPY VARCHAR2,
19: x_msg_count OUT NOCOPY NUMBER,
20: x_msg_data OUT NOCOPY VARCHAR2);
21:
23: p_api_version IN NUMBER
24: ,p_commit IN VARCHAR2 := fnd_api.g_false
25: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
26: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
27: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
28: ,p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl
29: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
30: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
31: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
24: ,p_commit IN VARCHAR2 := fnd_api.g_false
25: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
26: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
27: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
28: ,p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl
29: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
30: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
31: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
32: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
25: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
26: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
27: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
28: ,p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl
29: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
30: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
31: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
32: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
33: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
26: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
27: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
28: ,p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl
29: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
30: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
31: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
32: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
33: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
34: ,x_return_status OUT NOCOPY VARCHAR2
27: ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
28: ,p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl
29: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
30: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
31: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
32: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
33: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
34: ,x_return_status OUT NOCOPY VARCHAR2
35: ,x_msg_count OUT NOCOPY NUMBER
28: ,p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl
29: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
30: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
31: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
32: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
33: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
34: ,x_return_status OUT NOCOPY VARCHAR2
35: ,x_msg_count OUT NOCOPY NUMBER
36: ,x_msg_data OUT NOCOPY VARCHAR2);
29: ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
30: ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
31: ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
32: ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
33: ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
34: ,x_return_status OUT NOCOPY VARCHAR2
35: ,x_msg_count OUT NOCOPY NUMBER
36: ,x_msg_data OUT NOCOPY VARCHAR2);
37:
35: ,x_msg_count OUT NOCOPY NUMBER
36: ,x_msg_data OUT NOCOPY VARCHAR2);
37:
38: PROCEDURE build_txn_lines_select(
39: p_txn_line_query_rec in csi_t_datastructures_grp.txn_line_query_rec,
40: x_lines_select_stmt OUT NOCOPY varchar2,
41: x_lines_restrict OUT NOCOPY varchar2,
42: x_return_status OUT NOCOPY varchar2);
43:
41: x_lines_restrict OUT NOCOPY varchar2,
42: x_return_status OUT NOCOPY varchar2);
43:
44: PROCEDURE get_txn_line_dtls(
45: p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec,
46: p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec,
47: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
48: x_return_status OUT NOCOPY varchar2);
49:
42: x_return_status OUT NOCOPY varchar2);
43:
44: PROCEDURE get_txn_line_dtls(
45: p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec,
46: p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec,
47: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
48: x_return_status OUT NOCOPY varchar2);
49:
50: PROCEDURE delete_txn_line_dtls(
43:
44: PROCEDURE get_txn_line_dtls(
45: p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec,
46: p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec,
47: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
48: x_return_status OUT NOCOPY varchar2);
49:
50: PROCEDURE delete_txn_line_dtls(
51: p_api_version IN NUMBER
51: p_api_version IN NUMBER
52: ,p_commit IN VARCHAR2 := fnd_api.g_false
53: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
54: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
55: ,p_txn_line_detail_ids_tbl IN csi_t_datastructures_grp.
56: txn_line_detail_ids_tbl
57: ,x_return_status OUT NOCOPY VARCHAR2
58: ,x_msg_count OUT NOCOPY NUMBER
59: ,x_msg_data OUT NOCOPY VARCHAR2);
58: ,x_msg_count OUT NOCOPY NUMBER
59: ,x_msg_data OUT NOCOPY VARCHAR2);
60:
61: PROCEDURE update_txn_line(
62: p_txn_line_rec in csi_t_datastructures_grp.txn_line_rec,
63: x_return_status OUT NOCOPY varchar2);
64:
65: END csi_t_txn_line_dtls_pvt;