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:
743: -- Added by sk on 12/06/01 for contracts TRF fix bug 2133944

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:
743: -- Added by sk on 12/06/01 for contracts TRF fix bug 2133944
744:

Line 798: l_acct_tbl csi_datastructures_pub.party_account_tbl;

794: --end of fix
795:
796: l_acct_csr acct_csr%ROWTYPE;
797: l_old_party_csr old_party_csr%ROWTYPE;
798: l_acct_tbl csi_datastructures_pub.party_account_tbl;
799: l_count NUMBER;
800: la_count NUMBER;
801: l_act_tbl csi_datastructures_pub.party_account_tbl;
802: l_row NUMBER;

Line 801: l_act_tbl csi_datastructures_pub.party_account_tbl;

797: l_old_party_csr old_party_csr%ROWTYPE;
798: l_acct_tbl csi_datastructures_pub.party_account_tbl;
799: l_count NUMBER;
800: la_count NUMBER;
801: l_act_tbl csi_datastructures_pub.party_account_tbl;
802: l_row NUMBER;
803: l_obj_ver_number NUMBER;
804: l_found BOOLEAN := FALSE;
805: l_end_date DATE;

Line 809: l_old_party_tbl csi_datastructures_pub.party_tbl := p_party_tbl;

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

Line 810: l_cld_party_rec csi_datastructures_pub.party_rec;

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

Line 811: l_new_curr_party_rec csi_datastructures_pub.party_rec;

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

Line 812: l_ip_acct_rec csi_datastructures_pub.party_account_rec;

808: -- Start of code addition for fixing the bug 2151750
809: l_old_party_tbl csi_datastructures_pub.party_tbl := p_party_tbl;
810: l_cld_party_rec csi_datastructures_pub.party_rec;
811: l_new_curr_party_rec csi_datastructures_pub.party_rec;
812: l_ip_acct_rec csi_datastructures_pub.party_account_rec;
813: l_temp_acct_rec csi_datastructures_pub.party_account_rec;
814: l_new_ip_acct_rec csi_datastructures_pub.party_account_rec;
815: l_pty_count NUMBER;
816: lp_count NUMBER;

Line 813: l_temp_acct_rec csi_datastructures_pub.party_account_rec;

809: l_old_party_tbl csi_datastructures_pub.party_tbl := p_party_tbl;
810: l_cld_party_rec csi_datastructures_pub.party_rec;
811: l_new_curr_party_rec csi_datastructures_pub.party_rec;
812: l_ip_acct_rec csi_datastructures_pub.party_account_rec;
813: l_temp_acct_rec csi_datastructures_pub.party_account_rec;
814: l_new_ip_acct_rec csi_datastructures_pub.party_account_rec;
815: l_pty_count NUMBER;
816: lp_count NUMBER;
817: lpa_count NUMBER;

Line 814: l_new_ip_acct_rec csi_datastructures_pub.party_account_rec;

810: l_cld_party_rec csi_datastructures_pub.party_rec;
811: l_new_curr_party_rec csi_datastructures_pub.party_rec;
812: l_ip_acct_rec csi_datastructures_pub.party_account_rec;
813: l_temp_acct_rec csi_datastructures_pub.party_account_rec;
814: l_new_ip_acct_rec csi_datastructures_pub.party_account_rec;
815: l_pty_count NUMBER;
816: lp_count NUMBER;
817: lpa_count NUMBER;
818: l_cld_party_id NUMBER;

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

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

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

939: END LOOP; -- end loop for p_csr IN 1..l_count
940: END IF; -- end if for l_pty_count > 0
941: -- End addition for bug 2151750
942: --
943: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
944: csi_gen_utility_pvt.populate_install_param_rec;
945: END IF;
946: --
947: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

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

943: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
944: csi_gen_utility_pvt.populate_install_param_rec;
945: END IF;
946: --
947: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
948: --
949: IF l_internal_party_id IS NULL THEN
950: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
951: FND_MSG_PUB.ADD;

Line 1933: ,p_instance_party_tbl IN csi_datastructures_pub.party_tbl

1929: ( p_api_version IN NUMBER
1930: ,p_commit IN VARCHAR2
1931: ,p_init_msg_list IN VARCHAR2
1932: ,p_validation_level IN NUMBER
1933: ,p_instance_party_tbl IN csi_datastructures_pub.party_tbl
1934: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1935: ,x_return_status OUT NOCOPY VARCHAR2
1936: ,x_msg_count OUT NOCOPY NUMBER
1937: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1934: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

1930: ,p_commit IN VARCHAR2
1931: ,p_init_msg_list IN VARCHAR2
1932: ,p_validation_level IN NUMBER
1933: ,p_instance_party_tbl IN csi_datastructures_pub.party_tbl
1934: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1935: ,x_return_status OUT NOCOPY VARCHAR2
1936: ,x_msg_count OUT NOCOPY NUMBER
1937: ,x_msg_data OUT NOCOPY VARCHAR2
1938: ) IS

