APPS.CS_CHARGE_CREATE_ORDER_PVT dependencies on HZ_PARTIES

Line 744: FROM hz_parties

740:
741: --srini
742: CURSOR Get_party_number is
743: SELECT party_number
744: FROM hz_parties
745: WHERE party_id = p_party_id;
746:
747: l_party_number hz_parties.party_number%type;
748: --

Line 747: l_party_number hz_parties.party_number%type;

743: SELECT party_number
744: FROM hz_parties
745: WHERE party_id = p_party_id;
746:
747: l_party_number hz_parties.party_number%type;
748: --
749: --
750: -- For Events
751:

Line 2139: csi_txn_party_detail_tbl(1).party_source_table := 'HZ_PARTIES';

2135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2136: END;
2137:
2138: csi_txn_party_detail_tbl(1).instance_party_id := l_instance_party_id;
2139: csi_txn_party_detail_tbl(1).party_source_table := 'HZ_PARTIES';
2140: csi_txn_party_detail_tbl(1).party_source_id := l_internal_party_id;
2141: csi_txn_party_detail_tbl(1).relationship_type_code := 'OWNER';
2142: csi_txn_party_detail_tbl(1).txn_line_details_index := 1;
2143: csi_txn_party_detail_tbl(1).contact_flag := 'N';

Line 2200: csi_txn_party_detail_tbl(1).party_source_table := 'HZ_PARTIES';

2196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2197: END;
2198:
2199: csi_txn_party_detail_tbl(1).instance_party_id := l_instance_party_id;
2200: csi_txn_party_detail_tbl(1).party_source_table := 'HZ_PARTIES';
2201: csi_txn_party_detail_tbl(1).party_source_id := l_internal_party_id;
2202: csi_txn_party_detail_tbl(1).relationship_type_code := 'OWNER';
2203: csi_txn_party_detail_tbl(1).txn_line_details_index := 1;
2204: csi_txn_party_detail_tbl(1).contact_flag := 'N';

Line 2216: csi_txn_party_detail_tbl(1).party_source_table := 'HZ_PARTIES';

2212:
2213: ELSE -- shipment line
2214: IF l_src_change_owner = 'Y' THEN
2215: -- Create Party record
2216: csi_txn_party_detail_tbl(1).party_source_table := 'HZ_PARTIES';
2217: csi_txn_party_detail_tbl(1).party_source_id := EstDtlTab(i).customer_id;
2218: csi_txn_party_detail_tbl(1).relationship_type_code := 'OWNER';
2219: csi_txn_party_detail_tbl(1).txn_line_details_index := 1;
2220: csi_txn_party_detail_tbl(1).contact_flag := 'N';

Line 2857: csi_txn_party_detail_tbl(1).party_source_table := 'HZ_PARTIES';

2853: FROM hz_cust_accounts
2854: WHERE cust_account_id = l_account_id);
2855:
2856: csi_txn_party_detail_tbl(1).instance_party_id := l_instance_party_id;
2857: csi_txn_party_detail_tbl(1).party_source_table := 'HZ_PARTIES';
2858: csi_txn_party_detail_tbl(1).party_source_id := l_internal_party_id;
2859: csi_txn_party_detail_tbl(1).relationship_type_code := 'OWNER';
2860: csi_txn_party_detail_tbl(1).txn_line_details_index := 1;
2861: csi_txn_party_detail_tbl(1).contact_flag := 'N';

Line 2880: csi_txn_party_detail_tbl(1).party_source_table := 'HZ_PARTIES';

2876:
2877: ELSE -- shipment line
2878: IF l_src_change_owner = 'Y' THEN
2879: -- Create Party record
2880: csi_txn_party_detail_tbl(1).party_source_table := 'HZ_PARTIES';
2881: csi_txn_party_detail_tbl(1).party_source_id := EstDtlTab(i).customer_id;
2882: csi_txn_party_detail_tbl(1).relationship_type_code := 'OWNER';
2883: csi_txn_party_detail_tbl(1).txn_line_details_index := 1;
2884: csi_txn_party_detail_tbl(1).contact_flag := 'N';