APPS.IGS_GE_GEN_002 dependencies on IGS_PE_PERSON_BASE_V

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 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 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 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 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;