eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_PARTY_RELATIONSHIPS_PUB dependencies on CSI_DATASTRUCTURES_PUB

Line 17: ,p_party_query_rec IN csi_datastructures_pub.party_query_rec

13: ( p_api_version IN NUMBER
14: ,p_commit IN VARCHAR2
15: ,p_init_msg_list IN VARCHAR2
16: ,p_validation_level IN NUMBER
17: ,p_party_query_rec IN csi_datastructures_pub.party_query_rec
18: ,p_resolve_id_columns IN VARCHAR2
19: ,p_time_stamp IN DATE
20: ,x_party_header_tbl OUT NOCOPY csi_datastructures_pub.party_header_tbl
21: ,x_return_status OUT NOCOPY VARCHAR2

Line 20: ,x_party_header_tbl OUT NOCOPY csi_datastructures_pub.party_header_tbl

16: ,p_validation_level IN NUMBER
17: ,p_party_query_rec IN csi_datastructures_pub.party_query_rec
18: ,p_resolve_id_columns IN VARCHAR2
19: ,p_time_stamp IN DATE
20: ,x_party_header_tbl OUT NOCOPY csi_datastructures_pub.party_header_tbl
21: ,x_return_status OUT NOCOPY VARCHAR2
22: ,x_msg_count OUT NOCOPY NUMBER
23: ,x_msg_data OUT NOCOPY VARCHAR2
24: ) IS

Line 33: l_contact_details csi_datastructures_pub.contact_details_rec ;

29: l_instance_party_id NUMBER ;
30: l_contact_party_id NUMBER ;
31: l_contact_flag VARCHAR2(1);
32: l_party_source_tbl VARCHAR2(30) ;
33: l_contact_details csi_datastructures_pub.contact_details_rec ;
34: l_count NUMBER := 0 ;
35: l_where_clause VARCHAR2(2000) := '' ;
36: l_get_party_cursor_id NUMBER ;
37: l_party_rec csi_datastructures_pub.party_header_rec ;

Line 37: l_party_rec csi_datastructures_pub.party_header_rec ;

33: l_contact_details csi_datastructures_pub.contact_details_rec ;
34: l_count NUMBER := 0 ;
35: l_where_clause VARCHAR2(2000) := '' ;
36: l_get_party_cursor_id NUMBER ;
37: l_party_rec csi_datastructures_pub.party_header_rec ;
38: l_flag VARCHAR2(1) :='N' ;
39: l_rows_processed NUMBER ;
40: l_pty_lookup_type VARCHAR2(30) := 'CSI_PARTY_SOURCE_TABLE' ;
41: l_select_stmt VARCHAR2(20000) := ' SELECT instance_party_id, instance_id, party_source_table, '||

Line 368: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl

364: ( p_api_version IN NUMBER
365: ,p_commit IN VARCHAR2
366: ,p_init_msg_list IN VARCHAR2
367: ,p_validation_level IN NUMBER
368: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
369: ,p_party_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
370: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
371: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
372: ,x_return_status OUT NOCOPY VARCHAR2

Line 369: ,p_party_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl

365: ,p_commit IN VARCHAR2
366: ,p_init_msg_list IN VARCHAR2
367: ,p_validation_level IN NUMBER
368: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
369: ,p_party_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
370: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
371: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
372: ,x_return_status OUT NOCOPY VARCHAR2
373: ,x_msg_count OUT NOCOPY NUMBER

Line 370: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

366: ,p_init_msg_list IN VARCHAR2
367: ,p_validation_level IN NUMBER
368: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
369: ,p_party_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
370: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
371: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
372: ,x_return_status OUT NOCOPY VARCHAR2
373: ,x_msg_count OUT NOCOPY NUMBER
374: ,x_msg_data OUT NOCOPY VARCHAR2

Line 379: l_party_rec csi_datastructures_pub.party_rec;

375: ) IS
376: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_INST_PARTY_RELATIONSHIP';
377: l_api_version CONSTANT NUMBER := 1.0;
378: l_csi_debug_level NUMBER;
379: l_party_rec csi_datastructures_pub.party_rec;
380: l_party_has_correct_acct BOOLEAN := FALSE;
381: l_internal_party_id NUMBER;
382: l_msg_index NUMBER;
383: l_msg_count NUMBER;

Line 451: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

447:
448: -- Start API body
449: --
450: -- Grab the internal party id from csi_installed paramters
451: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
452: csi_gen_utility_pvt.populate_install_param_rec;
453: END IF;
454: --
455: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

Line 455: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

451: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
452: csi_gen_utility_pvt.populate_install_param_rec;
453: END IF;
454: --
455: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
456: --
457: IF l_internal_party_id IS NULL THEN
458: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
459: FND_MSG_PUB.ADD;

Line 713: ,p_party_tbl IN csi_datastructures_pub.party_tbl

709: ( p_api_version IN NUMBER
710: ,p_commit IN VARCHAR2
711: ,p_init_msg_list IN VARCHAR2
712: ,p_validation_level IN NUMBER
713: ,p_party_tbl IN csi_datastructures_pub.party_tbl
714: ,p_party_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
715: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
716: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
717: ,x_return_status OUT NOCOPY VARCHAR2

Line 714: ,p_party_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl

710: ,p_commit IN VARCHAR2
711: ,p_init_msg_list IN VARCHAR2
712: ,p_validation_level IN NUMBER
713: ,p_party_tbl IN csi_datastructures_pub.party_tbl
714: ,p_party_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
715: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
716: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
717: ,x_return_status OUT NOCOPY VARCHAR2
718: ,x_msg_count OUT NOCOPY NUMBER

Line 715: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

711: ,p_init_msg_list IN VARCHAR2
712: ,p_validation_level IN NUMBER
713: ,p_party_tbl IN csi_datastructures_pub.party_tbl
714: ,p_party_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
715: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
716: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
717: ,x_return_status OUT NOCOPY VARCHAR2
718: ,x_msg_count OUT NOCOPY NUMBER
719: ,x_msg_data OUT NOCOPY VARCHAR2

Line 724: l_party_rec csi_datastructures_pub.party_rec;

720: ) IS
721: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_INST_PARTY_RELATIONSHIP';
722: l_api_version CONSTANT NUMBER := 1.0;
723: l_csi_debug_level NUMBER;
724: l_party_rec csi_datastructures_pub.party_rec;
725: l_temp_party_rec csi_datastructures_pub.party_rec;
726: l_curr_party_rec csi_datastructures_pub.party_rec;
727: l_exp_party_rec csi_datastructures_pub.party_rec;
728: l_party_tbl csi_datastructures_pub.party_tbl;

Line 725: l_temp_party_rec csi_datastructures_pub.party_rec;

721: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_INST_PARTY_RELATIONSHIP';
722: l_api_version CONSTANT NUMBER := 1.0;
723: l_csi_debug_level NUMBER;
724: l_party_rec csi_datastructures_pub.party_rec;
725: l_temp_party_rec csi_datastructures_pub.party_rec;
726: l_curr_party_rec csi_datastructures_pub.party_rec;
727: l_exp_party_rec csi_datastructures_pub.party_rec;
728: l_party_tbl csi_datastructures_pub.party_tbl;
729: l_internal_party_id NUMBER;

Line 726: l_curr_party_rec csi_datastructures_pub.party_rec;

722: l_api_version CONSTANT NUMBER := 1.0;
723: l_csi_debug_level NUMBER;
724: l_party_rec csi_datastructures_pub.party_rec;
725: l_temp_party_rec csi_datastructures_pub.party_rec;
726: l_curr_party_rec csi_datastructures_pub.party_rec;
727: l_exp_party_rec csi_datastructures_pub.party_rec;
728: l_party_tbl csi_datastructures_pub.party_tbl;
729: l_internal_party_id NUMBER;
730: l_party_has_correct_acct BOOLEAN := FALSE;

Line 727: l_exp_party_rec csi_datastructures_pub.party_rec;

723: l_csi_debug_level NUMBER;
724: l_party_rec csi_datastructures_pub.party_rec;
725: l_temp_party_rec csi_datastructures_pub.party_rec;
726: l_curr_party_rec csi_datastructures_pub.party_rec;
727: l_exp_party_rec csi_datastructures_pub.party_rec;
728: l_party_tbl csi_datastructures_pub.party_tbl;
729: l_internal_party_id NUMBER;
730: l_party_has_correct_acct BOOLEAN := FALSE;
731: l_msg_index NUMBER;

Line 728: l_party_tbl csi_datastructures_pub.party_tbl;

