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.17.12020000.3 2012/11/05 09:58:22 aabmishr 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.17.12020000.3 2012/11/05 09:58:22 aabmishr 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 4556: ,p_inst_party_tbl IN OUT NOCOPY csi_party_relationships_pvt.inst_party_tbl

4552: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
4553: ,x_return_status OUT NOCOPY VARCHAR2
4554: ,x_msg_count OUT NOCOPY NUMBER
4555: ,x_msg_data OUT NOCOPY VARCHAR2
4556: ,p_inst_party_tbl IN OUT NOCOPY csi_party_relationships_pvt.inst_party_tbl
4557: ,p_acct_rel_type_tbl IN OUT NOCOPY csi_party_relationships_pvt.acct_rel_type_tbl
4558: ,p_site_use_tbl IN OUT NOCOPY csi_party_relationships_pvt.site_use_tbl
4559: ,p_account_count_rec IN OUT NOCOPY csi_party_relationships_pvt.account_count_rec
4560: ,p_called_from_grp IN VARCHAR2

Line 4557: ,p_acct_rel_type_tbl IN OUT NOCOPY csi_party_relationships_pvt.acct_rel_type_tbl

4553: ,x_return_status OUT NOCOPY VARCHAR2
4554: ,x_msg_count OUT NOCOPY NUMBER
4555: ,x_msg_data OUT NOCOPY VARCHAR2
4556: ,p_inst_party_tbl IN OUT NOCOPY csi_party_relationships_pvt.inst_party_tbl
4557: ,p_acct_rel_type_tbl IN OUT NOCOPY csi_party_relationships_pvt.acct_rel_type_tbl
4558: ,p_site_use_tbl IN OUT NOCOPY csi_party_relationships_pvt.site_use_tbl
4559: ,p_account_count_rec IN OUT NOCOPY csi_party_relationships_pvt.account_count_rec
4560: ,p_called_from_grp IN VARCHAR2
4561: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl

Line 4558: ,p_site_use_tbl IN OUT NOCOPY csi_party_relationships_pvt.site_use_tbl

4554: ,x_msg_count OUT NOCOPY NUMBER
4555: ,x_msg_data OUT NOCOPY VARCHAR2
4556: ,p_inst_party_tbl IN OUT NOCOPY csi_party_relationships_pvt.inst_party_tbl
4557: ,p_acct_rel_type_tbl IN OUT NOCOPY csi_party_relationships_pvt.acct_rel_type_tbl
4558: ,p_site_use_tbl IN OUT NOCOPY csi_party_relationships_pvt.site_use_tbl
4559: ,p_account_count_rec IN OUT NOCOPY csi_party_relationships_pvt.account_count_rec
4560: ,p_called_from_grp IN VARCHAR2
4561: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
4562: ) IS

Line 4559: ,p_account_count_rec IN OUT NOCOPY csi_party_relationships_pvt.account_count_rec

4555: ,x_msg_data OUT NOCOPY VARCHAR2
4556: ,p_inst_party_tbl IN OUT NOCOPY csi_party_relationships_pvt.inst_party_tbl
4557: ,p_acct_rel_type_tbl IN OUT NOCOPY csi_party_relationships_pvt.acct_rel_type_tbl
4558: ,p_site_use_tbl IN OUT NOCOPY csi_party_relationships_pvt.site_use_tbl
4559: ,p_account_count_rec IN OUT NOCOPY csi_party_relationships_pvt.account_count_rec
4560: ,p_called_from_grp IN VARCHAR2
4561: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
4562: ) IS
4563:

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

5648: END IF;
5649: --
5650: -- End addition by sguthiva for bug 2307804
5651: IF p_party_account_rec.expire_flag = fnd_api.g_false -- Added by sguthiva for bug 2307804
5652: -- IF csi_party_relationships_pvt.g_force_expire_flag = 'N' -- Commented by sguthiva for bug 2307804
5653: THEN
5654: FND_MESSAGE.Set_Name('CSI', 'CSI_API_EXP_NOT_ALLOWED');
5655: FND_MESSAGE.Set_Token('COLUMN', 'OWNER ACCOUNT');
5656: FND_MSG_PUB.ADD;

Line 8130: csi_party_relationships_pvt.get_contact_details

8126: AND ( l_old_party_source_tbl IS NOT NULL )
8127: AND ( l_old_contact_flag = 'Y') -- Added for bug 2179142
8128: )
8129: THEN
8130: csi_party_relationships_pvt.get_contact_details
8131: (
8132: p_api_version => p_api_version
8133: ,p_commit => p_commit
8134: ,p_init_msg_list => p_init_msg_list

Line 8322: csi_party_relationships_pvt.get_contact_details

8318: AND ( l_new_party_source_tbl IS NOT NULL )
8319: AND ( l_new_contact_flag = 'Y') -- Added for bug 2179142
8320: )
8321: THEN
8322: csi_party_relationships_pvt.get_contact_details
8323: (
8324: p_api_version => p_api_version
8325: ,p_commit => p_commit
8326: ,p_init_msg_list => p_init_msg_list

Line 9002: csi_party_relationships_pvt.Resolve_id_columns(l_account_header_tbl);

8998: l_account_header_tbl(1).ship_to_postal_code := NULL;
8999: l_account_header_tbl(1).ship_to_country := NULL;
9000:
9001:
9002: csi_party_relationships_pvt.Resolve_id_columns(l_account_header_tbl);
9003:
9004: x_account_history_tbl(i).old_party_account_number := l_account_header_tbl(1).party_account_number;
9005: x_account_history_tbl(i).old_party_account_name := l_account_header_tbl(1).party_account_name;
9006: x_account_history_tbl(i).old_bill_to_location := l_account_header_tbl(1).bill_to_location;

Line 9053: csi_party_relationships_pvt.Resolve_id_columns(l_account_header_tbl);

9049: l_account_header_tbl(1).ship_to_state := NULL;
9050: l_account_header_tbl(1).ship_to_postal_code := NULL;
9051: l_account_header_tbl(1).ship_to_country := NULL;
9052:
9053: csi_party_relationships_pvt.Resolve_id_columns(l_account_header_tbl);
9054:
9055: x_account_history_tbl(i).new_party_account_number := l_account_header_tbl(1).party_account_number;
9056: x_account_history_tbl(i).new_party_account_name := l_account_header_tbl(1).party_account_name;
9057: x_account_history_tbl(i).new_bill_to_location := l_account_header_tbl(1).bill_to_location;

Line 9139: END csi_party_relationships_pvt ;

9135: p_data => x_msg_data );
9136:
9137: END get_inst_party_account_hist;
9138:
9139: END csi_party_relationships_pvt ;