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 PER_PERSON_TYPES

Line 103: (p_person_type_id IN per_person_types.person_type_id%TYPE)

99: -- |------------------------< IS_TYPE_AN_APPLICANT_TYPE >---------------------+
100: -- ---------------------------------------------------------------------------+
101: --
102: FUNCTION Is_Type_An_Applicant_Type
103: (p_person_type_id IN per_person_types.person_type_id%TYPE)
104: RETURN CHAR IS
105: --
106: Cursor c_get_system_person_type Is
107: Select information22

Line 114: per_person_types.person_type_id%TYPE) Is

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
116: From per_person_types ppt
117: Where ppt.person_type_id = p_person_type_id;
118: --

Line 116: From per_person_types ppt

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
116: From per_person_types ppt
117: Where ppt.person_type_id = p_person_type_id;
118: --
119: v_system_person_type per_person_types.system_person_type%TYPE := NULL;
120: v_criteria_system_person_type per_person_types.system_person_type%TYPE := NULL;

Line 119: v_system_person_type per_person_types.system_person_type%TYPE := NULL;

115: Select ppt.system_person_type
116: From per_person_types ppt
117: Where ppt.person_type_id = p_person_type_id;
118: --
119: v_system_person_type per_person_types.system_person_type%TYPE := NULL;
120: v_criteria_system_person_type per_person_types.system_person_type%TYPE := NULL;
121: v_dummy_field varchar2(50) := NULL;
122: v_return_value varchar2(5);
123: --

Line 120: v_criteria_system_person_type per_person_types.system_person_type%TYPE := NULL;

116: From per_person_types ppt
117: Where ppt.person_type_id = p_person_type_id;
118: --
119: v_system_person_type per_person_types.system_person_type%TYPE := NULL;
120: v_criteria_system_person_type per_person_types.system_person_type%TYPE := NULL;
121: v_dummy_field varchar2(50) := NULL;
122: v_return_value varchar2(5);
123: --
124: l_proc varchar2(72) := g_package||'Is_Type_An_Applicant_Type';

Line 220: (p_person_type_id IN per_person_types.person_type_id%TYPE)

216: -- |-------------------------< IS_TYPE_A_SYSTEM_TYPE >------------------------+
217: -- ---------------------------------------------------------------------------+
218: --
219: FUNCTION Is_Type_A_System_Type2
220: (p_person_type_id IN per_person_types.person_type_id%TYPE)
221: RETURN CHAR IS
222: --
223: Cursor c_get_system_person_type Is
224: Select information22

Line 231: per_person_types.person_type_id%TYPE) Is

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
233: From per_person_types ppt
234: Where ppt.person_type_id = p_person_type_id;
235: --

Line 233: From per_person_types ppt

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
233: From per_person_types ppt
234: Where ppt.person_type_id = p_person_type_id;
235: --
236: v_system_person_type per_person_types.system_person_type%TYPE := NULL;
237: v_criteria_system_person_type per_person_types.system_person_type%TYPE := NULL;

Line 236: v_system_person_type per_person_types.system_person_type%TYPE := NULL;

232: Select ppt.system_person_type
233: From per_person_types ppt
234: Where ppt.person_type_id = p_person_type_id;
235: --
236: v_system_person_type per_person_types.system_person_type%TYPE := NULL;
237: v_criteria_system_person_type per_person_types.system_person_type%TYPE := NULL;
238: v_dummy_field varchar2(50) := NULL;
239: v_return_value varchar2(5);
240: --

Line 237: v_criteria_system_person_type per_person_types.system_person_type%TYPE := NULL;

233: From per_person_types ppt
234: Where ppt.person_type_id = p_person_type_id;
235: --
236: v_system_person_type per_person_types.system_person_type%TYPE := NULL;
237: v_criteria_system_person_type per_person_types.system_person_type%TYPE := NULL;
238: v_dummy_field varchar2(50) := NULL;
239: v_return_value varchar2(5);
240: --
241: l_proc varchar2(72) := g_package||'Is_Type_A_System_Type';

