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_PVT dependencies on CSI_PARTY_RELATIONSHIPS_PVT

Line 1: PACKAGE BODY csi_party_relationships_pvt AS

1: PACKAGE BODY csi_party_relationships_pvt AS
2: /* $Header: csivipb.pls 120.12 2007/10/20 00:51:30 fli ship $ */
3:
4:
5: g_pkg_name CONSTANT VARCHAR2(30) := 'CSI_PARTY_RELATIONSHIPS_PVT';

Line 5: g_pkg_name CONSTANT VARCHAR2(30) := 'CSI_PARTY_RELATIONSHIPS_PVT';

1: PACKAGE BODY csi_party_relationships_pvt AS
2: /* $Header: csivipb.pls 120.12 2007/10/20 00:51:30 fli ship $ */
3:
4:
5: g_pkg_name CONSTANT VARCHAR2(30) := 'CSI_PARTY_RELATIONSHIPS_PVT';
6: g_expire_party_flag VARCHAR2(1) := 'N';
7: --g_expire_account_flag VARCHAR2(1) := 'N'; -- Commented by sguthiva for bug 2307804
8: --g_force_expire_flag VARCHAR2(1) := 'N'; -- Commented by sguthiva for bug 2307804
9: --g_contract_event_type VARCHAR2(30) := NULL;-- Commented by sguthiva for bug 2307804

Line 1432: ,p_party_source_tbl IN OUT NOCOPY csi_party_relationships_pvt.party_source_tbl

1428: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1429: ,x_return_status OUT NOCOPY VARCHAR2
1430: ,x_msg_count OUT NOCOPY NUMBER
1431: ,x_msg_data OUT NOCOPY VARCHAR2
1432: ,p_party_source_tbl IN OUT NOCOPY csi_party_relationships_pvt.party_source_tbl
1433: ,p_party_id_tbl IN OUT NOCOPY csi_party_relationships_pvt.party_id_tbl
1434: ,p_contact_tbl IN OUT NOCOPY csi_party_relationships_pvt.contact_tbl
1435: ,p_party_rel_type_tbl IN OUT NOCOPY csi_party_relationships_pvt.party_rel_type_tbl
1436: ,p_party_count_rec IN OUT NOCOPY csi_party_relationships_pvt.party_count_rec

Line 1433: ,p_party_id_tbl IN OUT NOCOPY csi_party_relationships_pvt.party_id_tbl

1429: ,x_return_status OUT NOCOPY VARCHAR2
1430: ,x_msg_count OUT NOCOPY NUMBER
1431: ,x_msg_data OUT NOCOPY VARCHAR2
1432: ,p_party_source_tbl IN OUT NOCOPY csi_party_relationships_pvt.party_source_tbl
1433: ,p_party_id_tbl IN OUT NOCOPY csi_party_relationships_pvt.party_id_tbl
1434: ,p_contact_tbl IN OUT NOCOPY csi_party_relationships_pvt.contact_tbl
1435: ,p_party_rel_type_tbl IN OUT NOCOPY csi_party_relationships_pvt.party_rel_type_tbl
1436: ,p_party_count_rec IN OUT NOCOPY csi_party_relationships_pvt.party_count_rec
1437: ,p_called_from_grp IN VARCHAR2

Line 1434: ,p_contact_tbl IN OUT NOCOPY csi_party_relationships_pvt.contact_tbl

1430: ,x_msg_count OUT NOCOPY NUMBER
1431: ,x_msg_data OUT NOCOPY VARCHAR2
1432: ,p_party_source_tbl IN OUT NOCOPY csi_party_relationships_pvt.party_source_tbl
1433: ,p_party_id_tbl IN OUT NOCOPY csi_party_relationships_pvt.party_id_tbl
1434: ,p_contact_tbl IN OUT NOCOPY csi_party_relationships_pvt.contact_tbl
1435: ,p_party_rel_type_tbl IN OUT NOCOPY csi_party_relationships_pvt.party_rel_type_tbl
1436: ,p_party_count_rec IN OUT NOCOPY csi_party_relationships_pvt.party_count_rec
1437: ,p_called_from_grp IN VARCHAR2
1438:

