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.PER_PTU_DFF_MIG dependencies on PER_ALL_PEOPLE_F

Line 6: TYPE MIG_TAB_TYPE IS TABLE OF PER_ALL_PEOPLE_F%ROWTYPE INDEX BY BINARY_INTEGER;

2: /* $Header: peptumig.pkb 120.0 2005/05/31 15:56:30 appldev noship $ */
3: --
4: -- Declare the TABLE TYPEs.
5: --
6: TYPE MIG_TAB_TYPE IS TABLE OF PER_ALL_PEOPLE_F%ROWTYPE INDEX BY BINARY_INTEGER;
7: --
8: -- ----------------------------------------------------------------------------
9: -- |---------------------------< initialization >-----------------------------|
10: -- ----------------------------------------------------------------------------

Line 283: FROM PER_ALL_PEOPLE_F PPF

279: --
280: -- Run for all records.
281: --
282: sqlstr := 'SELECT DISTINCT PERSON_ID
283: FROM PER_ALL_PEOPLE_F PPF
284: ,pay_payroll_actions ppa
285: WHERE ppa.payroll_action_id = :payroll_action_id
286: AND PPF.BUSINESS_GROUP_ID
287: = NVL(pay_core_utils.get_parameter(''BUSINESS_GROUP_ID'', ppa.legislative_parameters), PPF.BUSINESS_GROUP_ID)

Line 325: FROM PER_ALL_PEOPLE_F PPF

321: -- migration business groups.
322: --
323: CURSOR csr_process_all(p_business_group_id number) IS
324: SELECT DISTINCT PPF.PERSON_ID PERSON_ID
325: FROM PER_ALL_PEOPLE_F PPF
326: ,pay_payroll_actions ppa
327: WHERE PPF.PERSON_ID BETWEEN STPERSON AND ENDPERSON
328: AND ppa.payroll_action_id = pactid
329: AND ppf.business_group_id = nvl(p_business_group_id,ppf.business_group_id)

Line 405: object_type => 'PER_ALL_PEOPLE_F');

401: pactid => pactid,
402: chunk => chunk,
403: greid => null,
404: object_id => per_rec.person_id,
405: object_type => 'PER_ALL_PEOPLE_F');
406: END LOOP;
407: --
408: ELSIF (l_report_mode = 'FAILED') THEN
409: --

Line 428: object_type => 'PER_ALL_PEOPLE_F');

424: pactid => pactid,
425: chunk => chunk,
426: greid => null,
427: object_id => per_rec.person_id,
428: object_type => 'PER_ALL_PEOPLE_F');
429: END LOOP;
430: --
431: END IF;
432: --

