APPS.IGW_PARTY_MERGE_PUB dependencies on IGW_PROP_PERSONS_TCA_V

Line 290: from igw_prop_persons_tca_v

286: IS
287:
288: cursor from_party_cur(l_proposal_person_party_id number) is
289: select *
290: from igw_prop_persons_tca_v
291: where proposal_person_party_id = l_proposal_person_party_id ;
292:
293: from_party_rec from_party_cur%rowtype;
294:

Line 298: from igw_prop_persons_tca_v

294:
295: --this is for person party
296: cursor to_party_cur(l_party_id number,l_proposal_id number) is
297: select *
298: from igw_prop_persons_tca_v
299: where proposal_id = l_proposal_id
300: and person_party_id = l_party_id;
301:
302: to_party_rec to_party_cur%rowtype;

Line 312: if (p_entity_name <> 'IGW_PROP_PERSONS_TCA_V')

308: BEGIN
309: savepoint party_merge_sp;
310: x_return_status := fnd_api.g_ret_sts_success;
311:
312: if (p_entity_name <> 'IGW_PROP_PERSONS_TCA_V')
313: or (p_parent_entity_name <> 'HZ_PARTIES') then
314: fnd_message.set_name ('IGW', 'IGW_MRG_ENTITY_NAME_ERR');
315: fnd_message.set_token('P_ENTITY',p_entity_name);
316: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);

Line 434: from igw_prop_persons_tca_v

430: IS
431:
432: cursor from_party_cur(l_proposal_person_party_id number) is
433: select *
434: from igw_prop_persons_tca_v
435: where proposal_person_party_id = l_proposal_person_party_id;
436:
437: from_party_rec from_party_cur%rowtype;
438:

Line 443: from igw_prop_persons_tca_v

439:
440: --this is for organization party
441: cursor to_party_cur(l_party_id number,l_proposal_id number) is
442: select *
443: from igw_prop_persons_tca_v
444: where org_party_id = l_party_id and
445: proposal_id = l_proposal_id;
446:
447: to_party_rec to_party_cur%rowtype;

Line 457: if (p_entity_name <> 'IGW_PROP_PERSONS_TCA_V')

453: savepoint party_merge_sp;
454:
455: x_return_status := fnd_api.g_ret_sts_success;
456:
457: if (p_entity_name <> 'IGW_PROP_PERSONS_TCA_V')
458: or (p_parent_entity_name <> 'HZ_PARTIES') then
459: fnd_message.set_name ('IGW', 'IGW_MRG_ENTITY_NAME_ERR');
460: fnd_message.set_token('P_ENTITY',p_entity_name);
461: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);

Line 535: from igw_prop_persons_tca_v

531:
532:
533: cursor to_party_cur(l_party_id number,l_proposal_id number) is
534: select *
535: from igw_prop_persons_tca_v
536: where org_party_id = l_party_id and
537: proposal_id = l_proposal_id;
538:
539: to_party_rec to_party_cur%rowtype;

Line 627: from igw_prop_persons_tca_v

623:
624:
625: cursor to_party_cur(l_party_id number,l_proposal_id number) is
626: select *
627: from igw_prop_persons_tca_v
628: where org_party_id = l_party_id and
629: proposal_id = l_proposal_id;
630:
631: to_party_rec to_party_cur%rowtype;