Line 1942: l_party_rec csi_datastructures_pub.party_rec;

1938: ) IS
1939: l_api_name CONSTANT VARCHAR2(30) := 'EXPIRE_INST_PARTY_RELATIONSHIP';
1940: l_api_version CONSTANT NUMBER := 1.0;
1941: l_csi_debug_level NUMBER;
1942: l_party_rec csi_datastructures_pub.party_rec;
1943: l_msg_index NUMBER;
1944: l_msg_count NUMBER;
1945: l_line_count NUMBER;
1946: l_flag VARCHAR2(1) :='N';

Line 2092: ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec

2088: ( p_api_version IN NUMBER
2089: ,p_commit IN VARCHAR2
2090: ,p_init_msg_list IN VARCHAR2
2091: ,p_validation_level IN NUMBER
2092: ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec
2093: ,p_resolve_id_columns IN VARCHAR2
2094: ,p_time_stamp IN DATE
2095: ,x_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl
2096: ,x_return_status OUT NOCOPY VARCHAR2

Line 2095: ,x_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl

2091: ,p_validation_level IN NUMBER
2092: ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec
2093: ,p_resolve_id_columns IN VARCHAR2
2094: ,p_time_stamp IN DATE
2095: ,x_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl
2096: ,x_return_status OUT NOCOPY VARCHAR2
2097: ,x_msg_count OUT NOCOPY NUMBER
2098: ,x_msg_data OUT NOCOPY VARCHAR2
2099: ) IS

Line 2105: l_party_account_tbl csi_datastructures_pub.party_account_tbl;

2101: l_api_name CONSTANT VARCHAR2(30) := 'GET_INST_PARTY_ACCOUNT';
2102: l_api_version CONSTANT NUMBER := 1.0;
2103: l_csi_debug_level NUMBER;
2104: l_instance_party_account_id NUMBER;
2105: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
2106: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2107: l_line_count NUMBER;
2108: l_msg_index NUMBER;
2109: l_count NUMBER := 0;

Line 2106: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;

2102: l_api_version CONSTANT NUMBER := 1.0;
2103: l_csi_debug_level NUMBER;
2104: l_instance_party_account_id NUMBER;
2105: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
2106: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2107: l_line_count NUMBER;
2108: l_msg_index NUMBER;
2109: l_count NUMBER := 0;
2110: l_where_clause VARCHAR2(2000) ;

Line 2114: l_party_account_rec csi_datastructures_pub.party_account_header_rec;

2110: l_where_clause VARCHAR2(2000) ;
2111: l_get_acct_cursor_id NUMBER ;
2112: l_rows_processed NUMBER ;
2113: l_flag VARCHAR2(1) :='N';
2114: l_party_account_rec csi_datastructures_pub.party_account_header_rec;
2115: l_select_stmt VARCHAR2(2000) := ' SELECT ip_account_id , instance_party_id, party_account_id, '||
2116: ' relationship_type_code, active_start_date, active_end_date,context , attribute1, '||
2117: ' attribute2, attribute3, attribute4, attribute5, attribute6, attribute7,attribute8, '||
2118: ' attribute9, attribute10,attribute11, attribute12,attribute13,attribute14,attribute15, '||

Line 2305: ,p_party_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl

2301: ( p_api_version IN NUMBER
2302: ,p_commit IN VARCHAR2
2303: ,p_init_msg_list IN VARCHAR2
2304: ,p_validation_level IN NUMBER
2305: ,p_party_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
2306: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2307: ,x_return_status OUT NOCOPY VARCHAR2
2308: ,x_msg_count OUT NOCOPY NUMBER
2309: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2306: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

2302: ,p_commit IN VARCHAR2
2303: ,p_init_msg_list IN VARCHAR2
2304: ,p_validation_level IN NUMBER
2305: ,p_party_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
2306: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2307: ,x_return_status OUT NOCOPY VARCHAR2
2308: ,x_msg_count OUT NOCOPY NUMBER
2309: ,x_msg_data OUT NOCOPY VARCHAR2
2310: ) IS

Line 2315: l_party_account_rec csi_datastructures_pub.party_account_rec;

2311:
2312: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_INST_PARTY_ACCOUNT';
2313: l_api_version CONSTANT NUMBER := 1.0;
2314: l_csi_debug_level NUMBER;
2315: l_party_account_rec csi_datastructures_pub.party_account_rec;
2316: l_msg_index NUMBER;
2317: l_msg_count NUMBER;
2318: l_line_count NUMBER;
2319: l_flag VARCHAR2(1) :='N';