Line 1435: ,p_party_rel_type_tbl IN OUT NOCOPY csi_party_relationships_pvt.party_rel_type_tbl

1431: ,x_msg_data OUT NOCOPY VARCHAR2
1432: ,p_party_source_tbl IN OUT NOCOPY csi_party_relationships_pvt.party_source_tbl
1433: ,p_party_id_tbl IN OUT NOCOPY csi_party_relationships_pvt.party_id_tbl
1434: ,p_contact_tbl IN OUT NOCOPY csi_party_relationships_pvt.contact_tbl
1435: ,p_party_rel_type_tbl IN OUT NOCOPY csi_party_relationships_pvt.party_rel_type_tbl
1436: ,p_party_count_rec IN OUT NOCOPY csi_party_relationships_pvt.party_count_rec
1437: ,p_called_from_grp IN VARCHAR2
1438:
1439: ) IS

Line 1436: ,p_party_count_rec IN OUT NOCOPY csi_party_relationships_pvt.party_count_rec

1432: ,p_party_source_tbl IN OUT NOCOPY csi_party_relationships_pvt.party_source_tbl
1433: ,p_party_id_tbl IN OUT NOCOPY csi_party_relationships_pvt.party_id_tbl
1434: ,p_contact_tbl IN OUT NOCOPY csi_party_relationships_pvt.contact_tbl
1435: ,p_party_rel_type_tbl IN OUT NOCOPY csi_party_relationships_pvt.party_rel_type_tbl
1436: ,p_party_count_rec IN OUT NOCOPY csi_party_relationships_pvt.party_count_rec
1437: ,p_called_from_grp IN VARCHAR2
1438:
1439: ) IS
1440:

Line 4517: ,p_inst_party_tbl IN OUT NOCOPY csi_party_relationships_pvt.inst_party_tbl

4513: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
4514: ,x_return_status OUT NOCOPY VARCHAR2
4515: ,x_msg_count OUT NOCOPY NUMBER
4516: ,x_msg_data OUT NOCOPY VARCHAR2
4517: ,p_inst_party_tbl IN OUT NOCOPY csi_party_relationships_pvt.inst_party_tbl
4518: ,p_acct_rel_type_tbl IN OUT NOCOPY csi_party_relationships_pvt.acct_rel_type_tbl
4519: ,p_site_use_tbl IN OUT NOCOPY csi_party_relationships_pvt.site_use_tbl
4520: ,p_account_count_rec IN OUT NOCOPY csi_party_relationships_pvt.account_count_rec
4521: ,p_called_from_grp IN VARCHAR2

Line 4518: ,p_acct_rel_type_tbl IN OUT NOCOPY csi_party_relationships_pvt.acct_rel_type_tbl

4514: ,x_return_status OUT NOCOPY VARCHAR2
4515: ,x_msg_count OUT NOCOPY NUMBER
4516: ,x_msg_data OUT NOCOPY VARCHAR2
4517: ,p_inst_party_tbl IN OUT NOCOPY csi_party_relationships_pvt.inst_party_tbl
4518: ,p_acct_rel_type_tbl IN OUT NOCOPY csi_party_relationships_pvt.acct_rel_type_tbl
4519: ,p_site_use_tbl IN OUT NOCOPY csi_party_relationships_pvt.site_use_tbl
4520: ,p_account_count_rec IN OUT NOCOPY csi_party_relationships_pvt.account_count_rec
4521: ,p_called_from_grp IN VARCHAR2
4522: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl

Line 4519: ,p_site_use_tbl IN OUT NOCOPY csi_party_relationships_pvt.site_use_tbl

4515: ,x_msg_count OUT NOCOPY NUMBER
4516: ,x_msg_data OUT NOCOPY VARCHAR2
4517: ,p_inst_party_tbl IN OUT NOCOPY csi_party_relationships_pvt.inst_party_tbl
4518: ,p_acct_rel_type_tbl IN OUT NOCOPY csi_party_relationships_pvt.acct_rel_type_tbl
4519: ,p_site_use_tbl IN OUT NOCOPY csi_party_relationships_pvt.site_use_tbl
4520: ,p_account_count_rec IN OUT NOCOPY csi_party_relationships_pvt.account_count_rec
4521: ,p_called_from_grp IN VARCHAR2
4522: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
4523: ) IS

