DBA Data[Home] [Help]

APPS.CSI_T_TXN_PARTIES_PVT dependencies on CSI_T_DATASTRUCTURES_GRP

Line 32: p_txn_party_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_rec,

28: p_commit IN varchar2 := fnd_api.g_false,
29: p_init_msg_list IN varchar2 := fnd_api.g_false,
30: p_validation_level IN number := fnd_api.g_valid_level_full,
31: p_txn_party_dtl_index IN number,
32: p_txn_party_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_rec,
33: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
34: x_return_status OUT NOCOPY varchar2,
35: x_msg_count OUT NOCOPY number,
36: x_msg_data OUT NOCOPY varchar2)

Line 33: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

29: p_init_msg_list IN varchar2 := fnd_api.g_false,
30: p_validation_level IN number := fnd_api.g_valid_level_full,
31: p_txn_party_dtl_index IN number,
32: p_txn_party_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_rec,
33: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
34: x_return_status OUT NOCOPY varchar2,
35: x_msg_count OUT NOCOPY number,
36: x_msg_data OUT NOCOPY varchar2)
37: IS

Line 44: l_pty_acct_rec csi_t_datastructures_grp.txn_pty_acct_detail_rec;

40: l_api_version CONSTANT number := 1.0;
41: l_debug_level number;
42: l_index number;
43: l_txn_party_detail_id number;
44: l_pty_acct_rec csi_t_datastructures_grp.txn_pty_acct_detail_rec;
45: l_preserve_detail_flag varchar2(1);
46:
47: l_contact_flag varchar2(1) := 'P';
48:

Line 427: p_txn_pty_acct_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_rec,

423: p_api_version IN number,
424: p_commit IN varchar2 := fnd_api.g_false,
425: p_init_msg_list IN varchar2 := fnd_api.g_false,
426: p_validation_level IN number := fnd_api.g_valid_level_full,
427: p_txn_pty_acct_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_rec,
428: x_return_status OUT NOCOPY varchar2,
429: x_msg_count OUT NOCOPY number,
430: x_msg_data OUT NOCOPY varchar2)
431:

Line 724: p_txn_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,

720: p_api_version IN NUMBER,
721: p_commit IN VARCHAR2 := fnd_api.g_false,
722: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
723: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
724: p_txn_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
725: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
726: x_return_status OUT NOCOPY VARCHAR2,
727: x_msg_count OUT NOCOPY NUMBER,
728: x_msg_data OUT NOCOPY VARCHAR2)

Line 725: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

721: p_commit IN VARCHAR2 := fnd_api.g_false,
722: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
723: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
724: p_txn_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
725: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
726: x_return_status OUT NOCOPY VARCHAR2,
727: x_msg_count OUT NOCOPY NUMBER,
728: x_msg_data OUT NOCOPY VARCHAR2)
729: IS

Line 736: l_pty_acct_rec csi_t_datastructures_grp.txn_pty_acct_detail_rec;

732: l_api_version CONSTANT NUMBER := 1.0;
733: l_debug_level NUMBER;
734:
735: l_pty_rec csi_t_party_details%ROWTYPE;
736: l_pty_acct_rec csi_t_datastructures_grp.txn_pty_acct_detail_rec;
737: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
738: l_msg_count number;
739: l_msg_data varchar2(512);
740: l_processing_status csi_t_transaction_lines.processing_status%TYPE;

Line 741: l_del_pa_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;

737: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
738: l_msg_count number;
739: l_msg_data varchar2(512);
740: l_processing_status csi_t_transaction_lines.processing_status%TYPE;
741: l_del_pa_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
742: l_del_pa_ind binary_integer;
743: l_instance_exists_flag csi_t_txn_line_details.instance_exists_flag%TYPE;
744: l_instance_id csi_t_txn_line_details.instance_id%TYPE;
745: l_contact_flag varchar2(1) := 'P';

Line 746: l_u_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

742: l_del_pa_ind binary_integer;
743: l_instance_exists_flag csi_t_txn_line_details.instance_exists_flag%TYPE;
744: l_instance_id csi_t_txn_line_details.instance_id%TYPE;
745: l_contact_flag varchar2(1) := 'P';
746: l_u_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
747: l_u_acct_ind binary_integer;
748:
749: CURSOR pty_cur(p_pty_dtl_id IN number) IS
750: SELECT *

Line 1461: ,p_txn_pty_acct_detail_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl

1457: p_api_version IN NUMBER
1458: ,p_commit IN VARCHAR2 := fnd_api.g_false
1459: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1460: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1461: ,p_txn_pty_acct_detail_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl
1462: ,x_return_status OUT NOCOPY VARCHAR2
1463: ,x_msg_count OUT NOCOPY NUMBER
1464: ,x_msg_data OUT NOCOPY VARCHAR2)
1465: IS

Line 1763: ,p_txn_party_ids_tbl IN csi_t_datastructures_grp.txn_party_ids_tbl

1759: p_api_version IN NUMBER
1760: ,p_commit IN VARCHAR2 := fnd_api.g_false
1761: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1762: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1763: ,p_txn_party_ids_tbl IN csi_t_datastructures_grp.txn_party_ids_tbl
1764: ,x_txn_pty_acct_ids_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_ids_tbl
1765: ,x_return_status OUT NOCOPY VARCHAR2
1766: ,x_msg_count OUT NOCOPY NUMBER
1767: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 1764: ,x_txn_pty_acct_ids_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_ids_tbl

