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.

[Home] [Help]

APPS.IGS_GE_GEN_002 dependencies on HZ_PARTIES

Line 218: FROM hz_parties p

214: NVL(P.KNOWN_AS,p.PERSON_FIRST_NAME) per_first_name,
215: NVL(P.KNOWN_AS, SUBSTR (P.PERSON_FIRST_NAME, 1, DECODE(INSTR(P.PERSON_FIRST_NAME, ' '), 0, LENGTH(P.PERSON_FIRST_NAME), (INSTR(P.PERSON_FIRST_NAME, ' ')-1)))) || ' ' || P.PERSON_LAST_NAME per_preferred_name ,
216: P.PERSON_TITLE || ' ' || p.PERSON_FIRST_NAME || ' ' || P.PERSON_LAST_NAME per_title_name ,
217: p.PERSON_LAST_NAME || ', ' || p.PERSON_TITLE || ' ' || NVL(p.KNOWN_AS,p.PERSON_FIRST_NAME) per_context_block_name
218: FROM hz_parties p
219: WHERE p.party_id = cp_person_id;
220:
221:
222:

Line 225: -- ssawhney, changing to hz_parties, as co=Y record is checked.

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(
228: cp_person_id NUMBER)IS
229: SELECT padv.party_id padv_person_id,

Line 241: hz_parties padv,

237: padv.state padv_state,
238: padv.postal_code padv_postal_code,
239: fnd.TERRITORY_SHORT_NAME padv_country_desc
240: FROM
241: hz_parties padv,
242: hz_party_sites hps,
243: hz_party_site_uses hpsu,
244: fnd_territories_vl fnd
245: WHERE padv.party_id = cp_person_id AND

Line 274: CURSOR initial_name_cur(cp_person_id hz_parties.party_id%TYPE) IS

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
275: SELECT SUBSTR(igs_ge_gen_002.genp_get_initials(person_first_name), 1, 10) || ' ' || person_last_name
276: FROM hz_parties
277: WHERE party_id = cp_person_id;
278:

Line 276: FROM hz_parties

272: padv.addr_type = cp_addr_type;
273:
274: CURSOR initial_name_cur(cp_person_id hz_parties.party_id%TYPE) IS
275: SELECT SUBSTR(igs_ge_gen_002.genp_get_initials(person_first_name), 1, 10) || ' ' || person_last_name
276: FROM hz_parties
277: WHERE party_id = cp_person_id;
278:
279:
280: CURSOR initial_last_name_cur(cp_person_id hz_parties.party_id%TYPE) IS

Line 280: CURSOR initial_last_name_cur(cp_person_id hz_parties.party_id%TYPE) IS

276: FROM hz_parties
277: WHERE party_id = cp_person_id;
278:
279:
280: CURSOR initial_last_name_cur(cp_person_id hz_parties.party_id%TYPE) IS
281: SELECT RTRIM(DECODE(person_last_name,null,'',DECODE(person_first_name,null,person_last_name,person_last_name
282: || ', ' ) ) || NVL(person_first_name,'')|| ' '||person_middle_name,' ')
283: FROM hz_parties
284: WHERE party_id = cp_person_id;

Line 283: FROM hz_parties

279:
280: CURSOR initial_last_name_cur(cp_person_id hz_parties.party_id%TYPE) IS
281: SELECT RTRIM(DECODE(person_last_name,null,'',DECODE(person_first_name,null,person_last_name,person_last_name
282: || ', ' ) ) || NVL(person_first_name,'')|| ' '||person_middle_name,' ')
283: FROM hz_parties
284: WHERE party_id = cp_person_id;
285:
286: v_name VARCHAR2(256) := NULL;
287: v_line_1 VARCHAR2(256) := NULL;

Line 1036: CURSOR c_person(cp_person_id hz_parties.party_id%TYPE) IS

1032: -- order.
1033: -- Most common use will be the order by clause of a block on a form module.
1034:
1035: v_ret_val VARCHAR2(255) DEFAULT NULL;
1036: CURSOR c_person(cp_person_id hz_parties.party_id%TYPE) IS
1037: SELECT DECODE(
1038: UPPER(p_field_name),
1039: 'SURNAME', p.PERSON_LAST_NAME ,
1040: 'GIVEN_NAMES', P.PERSON_FIRST_NAME ,

Line 1044: FROM hz_parties p

1040: 'GIVEN_NAMES', P.PERSON_FIRST_NAME ,
1041: 'PREFERRED_GIVEN_NAME', P.KNOWN_AS ,
1042: 'CONTEXT_BLOCK_NAME', p.PERSON_LAST_NAME || ', ' || p.PERSON_TITLE || ' ' || NVL(p.KNOWN_AS,p.PERSON_FIRST_NAME),
1043: NULL)
1044: FROM hz_parties p
1045: WHERE p.party_id = cp_person_id;
1046:
1047: CURSOR initial_last_name_cur(cp_person_id hz_parties.party_id%TYPE) IS
1048: SELECT RTRIM(DECODE(person_last_name,null,'',DECODE(person_first_name,null,person_last_name,person_last_name

Line 1047: CURSOR initial_last_name_cur(cp_person_id hz_parties.party_id%TYPE) IS

1043: NULL)
1044: FROM hz_parties p
1045: WHERE p.party_id = cp_person_id;
1046:
1047: CURSOR initial_last_name_cur(cp_person_id hz_parties.party_id%TYPE) IS
1048: SELECT RTRIM(DECODE(person_last_name,null,'',DECODE(person_first_name,null,person_last_name,person_last_name
1049: || ', ' ) ) || NVL(person_first_name,'')|| ' '||person_middle_name,' ')
1050: FROM hz_parties
1051: WHERE party_id = cp_person_id;

Line 1050: FROM hz_parties

1046:
1047: CURSOR initial_last_name_cur(cp_person_id hz_parties.party_id%TYPE) IS
1048: SELECT RTRIM(DECODE(person_last_name,null,'',DECODE(person_first_name,null,person_last_name,person_last_name
1049: || ', ' ) ) || NVL(person_first_name,'')|| ' '||person_middle_name,' ')
1050: FROM hz_parties
1051: WHERE party_id = cp_person_id;
1052:
1053:
1054: BEGIN

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 1148: --ssawhney use hz_parties instead of person_v, as single record needs to be returned

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);
1151: v_email_addr IGS_PE_PERSON_V.email_addr%TYPE;
1152: BEGIN

Line 1149: --which can anyway be used from hz_parties.

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);
1151: v_email_addr IGS_PE_PERSON_V.email_addr%TYPE;
1152: BEGIN
1153: -- This module returns the selected IGS_PE_PERSON's