Line 2477: ,p_party_account_tbl IN csi_datastructures_pub.party_account_tbl

2473: ( p_api_version IN NUMBER
2474: ,p_commit IN VARCHAR2
2475: ,p_init_msg_list IN VARCHAR2
2476: ,p_validation_level IN NUMBER
2477: ,p_party_account_tbl IN csi_datastructures_pub.party_account_tbl
2478: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2479: ,x_return_status OUT NOCOPY VARCHAR2
2480: ,x_msg_count OUT NOCOPY NUMBER
2481: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2478: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

2474: ,p_commit IN VARCHAR2
2475: ,p_init_msg_list IN VARCHAR2
2476: ,p_validation_level IN NUMBER
2477: ,p_party_account_tbl IN csi_datastructures_pub.party_account_tbl
2478: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2479: ,x_return_status OUT NOCOPY VARCHAR2
2480: ,x_msg_count OUT NOCOPY NUMBER
2481: ,x_msg_data OUT NOCOPY VARCHAR2
2482: ) IS

Line 2498: l_party_account_rec csi_datastructures_pub.party_account_rec;

2494:
2495: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_INST_PARTY_ACCOUNT';
2496: l_api_version CONSTANT NUMBER := 1.0;
2497: l_csi_debug_level NUMBER;
2498: l_party_account_rec csi_datastructures_pub.party_account_rec;
2499: l_msg_index NUMBER;
2500: l_msg_count NUMBER;
2501: l_line_count NUMBER;
2502: l_flag VARCHAR2(1) :='N';

Line 2503: l_party_account_tbl csi_datastructures_pub.party_account_tbl := p_party_account_tbl;

2499: l_msg_index NUMBER;
2500: l_msg_count NUMBER;
2501: l_line_count NUMBER;
2502: l_flag VARCHAR2(1) :='N';
2503: l_party_account_tbl csi_datastructures_pub.party_account_tbl := p_party_account_tbl;
2504: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
2505: old_party_account_id NUMBER;
2506: l_acct_row NUMBER :=1;
2507: old_party_id NUMBER;

Line 2504: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;

2500: l_msg_count NUMBER;
2501: l_line_count NUMBER;
2502: l_flag VARCHAR2(1) :='N';
2503: l_party_account_tbl csi_datastructures_pub.party_account_tbl := p_party_account_tbl;
2504: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
2505: old_party_account_id NUMBER;
2506: l_acct_row NUMBER :=1;
2507: old_party_id NUMBER;
2508: l_party_id NUMBER;

Line 2509: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;

2505: old_party_account_id NUMBER;
2506: l_acct_row NUMBER :=1;
2507: old_party_id NUMBER;
2508: l_party_id NUMBER;
2509: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
2510: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
2511: l_object_id NUMBER;
2512: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
2513: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;

Line 2510: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

2506: l_acct_row NUMBER :=1;
2507: old_party_id NUMBER;
2508: l_party_id NUMBER;
2509: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
2510: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
2511: l_object_id NUMBER;
2512: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
2513: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
2514: BEGIN

Line 2818: ,p_party_account_tbl IN csi_datastructures_pub.party_account_tbl

2814: ( p_api_version IN NUMBER
2815: ,p_commit IN VARCHAR2
2816: ,p_init_msg_list IN VARCHAR2
2817: ,p_validation_level IN NUMBER
2818: ,p_party_account_tbl IN csi_datastructures_pub.party_account_tbl
2819: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2820: ,x_return_status OUT NOCOPY VARCHAR2
2821: ,x_msg_count OUT NOCOPY NUMBER
2822: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2819: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

2815: ,p_commit IN VARCHAR2
2816: ,p_init_msg_list IN VARCHAR2
2817: ,p_validation_level IN NUMBER
2818: ,p_party_account_tbl IN csi_datastructures_pub.party_account_tbl
2819: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2820: ,x_return_status OUT NOCOPY VARCHAR2
2821: ,x_msg_count OUT NOCOPY NUMBER
2822: ,x_msg_data OUT NOCOPY VARCHAR2
2823: ) IS

Line 2830: l_party_account_rec csi_datastructures_pub.party_account_rec;

2826: l_api_version CONSTANT NUMBER := 1.0;
2827: l_csi_debug_level NUMBER;
2828: l_msg_index NUMBER ;
2829: l_msg_count NUMBER;
2830: l_party_account_rec csi_datastructures_pub.party_account_rec;
2831: l_line_count NUMBER := 0 ;
2832: l_ip_account_id NUMBER ;
2833: l_flag VARCHAR2(1) :='N';
2834: