APPS.PQP_HRTCA_INTEGRATION dependencies on PER_ADDRESSES

Line 5: TYPE t_per_addr IS TABLE OF per_addresses%ROWTYPE INDEX BY Binary_Integer;

1: Package PQP_HRTCA_Integration AUTHID CURRENT_USER AS
2: /* $Header: pqphrtcaintg.pkh 120.0 2005/05/29 02:22:00 appldev noship $ */
3:
4:
5: TYPE t_per_addr IS TABLE OF per_addresses%ROWTYPE INDEX BY Binary_Integer;
6: g_per_addr_rec t_per_addr;
7:
8: TYPE oss_pp_rec IS RECORD
9: (pp_rowid Rowid

Line 557: -- (1) p_person_id : Person_id from per_addresses table

553: -- Parameters
554: -- ==========
555: -- (a) IN
556: -- ======
557: -- (1) p_person_id : Person_id from per_addresses table
558: -- (2) p_effective_date : Effective date is the session date when the
559: -- Address migration is to be done.
560: -- (3) p_party_id : The Student party_id from hz_parties
561: -- (4) p_party_type : Deafult to PERSON for Students

Line 596: ,p_per_addr_rec_new IN per_addresses%ROWTYPE

592: ,p_person_id IN Number
593: ,p_party_id IN Number
594: ,p_address_id IN Number
595: ,p_effective_date IN Date
596: ,p_per_addr_rec_new IN per_addresses%ROWTYPE
597: -- TCA
598: ,p_party_type IN Varchar2
599: ,p_action IN Varchar2
600: ,p_status IN hz_party_sites.status%TYPE

Line 621: -- (1) p_person_id : Person_id from per_addresses table

617: -- Parameters
618: -- ==========
619: -- (a) IN
620: -- ======
621: -- (1) p_person_id : Person_id from per_addresses table
622: -- (2) p_effective_date : Effective date is the session date when the
623: -- Address migration is to be done.
624: -- (3) p_party_id : The Student party_id from hz_parties
625: -- (4) p_party_type : Deafult to PERSON for Students

Line 660: ,p_per_addr_rec_new IN per_addresses%ROWTYPE

656: ,p_person_id IN Number
657: ,p_party_id IN Number
658: ,p_address_id IN Number
659: ,p_effective_date IN Date
660: ,p_per_addr_rec_new IN per_addresses%ROWTYPE
661: ,p_per_addr_rec_old IN per_addresses%ROWTYPE
662: -- TCA
663: ,p_party_type IN Varchar2 DEFAULT 'PERSON'
664: ,p_action IN Varchar2 DEFAULT 'UPDATE'

Line 661: ,p_per_addr_rec_old IN per_addresses%ROWTYPE

657: ,p_party_id IN Number
658: ,p_address_id IN Number
659: ,p_effective_date IN Date
660: ,p_per_addr_rec_new IN per_addresses%ROWTYPE
661: ,p_per_addr_rec_old IN per_addresses%ROWTYPE
662: -- TCA
663: ,p_party_type IN Varchar2 DEFAULT 'PERSON'
664: ,p_action IN Varchar2 DEFAULT 'UPDATE'
665: ,p_status IN Varchar2 DEFAULT 'A'

Line 681: (p_HR_Address_Rec IN OUT NOCOPY Per_Addresses%ROWTYPE

677: -- =============================================================================
678: -- Person_Address_API:
679: -- =============================================================================
680: PROCEDURE Person_Address_API
681: (p_HR_Address_Rec IN OUT NOCOPY Per_Addresses%ROWTYPE
682: ,p_validate IN Boolean DEFAULT FALSE
683: ,p_action IN Varchar2 DEFAULT 'CREATE'
684: ,p_effective_date IN Date
685: ,p_pradd_ovlapval_override IN Boolean DEFAULT FALSE