eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_GE_GEN_002 dependencies on IGS_PE_PERSON_V

Line 143: -- Removed the initial_last_name from igs_pe_person_v and write specific cursor to find the value.

139: -------------------------------------------------------------------------------------------
140: -- Change History
141: -- Who When What
142: -- pkpatel 27-MAR-2003 Bug 2261717
143: -- Removed the initial_last_name from igs_pe_person_v and write specific cursor to find the value.
144: -- masehgal 05-June-2002 # 2382471 Added Country,State and Zip Code to Address in the
145: -- local function genp_get_per_addr
146: --
147: --------------------------------------------------------------------------------------------

Line 1025: Removed the initial_last_name from igs_pe_person_v and write specific cursor to find the value.

1021: RETURN VARCHAR2 AS
1022: /*
1023: WHO WHEN WHAT
1024: pkpatel 27-MAR-2003 Bug 2261717
1025: Removed the initial_last_name from igs_pe_person_v and write specific cursor to find the value.
1026: skpandey 13-JAN-2006 Bug#4937960: Changed c_person cursor definition to optimize query
1027: */
1028: -- This module returns the value of a field passed in as a parameter for a
1029: -- IGS_PE_PERSON.

Line 1146: FROM HZ_PARTIES pdv -- IGS_PE_PERSON_V pdv

1142: BEGIN
1143: DECLARE
1144: CURSOR c_email_addr IS
1145: SELECT pdv. EMAIL_ADDRESS email_addr
1146: FROM HZ_PARTIES pdv -- IGS_PE_PERSON_V pdv
1147: WHERE pdv.party_id = p_person_id;
1148: --ssawhney use hz_parties instead of person_v, as single record needs to be returned
1149: --which can anyway be used from hz_parties.
1150: v_other_detail VARCHAR2(255);

Line 1151: v_email_addr IGS_PE_PERSON_V.email_addr%TYPE;

1147: WHERE pdv.party_id = p_person_id;
1148: --ssawhney use hz_parties instead of person_v, as single record needs to be returned
1149: --which can anyway be used from hz_parties.
1150: v_other_detail VARCHAR2(255);
1151: v_email_addr IGS_PE_PERSON_V.email_addr%TYPE;
1152: BEGIN
1153: -- This module returns the selected IGS_PE_PERSON's
1154: -- email address
1155: -- select the IGS_PE_PERSON's details

Line 1199: Filtered the query to be based only on IGS_PE_PERSON_V.

1195: RETURN BOOLEAN AS
1196: /*
1197: WHO WHEN WHAT
1198: pkpatel 27-MAR-2003 Bug 2261717
1199: Filtered the query to be based only on IGS_PE_PERSON_V.
1200: Removed the initial_name and passed full_name for the OUT parameter.
1201: ssawhney 4257183 igs_pe_person usage changed to igs_pe_person_base_v.
1202: return NULL or exact view def for complex field derivations...avoid usage of person_v
1203: -------------------------------------------------------------------*/

Line 1211: full_name IGS_PE_PERSON_V.full_name%TYPE,

1207: given_names IGS_PE_PERSON.given_names%TYPE,
1208: title IGS_PE_PERSON.title%TYPE,
1209: oracle_username IGS_PE_PERSON.oracle_username%TYPE,
1210: preferred_given_name IGS_PE_PERSON.preferred_given_name%TYPE,
1211: full_name IGS_PE_PERSON_V.full_name%TYPE,
1212: preferred_name IGS_PE_PERSON_V.preferred_name%TYPE,
1213: title_name IGS_PE_PERSON_V.title_name%TYPE,
1214: context_block_name IGS_PE_PERSON_V.context_block_name%TYPE
1215: );

Line 1212: preferred_name IGS_PE_PERSON_V.preferred_name%TYPE,

1208: title IGS_PE_PERSON.title%TYPE,
1209: oracle_username IGS_PE_PERSON.oracle_username%TYPE,
1210: preferred_given_name IGS_PE_PERSON.preferred_given_name%TYPE,
1211: full_name IGS_PE_PERSON_V.full_name%TYPE,
1212: preferred_name IGS_PE_PERSON_V.preferred_name%TYPE,
1213: title_name IGS_PE_PERSON_V.title_name%TYPE,
1214: context_block_name IGS_PE_PERSON_V.context_block_name%TYPE
1215: );
1216: v_person_details r_person_details;

Line 1213: title_name IGS_PE_PERSON_V.title_name%TYPE,

1209: oracle_username IGS_PE_PERSON.oracle_username%TYPE,
1210: preferred_given_name IGS_PE_PERSON.preferred_given_name%TYPE,
1211: full_name IGS_PE_PERSON_V.full_name%TYPE,
1212: preferred_name IGS_PE_PERSON_V.preferred_name%TYPE,
1213: title_name IGS_PE_PERSON_V.title_name%TYPE,
1214: context_block_name IGS_PE_PERSON_V.context_block_name%TYPE
1215: );
1216: v_person_details r_person_details;
1217: v_other_detail VARCHAR(255);

Line 1214: context_block_name IGS_PE_PERSON_V.context_block_name%TYPE

1210: preferred_given_name IGS_PE_PERSON.preferred_given_name%TYPE,
1211: full_name IGS_PE_PERSON_V.full_name%TYPE,
1212: preferred_name IGS_PE_PERSON_V.preferred_name%TYPE,
1213: title_name IGS_PE_PERSON_V.title_name%TYPE,
1214: context_block_name IGS_PE_PERSON_V.context_block_name%TYPE
1215: );
1216: v_person_details r_person_details;
1217: v_other_detail VARCHAR(255);
1218: CURSOR c_person_details IS