724: l_party_rec csi_datastructures_pub.party_rec;
725: l_temp_party_rec csi_datastructures_pub.party_rec;
726: l_curr_party_rec csi_datastructures_pub.party_rec;
727: l_exp_party_rec csi_datastructures_pub.party_rec;
728: l_party_tbl csi_datastructures_pub.party_tbl;
729: l_internal_party_id NUMBER;
730: l_party_has_correct_acct BOOLEAN := FALSE;
731: l_msg_index NUMBER;
732: l_msg_count NUMBER;

Line 739: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;

735: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
736: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
737: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
738: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
739: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
740: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
741: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
742: l_cascade_ownership_uimu VARCHAR2(1) :='N'; --Added for Bug 10414588
743: l_force_cascade VARCHAR2(1) :='N'; --Added for Bug 10414588

Line 740: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

736: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
737: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
738: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
739: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
740: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
741: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
742: l_cascade_ownership_uimu VARCHAR2(1) :='N'; --Added for Bug 10414588
743: l_force_cascade VARCHAR2(1) :='N'; --Added for Bug 10414588
744:

Line 803: l_acct_tbl csi_datastructures_pub.party_account_tbl;

799: --end of fix
800:
801: l_acct_csr acct_csr%ROWTYPE;
802: l_old_party_csr old_party_csr%ROWTYPE;
803: l_acct_tbl csi_datastructures_pub.party_account_tbl;
804: l_count NUMBER;
805: la_count NUMBER;
806: l_act_tbl csi_datastructures_pub.party_account_tbl;
807: l_row NUMBER;

Line 806: l_act_tbl csi_datastructures_pub.party_account_tbl;

802: l_old_party_csr old_party_csr%ROWTYPE;
803: l_acct_tbl csi_datastructures_pub.party_account_tbl;
804: l_count NUMBER;
805: la_count NUMBER;
806: l_act_tbl csi_datastructures_pub.party_account_tbl;
807: l_row NUMBER;
808: l_obj_ver_number NUMBER;
809: l_found BOOLEAN := FALSE;
810: l_end_date DATE;

Line 814: l_old_party_tbl csi_datastructures_pub.party_tbl := p_party_tbl;

810: l_end_date DATE;
811:
812: -- End Addition by sk on 12/06/01 for contracts TRF fix bug 2133944
813: -- Start of code addition for fixing the bug 2151750
814: l_old_party_tbl csi_datastructures_pub.party_tbl := p_party_tbl;
815: l_cld_party_rec csi_datastructures_pub.party_rec;
816: l_new_curr_party_rec csi_datastructures_pub.party_rec;
817: l_ip_acct_rec csi_datastructures_pub.party_account_rec;
818: l_temp_acct_rec csi_datastructures_pub.party_account_rec;

Line 815: l_cld_party_rec csi_datastructures_pub.party_rec;

811:
812: -- End Addition by sk on 12/06/01 for contracts TRF fix bug 2133944
813: -- Start of code addition for fixing the bug 2151750
814: l_old_party_tbl csi_datastructures_pub.party_tbl := p_party_tbl;
815: l_cld_party_rec csi_datastructures_pub.party_rec;
816: l_new_curr_party_rec csi_datastructures_pub.party_rec;
817: l_ip_acct_rec csi_datastructures_pub.party_account_rec;
818: l_temp_acct_rec csi_datastructures_pub.party_account_rec;
819: l_new_ip_acct_rec csi_datastructures_pub.party_account_rec;

Line 816: l_new_curr_party_rec csi_datastructures_pub.party_rec;

812: -- End Addition by sk on 12/06/01 for contracts TRF fix bug 2133944
813: -- Start of code addition for fixing the bug 2151750
814: l_old_party_tbl csi_datastructures_pub.party_tbl := p_party_tbl;
815: l_cld_party_rec csi_datastructures_pub.party_rec;
816: l_new_curr_party_rec csi_datastructures_pub.party_rec;
817: l_ip_acct_rec csi_datastructures_pub.party_account_rec;
818: l_temp_acct_rec csi_datastructures_pub.party_account_rec;
819: l_new_ip_acct_rec csi_datastructures_pub.party_account_rec;
820: l_pty_count NUMBER;

Line 817: l_ip_acct_rec csi_datastructures_pub.party_account_rec;

