DBA Data[Home] [Help]

APPS.IGS_PR_GEN_006 dependencies on IGS_PE_PERSON

Line 2487: || cursor to use hz_parties instead of igs_pe_person

2483: || Change History :
2484: || Who When What
2485: || ssawhney 17-feb-2003 Bug : 2758856 : Added the parameter x_external_reference in the call to IGS_PE_PERS_ENCUMB_PKG.UPDATE_ROW
2486: || kdande 17-Dec-2002 Bug# 2543601. Changed the query for c_pe
2487: || cursor to use hz_parties instead of igs_pe_person
2488: || nalkumar 19-NOV-2002 Bug NO: 2658550. Modified this function as per the FA110 PR Enh.
2489: || pkpatel 7-OCT-2002 Bug No: 2600842
2490: || Added the parameter x_auth_resp_id in the call to igs_pe_pers_encumb_pkg
2491: || (reverse chronological order - newest change first)

Line 2540: v_authorising_person_id IGS_PE_PERSON.person_id%TYPE;

2536: v_decode_val1 NUMBER(6,3);
2537: v_decode_val2 VARCHAR2(2);
2538: lv_spo_sequence_number IGS_PE_PERS_ENCUMB.SPO_SEQUENCE_NUMBER%TYPE;
2539: PRAGMA EXCEPTION_INIT (e_record_locked, -54);
2540: v_authorising_person_id IGS_PE_PERSON.person_id%TYPE;
2541: v_message_text VARCHAR2(2000) DEFAULT NULL;
2542: v_message_level VARCHAR2(10) DEFAULT NULL;
2543: v_action_expiry_dt IGS_PE_PERS_ENCUMB.expiry_dt%TYPE;
2544: v_pen_expiry_dt IGS_PE_PERS_ENCUMB.expiry_dt%TYPE;