Line 4520: ,p_account_count_rec IN OUT NOCOPY csi_party_relationships_pvt.account_count_rec

4516: ,x_msg_data OUT NOCOPY VARCHAR2
4517: ,p_inst_party_tbl IN OUT NOCOPY csi_party_relationships_pvt.inst_party_tbl
4518: ,p_acct_rel_type_tbl IN OUT NOCOPY csi_party_relationships_pvt.acct_rel_type_tbl
4519: ,p_site_use_tbl IN OUT NOCOPY csi_party_relationships_pvt.site_use_tbl
4520: ,p_account_count_rec IN OUT NOCOPY csi_party_relationships_pvt.account_count_rec
4521: ,p_called_from_grp IN VARCHAR2
4522: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
4523: ) IS
4524:

Line 5611: -- IF csi_party_relationships_pvt.g_force_expire_flag = 'N' -- Commented by sguthiva for bug 2307804

5607: END IF;
5608: --
5609: -- End addition by sguthiva for bug 2307804
5610: IF p_party_account_rec.expire_flag = fnd_api.g_false -- Added by sguthiva for bug 2307804
5611: -- IF csi_party_relationships_pvt.g_force_expire_flag = 'N' -- Commented by sguthiva for bug 2307804
5612: THEN
5613: FND_MESSAGE.Set_Name('CSI', 'CSI_API_EXP_NOT_ALLOWED');
5614: FND_MESSAGE.Set_Token('COLUMN', 'OWNER ACCOUNT');
5615: FND_MSG_PUB.ADD;

Line 8080: csi_party_relationships_pvt.get_contact_details

8076: AND ( l_old_party_source_tbl IS NOT NULL )
8077: AND ( l_old_contact_flag = 'Y') -- Added for bug 2179142
8078: )
8079: THEN
8080: csi_party_relationships_pvt.get_contact_details
8081: (
8082: p_api_version => p_api_version
8083: ,p_commit => p_commit
8084: ,p_init_msg_list => p_init_msg_list

Line 8272: csi_party_relationships_pvt.get_contact_details

8268: AND ( l_new_party_source_tbl IS NOT NULL )
8269: AND ( l_new_contact_flag = 'Y') -- Added for bug 2179142
8270: )
8271: THEN
8272: csi_party_relationships_pvt.get_contact_details
8273: (
8274: p_api_version => p_api_version
8275: ,p_commit => p_commit
8276: ,p_init_msg_list => p_init_msg_list

Line 8952: csi_party_relationships_pvt.Resolve_id_columns(l_account_header_tbl);

8948: l_account_header_tbl(1).ship_to_postal_code := NULL;
8949: l_account_header_tbl(1).ship_to_country := NULL;
8950:
8951:
8952: csi_party_relationships_pvt.Resolve_id_columns(l_account_header_tbl);
8953:
8954: x_account_history_tbl(i).old_party_account_number := l_account_header_tbl(1).party_account_number;
8955: x_account_history_tbl(i).old_party_account_name := l_account_header_tbl(1).party_account_name;
8956: x_account_history_tbl(i).old_bill_to_location := l_account_header_tbl(1).bill_to_location;

Line 9003: csi_party_relationships_pvt.Resolve_id_columns(l_account_header_tbl);

8999: l_account_header_tbl(1).ship_to_state := NULL;
9000: l_account_header_tbl(1).ship_to_postal_code := NULL;
9001: l_account_header_tbl(1).ship_to_country := NULL;
9002:
9003: csi_party_relationships_pvt.Resolve_id_columns(l_account_header_tbl);
9004:
9005: x_account_history_tbl(i).new_party_account_number := l_account_header_tbl(1).party_account_number;
9006: x_account_history_tbl(i).new_party_account_name := l_account_header_tbl(1).party_account_name;
9007: x_account_history_tbl(i).new_bill_to_location := l_account_header_tbl(1).bill_to_location;

Line 9089: END csi_party_relationships_pvt ;

9085: p_data => x_msg_data );
9086:
9087: END get_inst_party_account_hist;
9088:
9089: END csi_party_relationships_pvt ;