813: -- Start of code addition for fixing the bug 2151750
814: l_old_party_tbl csi_datastructures_pub.party_tbl := p_party_tbl;
815: l_cld_party_rec csi_datastructures_pub.party_rec;
816: l_new_curr_party_rec csi_datastructures_pub.party_rec;
817: l_ip_acct_rec csi_datastructures_pub.party_account_rec;
818: l_temp_acct_rec csi_datastructures_pub.party_account_rec;
819: l_new_ip_acct_rec csi_datastructures_pub.party_account_rec;
820: l_pty_count NUMBER;
821: lp_count NUMBER;

Line 818: l_temp_acct_rec csi_datastructures_pub.party_account_rec;

814: l_old_party_tbl csi_datastructures_pub.party_tbl := p_party_tbl;
815: l_cld_party_rec csi_datastructures_pub.party_rec;
816: l_new_curr_party_rec csi_datastructures_pub.party_rec;
817: l_ip_acct_rec csi_datastructures_pub.party_account_rec;
818: l_temp_acct_rec csi_datastructures_pub.party_account_rec;
819: l_new_ip_acct_rec csi_datastructures_pub.party_account_rec;
820: l_pty_count NUMBER;
821: lp_count NUMBER;
822: lpa_count NUMBER;

Line 819: l_new_ip_acct_rec csi_datastructures_pub.party_account_rec;

815: l_cld_party_rec csi_datastructures_pub.party_rec;
816: l_new_curr_party_rec csi_datastructures_pub.party_rec;
817: l_ip_acct_rec csi_datastructures_pub.party_account_rec;
818: l_temp_acct_rec csi_datastructures_pub.party_account_rec;
819: l_new_ip_acct_rec csi_datastructures_pub.party_account_rec;
820: l_pty_count NUMBER;
821: lp_count NUMBER;
822: lpa_count NUMBER;
823: l_cld_party_id NUMBER;

Line 827: l_exp_acct_rec csi_datastructures_pub.party_account_rec; -- Added by sguthiva for bug 2307804

823: l_cld_party_id NUMBER;
824: l_cld_party_acct_id NUMBER;
825: l_last_vld_org NUMBER;
826: l_last_vld_org1 NUMBER;
827: l_exp_acct_rec csi_datastructures_pub.party_account_rec; -- Added by sguthiva for bug 2307804
828: l_grp_call_contracts VARCHAR2(1);
829: -- End of code addition for fixing the bug 2151750
830: -- Start of code addition for fixing bug 6368172, section 1 of 5
831: l_old_parent_owner_pty_acct_id NUMBER;

Line 950: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

946: END LOOP; -- end loop for p_csr IN 1..l_count
947: END IF; -- end if for l_pty_count > 0
948: -- End addition for bug 2151750
949: --
950: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
951: csi_gen_utility_pvt.populate_install_param_rec;
952: END IF;
953: --
954: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

Line 954: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

950: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
951: csi_gen_utility_pvt.populate_install_param_rec;
952: END IF;
953: --
954: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
955: --
956: IF l_internal_party_id IS NULL THEN
957: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
958: FND_MSG_PUB.ADD;

Line 1982: ,p_instance_party_tbl IN csi_datastructures_pub.party_tbl

1978: ( p_api_version IN NUMBER
1979: ,p_commit IN VARCHAR2
1980: ,p_init_msg_list IN VARCHAR2
1981: ,p_validation_level IN NUMBER
1982: ,p_instance_party_tbl IN csi_datastructures_pub.party_tbl
1983: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1984: ,x_return_status OUT NOCOPY VARCHAR2
1985: ,x_msg_count OUT NOCOPY NUMBER
1986: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1983: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

1979: ,p_commit IN VARCHAR2
1980: ,p_init_msg_list IN VARCHAR2
1981: ,p_validation_level IN NUMBER
1982: ,p_instance_party_tbl IN csi_datastructures_pub.party_tbl
1983: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1984: ,x_return_status OUT NOCOPY VARCHAR2
1985: ,x_msg_count OUT NOCOPY NUMBER
1986: ,x_msg_data OUT NOCOPY VARCHAR2
1987: ) IS

Line 1991: l_party_rec csi_datastructures_pub.party_rec;

1987: ) IS
1988: l_api_name CONSTANT VARCHAR2(30) := 'EXPIRE_INST_PARTY_RELATIONSHIP';
1989: l_api_version CONSTANT NUMBER := 1.0;
1990: l_csi_debug_level NUMBER;
1991: l_party_rec csi_datastructures_pub.party_rec;
1992: l_msg_index NUMBER;
1993: l_msg_count NUMBER;
1994: l_line_count NUMBER;
1995: l_flag VARCHAR2(1) :='N';

Line 2141: ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec

2137: ( p_api_version IN NUMBER
2138: ,p_commit IN VARCHAR2
2139: ,p_init_msg_list IN VARCHAR2
2140: ,p_validation_level IN NUMBER
2141: ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec
2142: ,p_resolve_id_columns IN VARCHAR2
2143: ,p_time_stamp IN DATE
2144: ,x_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl
2145: ,x_return_status OUT NOCOPY VARCHAR2

Line 2144: ,x_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl

2140: ,p_validation_level IN NUMBER
2141: ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec
2142: ,p_resolve_id_columns IN VARCHAR2
2143: ,p_time_stamp IN DATE
2144: ,x_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl
2145: ,x_return_status OUT NOCOPY VARCHAR2
2146: ,x_msg_count OUT NOCOPY NUMBER
2147: ,x_msg_data OUT NOCOPY VARCHAR2
2148: ) IS

Line 2154: l_party_account_tbl csi_datastructures_pub.party_account_tbl;

2150: l_api_name CONSTANT VARCHAR2(30) := 'GET_INST_PARTY_ACCOUNT';
2151: l_api_version CONSTANT NUMBER := 1.0;
2152: l_csi_debug_level NUMBER;
2153: l_instance_party_account_id NUMBER;
2154: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
2155: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2156: l_line_count NUMBER;
2157: l_msg_index NUMBER;
2158: l_count NUMBER := 0;

Line 2155: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;

2151: l_api_version CONSTANT NUMBER := 1.0;
2152: l_csi_debug_level NUMBER;
2153: l_instance_party_account_id NUMBER;
2154: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
2155: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2156: l_line_count NUMBER;
2157: l_msg_index NUMBER;
2158: l_count NUMBER := 0;
2159: l_where_clause VARCHAR2(2000) ;

Line 2163: l_party_account_rec csi_datastructures_pub.party_account_header_rec;

2159: l_where_clause VARCHAR2(2000) ;
2160: l_get_acct_cursor_id NUMBER ;
2161: l_rows_processed NUMBER ;
2162: l_flag VARCHAR2(1) :='N';
2163: l_party_account_rec csi_datastructures_pub.party_account_header_rec;
2164: l_select_stmt VARCHAR2(2000) := ' SELECT ip_account_id , instance_party_id, party_account_id, '||
2165: ' relationship_type_code, active_start_date, active_end_date,context , attribute1, '||
2166: ' attribute2, attribute3, attribute4, attribute5, attribute6, attribute7,attribute8, '||
2167: ' attribute9, attribute10,attribute11, attribute12,attribute13,attribute14,attribute15, '||

Line 2354: ,p_party_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl

2350: ( p_api_version IN NUMBER
2351: ,p_commit IN VARCHAR2
2352: ,p_init_msg_list IN VARCHAR2
2353: ,p_validation_level IN NUMBER
2354: ,p_party_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
2355: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2356: ,x_return_status OUT NOCOPY VARCHAR2
2357: ,x_msg_count OUT NOCOPY NUMBER
2358: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2355: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

2351: ,p_commit IN VARCHAR2
2352: ,p_init_msg_list IN VARCHAR2
2353: ,p_validation_level IN NUMBER
2354: ,p_party_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
2355: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2356: ,x_return_status OUT NOCOPY VARCHAR2
2357: ,x_msg_count OUT NOCOPY NUMBER
2358: ,x_msg_data OUT NOCOPY VARCHAR2
2359: ) IS

Line 2364: l_party_account_rec csi_datastructures_pub.party_account_rec;

2360:
2361: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_INST_PARTY_ACCOUNT';
2362: l_api_version CONSTANT NUMBER := 1.0;
2363: l_csi_debug_level NUMBER;
2364: l_party_account_rec csi_datastructures_pub.party_account_rec;
2365: l_msg_index NUMBER;
2366: l_msg_count NUMBER;
2367: l_line_count NUMBER;
2368: l_flag VARCHAR2(1) :='N';

Line 2526: ,p_party_account_tbl IN csi_datastructures_pub.party_account_tbl