1760: ,p_commit IN VARCHAR2 := fnd_api.g_false
1761: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1762: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1763: ,p_txn_party_ids_tbl IN csi_t_datastructures_grp.txn_party_ids_tbl
1764: ,x_txn_pty_acct_ids_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_ids_tbl
1765: ,x_return_status OUT NOCOPY VARCHAR2
1766: ,x_msg_count OUT NOCOPY NUMBER
1767: ,x_msg_data OUT NOCOPY VARCHAR2)
1768: IS

Line 2041: ,p_txn_pty_acct_ids_tbl IN csi_t_datastructures_grp.txn_pty_acct_ids_tbl

2037: p_api_version IN NUMBER
2038: ,p_commit IN VARCHAR2 := fnd_api.g_false
2039: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2040: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
2041: ,p_txn_pty_acct_ids_tbl IN csi_t_datastructures_grp.txn_pty_acct_ids_tbl
2042: ,x_return_status OUT NOCOPY VARCHAR2
2043: ,x_msg_count OUT NOCOPY NUMBER
2044: ,x_msg_data OUT NOCOPY VARCHAR2)
2045: IS

Line 2212: x_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

2208: END delete_txn_pty_acct_dtls;
2209:
2210: PROCEDURE get_pty_acct_dtls(
2211: p_party_dtl_id in number,
2212: x_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
2213: x_return_status OUT NOCOPY varchar2)
2214: IS
2215:
2216: l_select_stmt varchar2(2000);

Line 2218: l_pty_acct_rec csi_t_datastructures_grp.txn_pty_acct_detail_rec;

2214: IS
2215:
2216: l_select_stmt varchar2(2000);
2217: l_pty_acct_cur_id integer;
2218: l_pty_acct_rec csi_t_datastructures_grp.txn_pty_acct_detail_rec;
2219: l_processed_rows number := 0;
2220: l_ind binary_integer;
2221:
2222: BEGIN

Line 2376: x_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

2372: END get_pty_acct_dtls;
2373:
2374: PROCEDURE get_party_dtls(
2375: p_line_dtl_id in number,
2376: x_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
2377: x_return_status OUT NOCOPY varchar2)
2378: IS
2379:
2380: l_select_stmt varchar2(2000);

Line 2382: l_pty_rec csi_t_datastructures_grp.txn_party_detail_rec;

2378: IS
2379:
2380: l_select_stmt varchar2(2000);
2381: l_pty_cur_id integer;
2382: l_pty_rec csi_t_datastructures_grp.txn_party_detail_rec;
2383: l_processed_rows number := 0;
2384: l_ind binary_integer;
2385:
2386: BEGIN

Line 2502: p_line_detail_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,

2498: END IF;
2499: END get_party_dtls;
2500:
2501: PROCEDURE get_all_party_dtls(
2502: p_line_detail_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,
2503: x_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
2504: x_return_status OUT NOCOPY varchar2)
2505: IS
2506: l_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 2503: x_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

2499: END get_party_dtls;
2500:
2501: PROCEDURE get_all_party_dtls(
2502: p_line_detail_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,
2503: x_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
2504: x_return_status OUT NOCOPY varchar2)
2505: IS
2506: l_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2507: l_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 2506: l_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

2502: p_line_detail_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,
2503: x_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
2504: x_return_status OUT NOCOPY varchar2)
2505: IS
2506: l_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2507: l_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2508: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2509: l_p_ind binary_integer := 0;
2510: BEGIN

Line 2507: l_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

2503: x_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
2504: x_return_status OUT NOCOPY varchar2)
2505: IS
2506: l_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2507: l_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2508: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2509: l_p_ind binary_integer := 0;
2510: BEGIN
2511: x_return_status := fnd_api.g_ret_sts_success;

Line 2540: p_party_detail_tbl in csi_t_datastructures_grp.txn_party_detail_tbl,

2536: x_return_status := fnd_api.g_ret_sts_error;
2537: END get_all_party_dtls;
2538:
2539: PROCEDURE get_all_pty_acct_dtls(
2540: p_party_detail_tbl in csi_t_datastructures_grp.txn_party_detail_tbl,
2541: x_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
2542: x_return_status OUT NOCOPY varchar2)
2543: IS
2544: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 2541: x_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

2537: END get_all_party_dtls;
2538:
2539: PROCEDURE get_all_pty_acct_dtls(
2540: p_party_detail_tbl in csi_t_datastructures_grp.txn_party_detail_tbl,
2541: x_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
2542: x_return_status OUT NOCOPY varchar2)
2543: IS
2544: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2545: l_tmp_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 2544: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

2540: p_party_detail_tbl in csi_t_datastructures_grp.txn_party_detail_tbl,
2541: x_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
2542: x_return_status OUT NOCOPY varchar2)
2543: IS
2544: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2545: l_tmp_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2546: l_pa_ind binary_integer := 0;
2547: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2548:

Line 2545: l_tmp_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

2541: x_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
2542: x_return_status OUT NOCOPY varchar2)
2543: IS
2544: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2545: l_tmp_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2546: l_pa_ind binary_integer := 0;
2547: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2548:
2549: BEGIN