Line 337: (p_person_type_id IN per_person_types.person_type_id%TYPE)

333: -- |------------------------< IS_PERSON_CORRECT_TYPE >------------------------+
334: -- ---------------------------------------------------------------------------+
335: --
336: FUNCTION Is_Person_Correct_Type
337: (p_person_type_id IN per_person_types.person_type_id%TYPE)
338: RETURN CHAR IS
339: --
340: Cursor c_get_criteria_person_type Is
341: Select NVL(check_information1,'N'),

Line 352: per_person_types.person_type_id%TYPE) Is

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
354: From per_person_types ppt
355: Where ppt.person_type_id = p_person_type_id;
356: --

Line 354: From per_person_types ppt

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
354: From per_person_types ppt
355: Where ppt.person_type_id = p_person_type_id;
356: --
357: v_system_person_type per_person_types.system_person_type%TYPE := NULL;
358: v_emp VARCHAR2(3) := NULL;

Line 357: v_system_person_type per_person_types.system_person_type%TYPE := NULL;

353: Select ppt.system_person_type
354: From per_person_types ppt
355: Where ppt.person_type_id = p_person_type_id;
356: --
357: v_system_person_type per_person_types.system_person_type%TYPE := NULL;
358: v_emp VARCHAR2(3) := NULL;
359: v_apl VARCHAR2(3) := NULL;
360: v_cwk VARCHAR2(3) := NULL;
361: v_dummy_field VARCHAR2(50) := NULL;

Line 444: (p_person_type_id IN per_person_types.person_type_id%TYPE)

440: -- |------------------------< IS_TYPE_A_SYSTEM_TYPE >-------------------------+
441: -- ---------------------------------------------------------------------------+
442: --
443: FUNCTION Is_Type_A_System_Type
444: (p_person_type_id IN per_person_types.person_type_id%TYPE)
445: RETURN CHAR IS
446: --
447: Cursor c_get_system_person_type Is
448: Select information22

Line 455: per_person_types.system_person_type%TYPE) Is

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'
457: From per_person_types ppt
458: Where ppt.system_person_type = p_system_person_type
459: and ppt.person_type_id = p_person_type_id;

Line 457: From per_person_types ppt

453: --
454: Cursor c_compare_person_type(p_system_person_type IN
455: per_person_types.system_person_type%TYPE) Is
456: Select 'x'
457: From per_person_types ppt
458: Where ppt.system_person_type = p_system_person_type
459: and ppt.person_type_id = p_person_type_id;
460: --
461: Cursor c_get_system_type_name(p_person_type_id IN

Line 462: per_person_types.person_type_id%TYPE) Is

458: Where ppt.system_person_type = p_system_person_type
459: and ppt.person_type_id = p_person_type_id;
460: --
461: Cursor c_get_system_type_name(p_person_type_id IN
462: per_person_types.person_type_id%TYPE) Is
463: Select ppt.system_person_type
464: From per_person_types ppt
465: Where ppt.person_type_id = p_person_type_id;
466: --

Line 464: From per_person_types ppt

460: --
461: Cursor c_get_system_type_name(p_person_type_id IN
462: per_person_types.person_type_id%TYPE) Is
463: Select ppt.system_person_type
464: From per_person_types ppt
465: Where ppt.person_type_id = p_person_type_id;
466: --
467: v_system_person_type per_person_types.system_person_type%TYPE := NULL;
468: v_dummy_field Varchar2(50) := NULL;

Line 467: v_system_person_type per_person_types.system_person_type%TYPE := NULL;

463: Select ppt.system_person_type
464: From per_person_types ppt
465: Where ppt.person_type_id = p_person_type_id;
466: --
467: v_system_person_type per_person_types.system_person_type%TYPE := NULL;
468: v_dummy_field Varchar2(50) := NULL;
469: v_return_value varchar2(5);
470: --
471: l_proc varchar2(72) := g_package||'Is_Type_A_System_Type';