Line 446: FUNCTION RETRIVE_MAPPING(p_mig_rec PER_ALL_PEOPLE_F%ROWTYPE,

442: -- For composite person contexts like EMP_APL, if p_mig_rec attribute_category
443: -- is EMP, then we need to send the values of only PTU_ATTRIBUTES which are
444: -- defined for basic EMP Attribute in the mapping form.
445: --
446: FUNCTION RETRIVE_MAPPING(p_mig_rec PER_ALL_PEOPLE_F%ROWTYPE,
447: p_person_rec_context varchar2)
448: RETURN PER_PERSON_TYPE_USAGES_F%ROWTYPE
449: IS
450: --

Line 456: TYPE PER_DATA_TABLE_TYPE IS TABLE OF PER_ALL_PEOPLE_F.ATTRIBUTE1%TYPE

452: INDEX BY BINARY_INTEGER;
453: --
454: l_attr_table ATTR_TABLE_TYPE;
455: --
456: TYPE PER_DATA_TABLE_TYPE IS TABLE OF PER_ALL_PEOPLE_F.ATTRIBUTE1%TYPE
457: INDEX BY BINARY_INTEGER;
458: --
459: l_per_data_table PER_DATA_TABLE_TYPE;
460: --

Line 723: l_sub_per_rec PER_ALL_PEOPLE_F%ROWTYPE;

719: AND ml.ptu_dff_context_field_code <> 'Global Data Elements';
720: --
721: j number := 1;
722: MIG_TAB_NEW MIG_TAB_TYPE;
723: l_sub_per_rec PER_ALL_PEOPLE_F%ROWTYPE;
724: --
725: l_dff_attr_str varchar2(2000);
726: --
727: BEGIN

Line 1168: p_mig_rec PER_ALL_PEOPLE_F%rowtype; -- same as table type MIG_TAB_TYPE

1164: l_object_version_number number;
1165: --
1166: -- record types.
1167: --
1168: p_mig_rec PER_ALL_PEOPLE_F%rowtype; -- same as table type MIG_TAB_TYPE
1169: ptu_rec PER_PERSON_TYPE_USAGES_F%rowtype;
1170: l_ptu_attrs_data_rec PER_PERSON_TYPE_USAGES_F%rowtype;
1171: mig_tab_new MIG_TAB_TYPE;
1172: --

Line 1672: l_full_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;

1668: l_count NUMBER :=1;
1669: l_error_desc VARCHAR2(1000);
1670: l_error_code VARCHAR2(1000);
1671: l_report_mode varchar2(30);
1672: l_full_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;
1673: --
1674: -- Record Type
1675: --
1676: l_mig_rec PER_ALL_PEOPLE_F%ROWTYPE;

Line 1676: l_mig_rec PER_ALL_PEOPLE_F%ROWTYPE;

1672: l_full_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;
1673: --
1674: -- Record Type
1675: --
1676: l_mig_rec PER_ALL_PEOPLE_F%ROWTYPE;
1677: l_mig_rec_null PER_ALL_PEOPLE_F%ROWTYPE;
1678: --
1679: -- Table Type
1680: --

Line 1677: l_mig_rec_null PER_ALL_PEOPLE_F%ROWTYPE;

1673: --
1674: -- Record Type
1675: --
1676: l_mig_rec PER_ALL_PEOPLE_F%ROWTYPE;
1677: l_mig_rec_null PER_ALL_PEOPLE_F%ROWTYPE;
1678: --
1679: -- Table Type
1680: --
1681: l_mig_tab MIG_TAB_TYPE;

Line 1700: FROM PER_ALL_PEOPLE_F PPF

1696: ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,
1697: ATTRIBUTE16,ATTRIBUTE17,ATTRIBUTE18,ATTRIBUTE19,ATTRIBUTE20,
1698: ATTRIBUTE21,ATTRIBUTE22,ATTRIBUTE23,ATTRIBUTE24,ATTRIBUTE25,
1699: ATTRIBUTE26,ATTRIBUTE27,ATTRIBUTE28,ATTRIBUTE29,ATTRIBUTE30
1700: FROM PER_ALL_PEOPLE_F PPF
1701: WHERE PPF.ATTRIBUTE_CATEGORY IN
1702: (SELECT H.PER_DFF_CONTEXT_FIELD_CODE
1703: FROM PER_PTU_DFF_MAPPING_HEADERS H
1704: WHERE H.DATA_MAPPING_COMPLETE = 'Y'

Line 2424: UPDATE PER_ALL_PEOPLE_F papf

2420: --
2421: -- Update the migrated person DFF attributes to null, IF attribute exist in the
2422: -- migrated attribute string.
2423: --
2424: UPDATE PER_ALL_PEOPLE_F papf
2425: SET papf.ATTRIBUTE_CATEGORY = ''
2426: ,papf.ATTRIBUTE1 = DECODE (INSTR (l_dff_attr_str , 'ATTRIBUTE1,'), 0, papf.ATTRIBUTE1, '')
2427: ,papf.ATTRIBUTE2 = DECODE (INSTR (l_dff_attr_str , 'ATTRIBUTE2,'), 0, papf.ATTRIBUTE2, '')
2428: ,papf.ATTRIBUTE3 = DECODE (INSTR (l_dff_attr_str , 'ATTRIBUTE3,'), 0, papf.ATTRIBUTE3, '')