361: p_create_update_sst_flag IN VARCHAR2,
362: p_raise_error_flag IN VARCHAR2,
363: p_party_type IN VARCHAR2,
364: p_party_id IN NUMBER,
365: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
366: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
367: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
368: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
369: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
362: p_raise_error_flag IN VARCHAR2,
363: p_party_type IN VARCHAR2,
364: p_party_id IN NUMBER,
365: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
366: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
367: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
368: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
369: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
370: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
363: p_party_type IN VARCHAR2,
364: p_party_id IN NUMBER,
365: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
366: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
367: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
368: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
369: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
370: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
371: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
364: p_party_id IN NUMBER,
365: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
366: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
367: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
368: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
369: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
370: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
371: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
372: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
365: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
366: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
367: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
368: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
369: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
370: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
371: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
372: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
373: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
366: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
367: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
368: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
369: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
370: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
371: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
372: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
373: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
374: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
367: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
368: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
369: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
370: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
371: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
372: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
373: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
374: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
375: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
368: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
369: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
370: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
371: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
372: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
373: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
374: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
375: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
376: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
369: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
370: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
371: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
372: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
373: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
374: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
375: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
376: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
377: p_data_source_type IN VARCHAR2,
370: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
371: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
372: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
373: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
374: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
375: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
376: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
377: p_data_source_type IN VARCHAR2,
378: x_return_status IN OUT NOCOPY VARCHAR2
371: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
372: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
373: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
374: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
375: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
376: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
377: p_data_source_type IN VARCHAR2,
378: x_return_status IN OUT NOCOPY VARCHAR2
379: );
372: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
373: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
374: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
375: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
376: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
377: p_data_source_type IN VARCHAR2,
378: x_return_status IN OUT NOCOPY VARCHAR2
379: );
380:
414: p_create_update_flag IN VARCHAR2,
415: p_create_update_sst_flag IN VARCHAR2,
416: p_raise_error_flag IN VARCHAR2,
417: p_party_id IN NUMBER,
418: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
419: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
420: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
421: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
422: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
415: p_create_update_sst_flag IN VARCHAR2,
416: p_raise_error_flag IN VARCHAR2,
417: p_party_id IN NUMBER,
418: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
419: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
420: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
421: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
422: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
423: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
416: p_raise_error_flag IN VARCHAR2,
417: p_party_id IN NUMBER,
418: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
419: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
420: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
421: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
422: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
423: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
424: p_data_source_type IN VARCHAR2,
417: p_party_id IN NUMBER,
418: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
419: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
420: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
421: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
422: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
423: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
424: p_data_source_type IN VARCHAR2,
425: x_return_status IN OUT NOCOPY VARCHAR2
418: p_new_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
419: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
420: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
421: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
422: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
423: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
424: p_data_source_type IN VARCHAR2,
425: x_return_status IN OUT NOCOPY VARCHAR2
426: );
419: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
420: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
421: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
422: p_sst_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
423: p_new_sst_person_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
424: p_data_source_type IN VARCHAR2,
425: x_return_status IN OUT NOCOPY VARCHAR2
426: );
427:
461: p_create_update_flag IN VARCHAR2,
462: p_create_update_sst_flag IN VARCHAR2,
463: p_raise_error_flag IN VARCHAR2,
464: p_party_id IN NUMBER,
465: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
466: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
467: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
468: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
469: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
462: p_create_update_sst_flag IN VARCHAR2,
463: p_raise_error_flag IN VARCHAR2,
464: p_party_id IN NUMBER,
465: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
466: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
467: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
468: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
469: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
470: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
463: p_raise_error_flag IN VARCHAR2,
464: p_party_id IN NUMBER,
465: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
466: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
467: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
468: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
469: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
470: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
471: p_data_source_type IN VARCHAR2,
464: p_party_id IN NUMBER,
465: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
466: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
467: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
468: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
469: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
470: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
471: p_data_source_type IN VARCHAR2,
472: x_return_status IN OUT NOCOPY VARCHAR2
465: p_new_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
466: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
467: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
468: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
469: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
470: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
471: p_data_source_type IN VARCHAR2,
472: x_return_status IN OUT NOCOPY VARCHAR2
473: );
466: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
467: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
468: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
469: p_sst_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
470: p_new_sst_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
471: p_data_source_type IN VARCHAR2,
472: x_return_status IN OUT NOCOPY VARCHAR2
473: );
474:
723: * p_party_id
724: * OUT:
725: *
726: * NOTES
727: * This will be called only from HZ_PARTY_V2PUB.do_create_party.
728: * And only when a new party is created by a non-user_entered source system.
729: *
730: * MODIFICATION HISTORY
731: *
734: */
735:
736: PROCEDURE create_exceptions (
737: p_party_type IN VARCHAR2,
738: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
739: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
740: p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
741: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
742: p_third_party_content_source IN VARCHAR2,
735:
736: PROCEDURE create_exceptions (
737: p_party_type IN VARCHAR2,
738: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
739: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
740: p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
741: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
742: p_third_party_content_source IN VARCHAR2,
743: p_party_id IN NUMBER
736: PROCEDURE create_exceptions (
737: p_party_type IN VARCHAR2,
738: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
739: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
740: p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
741: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
742: p_third_party_content_source IN VARCHAR2,
743: p_party_id IN NUMBER
744: );
737: p_party_type IN VARCHAR2,
738: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
739: DEFAULT HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
740: p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
741: DEFAULT HZ_PARTY_V2PUB.G_MISS_PERSON_REC,
742: p_third_party_content_source IN VARCHAR2,
743: p_party_id IN NUMBER
744: );
745: