APPS.PER_PTU_DFF_MIG dependencies on PER_PTU_DFF_MAPPING_HEADERS

Line 179: FROM PER_PTU_DFF_MAPPING_HEADERS;

175: -- Check whether the mapping tables have the mappings data.
176: --
177: SELECT COUNT(*)
178: INTO l_count1
179: FROM PER_PTU_DFF_MAPPING_HEADERS;
180: --
181: -- Validate that mapping is complete.
182: --
183: SELECT COUNT(*)

Line 185: FROM PER_PTU_DFF_MAPPING_HEADERS

181: -- Validate that mapping is complete.
182: --
183: SELECT COUNT(*)
184: INTO l_count2
185: FROM PER_PTU_DFF_MAPPING_HEADERS
186: WHERE DATA_MAPPING_COMPLETE = 'N';
187: /*
188: --
189: -- check if all the contexts are migrated.

Line 193: FROM PER_PTU_DFF_MAPPING_HEADERS

189: -- check if all the contexts are migrated.
190: --
191: SELECT COUNT(*)
192: INTO l_count3
193: FROM PER_PTU_DFF_MAPPING_HEADERS
194: WHERE nvl(MIGRATION_STATUS,'PENDING') = 'COMPLETE';
195: */
196: --
197: IF l_prev_mig_successful = 'Y' THEN

Line 472: FROM PER_PTU_DFF_MAPPING_HEADERS H,

468: L.PER_DFF_ATTRIBUTE,
469: L.PTU_DFF_CONTEXT_FIELD_CODE,
470: L.PTU_DFF_ATTRIBUTE,
471: TO_NUMBER (SUBSTR (L.PER_DFF_ATTRIBUTE,10)) ATTRIBUTE_NUM
472: FROM PER_PTU_DFF_MAPPING_HEADERS H,
473: PER_PTU_DFF_MAPPING_LINES L
474: WHERE H.MAPPING_HEADER_ID = L.MAPPING_HEADER_ID
475: AND H.DATA_MAPPING_COMPLETE = 'Y'
476: AND H.PER_DFF_CONTEXT_FIELD_CODE =

Line 679: PER_PTU_DFF_MAPPING_HEADERS H

675: BEGIN
676: --
677: FOR attr_rec IN (SELECT L.PER_DFF_ATTRIBUTE
678: FROM PER_PTU_DFF_MAPPING_LINES L,
679: PER_PTU_DFF_MAPPING_HEADERS H
680: WHERE H.MAPPING_HEADER_ID = L.MAPPING_HEADER_ID
681: AND H.DATA_MAPPING_COMPLETE = 'Y'
682: AND L.PTU_DFF_CONTEXT_FIELD_CODE in
683: (P_PTU_CONTEXT,'Global Data Elements')

Line 715: FROM per_ptu_dff_mapping_headers mh

711: IS
712: --
713: CURSOR csr_basic_ptu_data(p_context varchar2) IS
714: SELECT distinct ptu_dff_context_field_code
715: FROM per_ptu_dff_mapping_headers mh
716: ,per_ptu_dff_mapping_lines ml
717: WHERE mh.mapping_header_id = ml.mapping_header_id
718: AND mh.per_dff_context_field_code = p_context
719: AND ml.ptu_dff_context_field_code <> 'Global Data Elements';

Line 1072: FROM PER_PTU_DFF_MAPPING_HEADERS

1068: BEGIN
1069: --
1070: SELECT PER_DFF_CONTEXT_FIELD_NAME
1071: INTO l_context_field
1072: FROM PER_PTU_DFF_MAPPING_HEADERS
1073: WHERE PER_DFF_CONTEXT_FIELD_CODE = p_context;
1074: --
1075: IF l_context_field = 'SYSTEM_PERSON_TYPE' THEN
1076: --

Line 1193: FROM PER_PTU_DFF_MAPPING_HEADERS

1189: -- In the mapping header table check the context field used by Person DFF.
1190: -- ********** check this from the FND tables????????
1191: SELECT PER_DFF_CONTEXT_FIELD_NAME
1192: INTO l_context_field
1193: FROM PER_PTU_DFF_MAPPING_HEADERS
1194: WHERE PER_DFF_CONTEXT_FIELD_CODE = P_CONTEXT;
1195: --
1196: IF is_context_composite(p_context) THEN
1197: --

Line 1555: PER_PTU_DFF_MAPPING_HEADERS H

1551: BEGIN
1552: --
1553: FOR attr_rec IN (SELECT L.PER_DFF_ATTRIBUTE
1554: FROM PER_PTU_DFF_MAPPING_LINES L,
1555: PER_PTU_DFF_MAPPING_HEADERS H
1556: WHERE H.MAPPING_HEADER_ID = L.MAPPING_HEADER_ID
1557: AND H.DATA_MAPPING_COMPLETE = 'Y'
1558: AND H.PER_DFF_CONTEXT_FIELD_CODE IN
1559: (P_CONTEXT,'Global Data Elements'))

Line 1703: FROM PER_PTU_DFF_MAPPING_HEADERS H

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'
1705: AND EXISTS
1706: (SELECT 1
1707: FROM PER_PTU_DFF_MAPPING_LINES L

Line 2263: -- PER_PTU_DFF_MAPPING_HEADERS.

2259: -- |--------------------------< deinitialization >----------------------------|
2260: -- ----------------------------------------------------------------------------
2261: --
2262: -- This procedure is used to update the migration_status in table
2263: -- PER_PTU_DFF_MAPPING_HEADERS.
2264: -- Then we call the standard deinit procedure pay_archive.standard_deinit.
2265: --
2266: PROCEDURE deinitialization(pactid in number) IS
2267: --

Line 2366: UPDATE PER_PTU_DFF_MAPPING_HEADERS HEADER

2362: --
2363:
2364: --
2365: /*
2366: UPDATE PER_PTU_DFF_MAPPING_HEADERS HEADER
2367: SET HEADER.MIGRATION_STATUS = 'COMPLETE'
2368: ,HEADER.REQUEST_ID = g_request_id
2369: WHERE HEADER.DATA_MAPPING_COMPLETE = 'Y'
2370: AND NOT EXISTS

Line 2402: FROM PER_PTU_DFF_MAPPING_HEADERS

2398: -- No check against it.
2399: --
2400: CURSOR c_per_context IS
2401: SELECT PER_DFF_CONTEXT_FIELD_CODE
2402: FROM PER_PTU_DFF_MAPPING_HEADERS
2403: WHERE PER_DFF_CONTEXT_FIELD_CODE = DECODE (p_purge_scope, 'ALL',
2404: PER_DFF_CONTEXT_FIELD_CODE, p_context);
2405: --
2406: --

Line 2487: FROM PER_PTU_DFF_MAPPING_HEADERS

2483: SELECT 'Y'
2484: FROM DUAL
2485: WHERE EXISTS
2486: (SELECT NULL
2487: FROM PER_PTU_DFF_MAPPING_HEADERS
2488: );
2489: --
2490: l_populated varchar2(1);
2491: --

Line 2510: INSERT INTO PER_PTU_DFF_MAPPING_HEADERS

2506: CLOSE csr_already_populated;
2507: --
2508: -- Populate Header table which holds the context details.
2509: --
2510: INSERT INTO PER_PTU_DFF_MAPPING_HEADERS
2511: ( MAPPING_HEADER_ID,
2512: PER_DFF_CONTEXT_FIELD_CODE,
2513: PER_DFF_CONTEXT_FIELD_NAME,
2514: PER_DFF_CONTEXT_FIELD_DESC,

Line 2523: SELECT PER_PTU_DFF_MAPPING_HEADERS_S.NEXTVAL,

2519: CREATION_DATE,
2520: LAST_UPDATED_BY,
2521: LAST_UPDATE_DATE,
2522: LAST_UPDATE_LOGIN )
2523: SELECT PER_PTU_DFF_MAPPING_HEADERS_S.NEXTVAL,
2524: FDFC.DESCRIPTIVE_FLEX_CONTEXT_CODE,
2525: FDFV.DEFAULT_CONTEXT_FIELD_NAME,
2526: FDFC.DESCRIPTIVE_FLEX_CONTEXT_NAME,
2527: 'N', -- data mapping complete

Line 2573: PER_PTU_DFF_MAPPING_HEADERS MH

2569: sysdate,
2570: fnd_global.login_id
2571: FROM FND_DESCR_FLEX_COL_USAGE_VL FDFU,
2572: FND_DESCR_FLEX_CONTEXTS_VL FDFC,
2573: PER_PTU_DFF_MAPPING_HEADERS MH
2574: WHERE FDFU.DESCRIPTIVE_FLEXFIELD_NAME = FDFC.DESCRIPTIVE_FLEXFIELD_NAME
2575: AND FDFU.DESCRIPTIVE_FLEX_CONTEXT_CODE = FDFC.DESCRIPTIVE_FLEX_CONTEXT_CODE
2576: AND FDFC.ENABLED_FLAG = 'Y'
2577: AND FDFU.ENABLED_FLAG = 'Y'