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

Line 10: -- ssawhney 4257183 igs_pe_person usage changed to igs_pe_person_base_v.

6: -- Who When What
7: -- pkpatel 27-MAR-2003 Bug 2261717
8: -- Tuned genp_get_mail_addr, genp_get_pdv_name, genp_get_prsn_names procedures
9: -- asbala 29-DEC-2003 Bug 3330997. 10GCERT
10: -- ssawhney 4257183 igs_pe_person usage changed to igs_pe_person_base_v.
11: -- Perf tuned genp_get_person_name,genp_get_prsn_email,genp_get_prsn_names
12: --------------------------------------------------------------------------------------------
13:
14: FUNCTION GENP_GET_DELIMIT_STR(

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 155: v_name VARCHAR2(256) := NULL; -- IGS_PE_PERSON name placeholder

151: v_line_4 VARCHAR2(256) := NULL; -- 4th line of address
152: v_line_5 VARCHAR2(256) := NULL; -- 5th line of address
153: v_addr VARCHAR2(2000) := NULL; -- final address variable
154: v_phone VARCHAR2(100) := NULL; -- placeholder for phone handling
155: v_name VARCHAR2(256) := NULL; -- IGS_PE_PERSON name placeholder
156: -- # 2382471 Added for Country,State and Zip Code
157: v_state VARCHAR2(256) := NULL; -- State
158: v_postal_code VARCHAR2(256) := NULL; -- ZIP CODE
159: v_country_desc VARCHAR2(256) := NULL; -- Country

Line 169: -- Purpose: Function for returning formatted IGS_PE_PERSON names and addresses

165: --
166: -- Local Functions
167: -------------------------------------------------------------------------------
168: -- Module: genp_get_per_addr
169: -- Purpose: Function for returning formatted IGS_PE_PERSON names and addresses
170: -- based on variations of the parameters passed
171: -- Notes:
172: -- p_surname_first is a boolean to place the surname before the given name
173: -- TRUE formats in surname + , + IGS_PE_TITLE + given name

Line 181: -- 'IGS_PE_PERSON name not found'

177: -- Y populates the p_phone_line parameter with the phone number
178: -- N populates the p_phone_line parameter with a null value
179: -- Exception Handlers
180: -- e_name_error: returns false and populates the p_name variable with
181: -- 'IGS_PE_PERSON name not found'
182: -- e_addr_error: returns false and populates p_line_1 with
183: -- 'No address record found'
184: --
185: -- Module History

Line 208: -- cursor for selection of the IGS_PE_PERSON name in seperate parts to allow

204:
205: BEGIN
206: DECLARE
207: -- Local Cursors
208: -- cursor for selection of the IGS_PE_PERSON name in seperate parts to allow
209: -- construction based on the user preferences
210: --skpandey, Bug#4937960: Changed c_per_name cursor definition to optimize query
211: CURSOR c_per_name (cp_person_id NUMBER)IS
212: SELECT p.PERSON_TITLE per_title,

Line 223: -- cursor for selection of the IGS_PE_PERSON address when

219: WHERE p.party_id = cp_person_id;
220:
221:
222:
223: -- cursor for selection of the IGS_PE_PERSON address when
224: -- only the person_id is supplied
225: -- ssawhney, changing to hz_parties, as co=Y record is checked.
226:
227: CURSOR c_pa(

Line 254: -- cursor for selection of the IGS_PE_PERSON address when

250: hps.party_site_id = hpsu.party_site_id (+) ;
251:
252: --padv.correspondence_ind = 'Y';
253:
254: -- cursor for selection of the IGS_PE_PERSON address when
255: -- only the person_id and IGS_CO_ADDR_TYPE is supplied
256: CURSOR c_pat(
257: cp_person_id NUMBER,
258: cp_addr_type VARCHAR2)IS

Line 270: FROM IGS_PE_PERSON_ADDR_V padv

266: -- # 2382471 Added for Country ,State and Zip Code
267: padv.state padv_state,
268: padv.postal_code padv_postal_code,
269: padv.country_desc padv_country_desc
270: FROM IGS_PE_PERSON_ADDR_V padv
271: WHERE padv.person_id = cp_person_id AND
272: padv.addr_type = cp_addr_type;
273:
274: CURSOR initial_name_cur(cp_person_id hz_parties.party_id%TYPE) IS

Line 289: e_name_error EXCEPTION; -- IGS_PE_PERSON name exception handler

285:
286: v_name VARCHAR2(256) := NULL;
287: v_line_1 VARCHAR2(256) := NULL;
288:
289: e_name_error EXCEPTION; -- IGS_PE_PERSON name exception handler
290: e_addr_error EXCEPTION; -- IGS_PE_PERSON address exception handler
291:
292: BEGIN
293: -- test for open cursor, then loop and select the persons name

Line 290: e_addr_error EXCEPTION; -- IGS_PE_PERSON address exception handler

286: v_name VARCHAR2(256) := NULL;
287: v_line_1 VARCHAR2(256) := NULL;
288:
289: e_name_error EXCEPTION; -- IGS_PE_PERSON name exception handler
290: e_addr_error EXCEPTION; -- IGS_PE_PERSON address exception handler
291:
292: BEGIN
293: -- test for open cursor, then loop and select the persons name
294: IF (c_per_name%ISOPEN) THEN

Line 942: -- Return next available IGS_PE_PERSON id value

938: p_message_name OUT NOCOPY VARCHAR2 )
939: RETURN BOOLEAN AS
940: gv_other_detail VARCHAR2(255);
941: BEGIN
942: -- Return next available IGS_PE_PERSON id value
943: DECLARE
944: v_seq_num_str VARCHAR(64);
945: v_chk_digit NUMBER(2);
946: v_new_id NUMBER(8);

Line 952: SELECT IGS_PE_PERSON_PE_ID_S.nextval

948: cst_max_attemp CONSTANT NUMBER := 5;
949: v_is_right_length BOOLEAN DEFAULT TRUE;
950: v_id_generated BOOLEAN DEFAULT FALSE;
951: CURSOR c_get_nxt_seq_num IS
952: SELECT IGS_PE_PERSON_PE_ID_S.nextval
953: FROM DUAL;
954: --skpandey, Bug#4937960: Changed c_chk_id_exists cursor definition to optimize query
955: CURSOR c_chk_id_exists (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
956: SELECT 'x'

Line 955: CURSOR c_chk_id_exists (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS

951: CURSOR c_get_nxt_seq_num IS
952: SELECT IGS_PE_PERSON_PE_ID_S.nextval
953: FROM DUAL;
954: --skpandey, Bug#4937960: Changed c_chk_id_exists cursor definition to optimize query
955: CURSOR c_chk_id_exists (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
956: SELECT 'x'
957: FROM IGS_PE_PERSON_BASE_V
958: WHERE person_id = cp_person_id;
959: FUNCTION genpl_calc_chk_digit (p_seq_num NUMBER)

Line 957: FROM IGS_PE_PERSON_BASE_V

953: FROM DUAL;
954: --skpandey, Bug#4937960: Changed c_chk_id_exists cursor definition to optimize query
955: CURSOR c_chk_id_exists (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
956: SELECT 'x'
957: FROM IGS_PE_PERSON_BASE_V
958: WHERE person_id = cp_person_id;
959: FUNCTION genpl_calc_chk_digit (p_seq_num NUMBER)
960: RETURN NUMBER
961: AS

Line 995: -- check that id does not already exist in the IGS_PE_PERSON table

991: EXIT;
992:
993: END LOOP;
994:
995: -- check that id does not already exist in the IGS_PE_PERSON table
996: OPEN c_chk_id_exists(v_new_id);
997: FETCH c_chk_id_exists INTO v_check;
998: IF (c_chk_id_exists%FOUND) THEN
999: CLOSE c_chk_id_exists;

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 1029: -- IGS_PE_PERSON.

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.
1030: -- The use of this module will generally be in the order by clause for tables
1031: -- that retrieve person_id's but require them in an order, eg. surname
1032: -- order.
1033: -- Most common use will be the order by clause of a block on a form module.

Line 1095: --ssawhney 4257183 igs_pe_person usage changed to igs_pe_person_base_v.

1091:
1092: /*---------------------------------------------------------------
1093: --Change History:
1094: --Who When What
1095: --ssawhney 4257183 igs_pe_person usage changed to igs_pe_person_base_v.
1096: -- return NULL/full_name for useless and obsolete fields like title_name,orc_user,initial_name etc.
1097: -------------------------------------------------------------------*/
1098: RETURN BOOLEAN AS
1099: BEGIN

Line 1101: v_person_details IGS_PE_PERSON_BASE_V%ROWTYPE;

1097: -------------------------------------------------------------------*/
1098: RETURN BOOLEAN AS
1099: BEGIN
1100: DECLARE
1101: v_person_details IGS_PE_PERSON_BASE_V%ROWTYPE;
1102: v_other_detail VARCHAR(255);
1103: CURSOR c_person_details IS
1104: SELECT *
1105: FROM IGS_PE_PERSON_BASE_V -- IGS_PE_API_ALT_PERS_API_ID_V

Line 1105: FROM IGS_PE_PERSON_BASE_V -- IGS_PE_API_ALT_PERS_API_ID_V

1101: v_person_details IGS_PE_PERSON_BASE_V%ROWTYPE;
1102: v_other_detail VARCHAR(255);
1103: CURSOR c_person_details IS
1104: SELECT *
1105: FROM IGS_PE_PERSON_BASE_V -- IGS_PE_API_ALT_PERS_API_ID_V
1106: WHERE person_id = p_person_id;
1107: BEGIN
1108: OPEN c_person_details;
1109: FETCH c_person_details INTO v_person_details;

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 1153: -- This module returns the selected IGS_PE_PERSON's

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
1156: OPEN c_email_addr;
1157: FETCH c_email_addr INTO v_email_addr;

Line 1155: -- select the IGS_PE_PERSON's details

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
1156: OPEN c_email_addr;
1157: FETCH c_email_addr INTO v_email_addr;
1158: -- if a record was found, return the
1159: -- email address selected

Line 1162: -- set the IGS_PE_PERSON's email address to the

1158: -- if a record was found, return the
1159: -- email address selected
1160: IF (c_email_addr%FOUND) THEN
1161: CLOSE c_email_addr;
1162: -- set the IGS_PE_PERSON's email address to the
1163: -- value selected
1164: p_email_addr := v_email_addr;
1165: p_message_name := null ;
1166: RETURN TRUE;

Line 1169: -- IGS_PE_PERSON doesn't exist

1165: p_message_name := null ;
1166: RETURN TRUE;
1167: ELSE
1168: -- set the message number as this
1169: -- IGS_PE_PERSON doesn't exist
1170: CLOSE c_email_addr;
1171: p_message_name := 'IGS_GE_VAL_DOES_NOT_XS';
1172: RETURN FALSE;
1173: END IF;

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 1201: ssawhney 4257183 igs_pe_person usage changed to igs_pe_person_base_v.

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: -------------------------------------------------------------------*/
1204:
1205: TYPE r_person_details IS RECORD (

Line 1206: surname IGS_PE_PERSON.surname%TYPE,

1202: return NULL or exact view def for complex field derivations...avoid usage of person_v
1203: -------------------------------------------------------------------*/
1204:
1205: TYPE r_person_details IS RECORD (
1206: surname IGS_PE_PERSON.surname%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,

Line 1207: given_names IGS_PE_PERSON.given_names%TYPE,

1203: -------------------------------------------------------------------*/
1204:
1205: TYPE r_person_details IS RECORD (
1206: surname IGS_PE_PERSON.surname%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,

Line 1208: title IGS_PE_PERSON.title%TYPE,

1204:
1205: TYPE r_person_details IS RECORD (
1206: surname IGS_PE_PERSON.surname%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,

Line 1209: oracle_username IGS_PE_PERSON.oracle_username%TYPE,

1205: TYPE r_person_details IS RECORD (
1206: surname IGS_PE_PERSON.surname%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,

Line 1210: preferred_given_name IGS_PE_PERSON.preferred_given_name%TYPE,

1206: surname IGS_PE_PERSON.surname%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

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

Line 1228: FROM igs_pe_person_base_v p

1224: p.full_name,
1225: NVL(P.KNOWN_AS, SUBSTR (P.FIRST_NAME, 1, DECODE(INSTR(P.FIRST_NAME, ' '), 0, LENGTH(P.FIRST_NAME), (INSTR(P.FIRST_NAME, ' ')-1)))) || ' ' || P.LAST_NAME PREFERRED_NAME,
1226: null title_name,
1227: p.LAST_NAME || ', ' || p.TITLE || ' ' || NVL(p.KNOWN_AS,p.FIRST_NAME) CONTEXT_BLOCK_NAME
1228: FROM igs_pe_person_base_v p
1229: WHERE person_id = p_person_id;
1230: BEGIN
1231: OPEN c_person_details;
1232: FETCH c_person_details INTO v_person_details;