DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_PARTY_RELATIONSHIPS_PVT

Line 438: ,p_acct_id_tbl IN OUT NOCOPY csi_party_relationships_pvt.acct_id_tbl

434: p_account_tbl IN csi_datastructures_pub.party_account_tbl
435: ,p_account_rec IN csi_datastructures_pub.party_account_rec
436: ,p_pty_src_table IN VARCHAR2
437: ,p_party_id IN NUMBER
438: ,p_acct_id_tbl IN OUT NOCOPY csi_party_relationships_pvt.acct_id_tbl
439: ,p_start_date IN DATE -- Instance Party Start Date
440: ,p_end_date IN DATE -- Instance Party End Date
441: ) RETURN BOOLEAN IS
442: --

Line 5848: l_party_source_tbl csi_party_relationships_pvt.party_source_tbl;

5844: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
5845: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
5846: l_internal_party_id NUMBER;
5847: l_party_has_correct_acct BOOLEAN := FALSE;
5848: l_party_source_tbl csi_party_relationships_pvt.party_source_tbl;
5849: l_party_id_tbl csi_party_relationships_pvt.party_id_tbl;
5850: l_contact_tbl csi_party_relationships_pvt.contact_tbl;
5851: l_party_rel_type_tbl csi_party_relationships_pvt.party_rel_type_tbl;
5852: l_party_count_rec csi_party_relationships_pvt.party_count_rec;

Line 5849: l_party_id_tbl csi_party_relationships_pvt.party_id_tbl;

5845: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
5846: l_internal_party_id NUMBER;
5847: l_party_has_correct_acct BOOLEAN := FALSE;
5848: l_party_source_tbl csi_party_relationships_pvt.party_source_tbl;
5849: l_party_id_tbl csi_party_relationships_pvt.party_id_tbl;
5850: l_contact_tbl csi_party_relationships_pvt.contact_tbl;
5851: l_party_rel_type_tbl csi_party_relationships_pvt.party_rel_type_tbl;
5852: l_party_count_rec csi_party_relationships_pvt.party_count_rec;
5853: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;

Line 5850: l_contact_tbl csi_party_relationships_pvt.contact_tbl;

5846: l_internal_party_id NUMBER;
5847: l_party_has_correct_acct BOOLEAN := FALSE;
5848: l_party_source_tbl csi_party_relationships_pvt.party_source_tbl;
5849: l_party_id_tbl csi_party_relationships_pvt.party_id_tbl;
5850: l_contact_tbl csi_party_relationships_pvt.contact_tbl;
5851: l_party_rel_type_tbl csi_party_relationships_pvt.party_rel_type_tbl;
5852: l_party_count_rec csi_party_relationships_pvt.party_count_rec;
5853: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
5854: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;

Line 5851: l_party_rel_type_tbl csi_party_relationships_pvt.party_rel_type_tbl;

5847: l_party_has_correct_acct BOOLEAN := FALSE;
5848: l_party_source_tbl csi_party_relationships_pvt.party_source_tbl;
5849: l_party_id_tbl csi_party_relationships_pvt.party_id_tbl;
5850: l_contact_tbl csi_party_relationships_pvt.contact_tbl;
5851: l_party_rel_type_tbl csi_party_relationships_pvt.party_rel_type_tbl;
5852: l_party_count_rec csi_party_relationships_pvt.party_count_rec;
5853: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
5854: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
5855: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;

Line 5852: l_party_count_rec csi_party_relationships_pvt.party_count_rec;

5848: l_party_source_tbl csi_party_relationships_pvt.party_source_tbl;
5849: l_party_id_tbl csi_party_relationships_pvt.party_id_tbl;
5850: l_contact_tbl csi_party_relationships_pvt.contact_tbl;
5851: l_party_rel_type_tbl csi_party_relationships_pvt.party_rel_type_tbl;
5852: l_party_count_rec csi_party_relationships_pvt.party_count_rec;
5853: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
5854: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
5855: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
5856: l_account_count_rec csi_party_relationships_pvt.account_count_rec;

Line 5853: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;

5849: l_party_id_tbl csi_party_relationships_pvt.party_id_tbl;
5850: l_contact_tbl csi_party_relationships_pvt.contact_tbl;
5851: l_party_rel_type_tbl csi_party_relationships_pvt.party_rel_type_tbl;
5852: l_party_count_rec csi_party_relationships_pvt.party_count_rec;
5853: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
5854: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
5855: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
5856: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
5857: l_acct_id_tbl csi_party_relationships_pvt.acct_id_tbl;

Line 5854: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;

5850: l_contact_tbl csi_party_relationships_pvt.contact_tbl;
5851: l_party_rel_type_tbl csi_party_relationships_pvt.party_rel_type_tbl;
5852: l_party_count_rec csi_party_relationships_pvt.party_count_rec;
5853: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
5854: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
5855: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
5856: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
5857: l_acct_id_tbl csi_party_relationships_pvt.acct_id_tbl;
5858: l_grp_error_tbl csi_datastructures_pub.grp_error_tbl;

Line 5855: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;

5851: l_party_rel_type_tbl csi_party_relationships_pvt.party_rel_type_tbl;
5852: l_party_count_rec csi_party_relationships_pvt.party_count_rec;
5853: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
5854: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
5855: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
5856: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
5857: l_acct_id_tbl csi_party_relationships_pvt.acct_id_tbl;
5858: l_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
5859: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;

Line 5856: l_account_count_rec csi_party_relationships_pvt.account_count_rec;

5852: l_party_count_rec csi_party_relationships_pvt.party_count_rec;
5853: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
5854: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
5855: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
5856: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
5857: l_acct_id_tbl csi_party_relationships_pvt.acct_id_tbl;
5858: l_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
5859: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
5860: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;

Line 5857: l_acct_id_tbl csi_party_relationships_pvt.acct_id_tbl;

5853: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
5854: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
5855: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
5856: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
5857: l_acct_id_tbl csi_party_relationships_pvt.acct_id_tbl;
5858: l_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
5859: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
5860: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
5861: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;

Line 6461: csi_party_relationships_pvt.create_inst_party_relationship

6457: RAISE SKIP_ERROR;
6458: END IF;
6459: --
6460: -- Call Private package to validate and create party relationship
6461: csi_party_relationships_pvt.create_inst_party_relationship
6462: ( p_api_version => p_api_version
6463: ,p_commit => fnd_api.g_false
6464: ,p_init_msg_list => p_init_msg_list
6465: ,p_validation_level => p_validation_level

Line 6554: csi_party_relationships_pvt.create_inst_party_account

6550: l_iface_error_text := substr(x_msg_data,1,2000);
6551: RAISE SKIP_ERROR;
6552: END IF;
6553: -- Call Private package to validate and create party accounts
6554: csi_party_relationships_pvt.create_inst_party_account
6555: ( p_api_version => p_api_version
6556: ,p_commit => fnd_api.g_false
6557: ,p_init_msg_list => p_init_msg_list
6558: ,p_validation_level => p_validation_level