2522: ( p_api_version IN NUMBER
2523: ,p_commit IN VARCHAR2
2524: ,p_init_msg_list IN VARCHAR2
2525: ,p_validation_level IN NUMBER
2526: ,p_party_account_tbl IN csi_datastructures_pub.party_account_tbl
2527: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2528: ,x_return_status OUT NOCOPY VARCHAR2
2529: ,x_msg_count OUT NOCOPY NUMBER
2530: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2527: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

2523: ,p_commit IN VARCHAR2
2524: ,p_init_msg_list IN VARCHAR2
2525: ,p_validation_level IN NUMBER
2526: ,p_party_account_tbl IN csi_datastructures_pub.party_account_tbl
2527: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2528: ,x_return_status OUT NOCOPY VARCHAR2
2529: ,x_msg_count OUT NOCOPY NUMBER
2530: ,x_msg_data OUT NOCOPY VARCHAR2
2531: ) IS

Line 2547: l_party_account_rec csi_datastructures_pub.party_account_rec;

2543:
2544: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_INST_PARTY_ACCOUNT';
2545: l_api_version CONSTANT NUMBER := 1.0;
2546: l_csi_debug_level NUMBER;
2547: l_party_account_rec csi_datastructures_pub.party_account_rec;
2548: l_msg_index NUMBER;
2549: l_msg_count NUMBER;
2550: l_line_count NUMBER;
2551: l_flag VARCHAR2(1) :='N';

Line 2552: l_party_account_tbl csi_datastructures_pub.party_account_tbl := p_party_account_tbl;

2548: l_msg_index NUMBER;
2549: l_msg_count NUMBER;
2550: l_line_count NUMBER;
2551: l_flag VARCHAR2(1) :='N';
2552: l_party_account_tbl csi_datastructures_pub.party_account_tbl := p_party_account_tbl;
2553: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
2554: old_party_account_id NUMBER;
2555: l_acct_row NUMBER :=1;
2556: old_party_id NUMBER;

Line 2553: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;

2549: l_msg_count NUMBER;
2550: l_line_count NUMBER;
2551: l_flag VARCHAR2(1) :='N';
2552: l_party_account_tbl csi_datastructures_pub.party_account_tbl := p_party_account_tbl;
2553: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
2554: old_party_account_id NUMBER;
2555: l_acct_row NUMBER :=1;
2556: old_party_id NUMBER;
2557: l_party_id NUMBER;

Line 2558: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;

2554: old_party_account_id NUMBER;
2555: l_acct_row NUMBER :=1;
2556: old_party_id NUMBER;
2557: l_party_id NUMBER;
2558: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
2559: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
2560: l_object_id NUMBER;
2561: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
2562: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;

Line 2559: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

2555: l_acct_row NUMBER :=1;
2556: old_party_id NUMBER;
2557: l_party_id NUMBER;
2558: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
2559: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
2560: l_object_id NUMBER;
2561: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
2562: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
2563: BEGIN

Line 2867: ,p_party_account_tbl IN csi_datastructures_pub.party_account_tbl

2863: ( p_api_version IN NUMBER
2864: ,p_commit IN VARCHAR2
2865: ,p_init_msg_list IN VARCHAR2
2866: ,p_validation_level IN NUMBER
2867: ,p_party_account_tbl IN csi_datastructures_pub.party_account_tbl
2868: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2869: ,x_return_status OUT NOCOPY VARCHAR2
2870: ,x_msg_count OUT NOCOPY NUMBER
2871: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2868: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

2864: ,p_commit IN VARCHAR2
2865: ,p_init_msg_list IN VARCHAR2
2866: ,p_validation_level IN NUMBER
2867: ,p_party_account_tbl IN csi_datastructures_pub.party_account_tbl
2868: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2869: ,x_return_status OUT NOCOPY VARCHAR2
2870: ,x_msg_count OUT NOCOPY NUMBER
2871: ,x_msg_data OUT NOCOPY VARCHAR2
2872: ) IS

Line 2879: l_party_account_rec csi_datastructures_pub.party_account_rec;

2875: l_api_version CONSTANT NUMBER := 1.0;
2876: l_csi_debug_level NUMBER;
2877: l_msg_index NUMBER ;
2878: l_msg_count NUMBER;
2879: l_party_account_rec csi_datastructures_pub.party_account_rec;
2880: l_line_count NUMBER := 0 ;
2881: l_ip_account_id NUMBER ;
2882: l_flag VARCHAR2(1) :='N';
2883: