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.PQH_ASG_WRAPPER dependencies on PQH_GEN_FORM

Line 111: And copy_entity_txn_id = pqh_gen_form.g_txn_id;

107: Select information22
108: from pqh_copy_entity_attribs
109: Where information22 IS NOT NULL
110: And row_type_cd = 'CRITERIA'
111: And copy_entity_txn_id = pqh_gen_form.g_txn_id;
112: --
113: Cursor c_get_system_type_name(p_person_type_id IN
114: per_person_types.person_type_id%TYPE) Is
115: Select ppt.system_person_type

Line 228: And copy_entity_txn_id = pqh_gen_form.g_txn_id;

224: Select information22
225: from pqh_copy_entity_attribs
226: Where information22 IS NOT NULL
227: And row_type_cd = 'CRITERIA'
228: And copy_entity_txn_id = pqh_gen_form.g_txn_id;
229: --
230: Cursor c_get_system_type_name(p_person_type_id IN
231: per_person_types.person_type_id%TYPE) Is
232: Select ppt.system_person_type

Line 349: And copy_entity_txn_id = pqh_gen_form.g_txn_id;

345: Where (check_information1 IS NOT NULL OR
346: check_information2 IS NOT NULL OR
347: check_information3 IS NOT NULL)
348: and row_type_cd = 'CRITERIA'
349: And copy_entity_txn_id = pqh_gen_form.g_txn_id;
350: --
351: Cursor c_get_system_type_name(p_person_type_id IN
352: per_person_types.person_type_id%TYPE) Is
353: Select ppt.system_person_type

Line 368: hr_utility.set_location('Entering:'||pqh_gen_form.g_txn_id||'/'|| l_proc, 10);

364: l_proc VARCHAR2(72) := g_package||'Is_Person_Correct_Type';
365: --
366: BEGIN
367: --
368: hr_utility.set_location('Entering:'||pqh_gen_form.g_txn_id||'/'|| l_proc, 10);
369: --
370: IF pqh_gen_form.g_txn_id IS NULL THEN
371: --
372: hr_utility.set_location(l_proc,15);

Line 370: IF pqh_gen_form.g_txn_id IS NULL THEN

366: BEGIN
367: --
368: hr_utility.set_location('Entering:'||pqh_gen_form.g_txn_id||'/'|| l_proc, 10);
369: --
370: IF pqh_gen_form.g_txn_id IS NULL THEN
371: --
372: hr_utility.set_location(l_proc,15);
373: --
374: pqh_gen_form.g_txn_id := pqh_generic.g_txn_id; -- #3553723

Line 374: pqh_gen_form.g_txn_id := pqh_generic.g_txn_id; -- #3553723

370: IF pqh_gen_form.g_txn_id IS NULL THEN
371: --
372: hr_utility.set_location(l_proc,15);
373: --
374: pqh_gen_form.g_txn_id := pqh_generic.g_txn_id; -- #3553723
375: -- RETURN ( 'TRUE');-- #3553723
376: --
377: END IF;
378: --

Line 452: And copy_entity_txn_id = pqh_gen_form.g_txn_id;

448: Select information22
449: from pqh_copy_entity_attribs
450: Where information22 IS NOT NULL
451: And row_type_cd = 'CRITERIA'
452: And copy_entity_txn_id = pqh_gen_form.g_txn_id;
453: --
454: Cursor c_compare_person_type(p_system_person_type IN
455: per_person_types.system_person_type%TYPE) Is
456: Select 'x'

Line 636: And copy_entity_txn_id = pqh_gen_form.g_txn_id;

632: to_number(information3)
633: from pqh_copy_entity_attribs
634: Where information2 IS NOT NULL
635: And row_type_cd = 'CRITERIA'
636: And copy_entity_txn_id = pqh_gen_form.g_txn_id;
637: --
638: Cursor c_get_hierarchy_root(p_org_hierarchy_id number) is
639: select organization_id_parent
640: from per_org_structure_elements ose,

Line 953: And copy_entity_txn_id = pqh_gen_form.g_txn_id;

949: to_number(information9)
950: from pqh_copy_entity_attribs
951: Where information8 IS NOT NULL
952: And row_type_cd = 'CRITERIA'
953: And copy_entity_txn_id = pqh_gen_form.g_txn_id;
954: --
955: v_pos_in_hierarchy BOOLEAN := FALSE;
956: v_return_message VARCHAR2(5);
957: v_pos_hierarchy number;