DBA Data[Home] [Help]

APPS.PER_PTU_DFF_MIG dependencies on FND_GLOBAL

Line 1609: p_attr_category,fnd_global.user_id,

1605: LAST_UPDATE_DATE,
1606: LAST_UPDATE_LOGIN)
1607: select p_person_id, p_business_group_id,
1608: p_request_id, p_error_desc,
1609: p_attr_category,fnd_global.user_id,
1610: sysdate, fnd_global.user_id,sysdate, fnd_global.login_id
1611: from dual;
1612: --
1613: END IF;

Line 1610: sysdate, fnd_global.user_id,sysdate, fnd_global.login_id

1606: LAST_UPDATE_LOGIN)
1607: select p_person_id, p_business_group_id,
1608: p_request_id, p_error_desc,
1609: p_attr_category,fnd_global.user_id,
1610: sysdate, fnd_global.user_id,sysdate, fnd_global.login_id
1611: from dual;
1612: --
1613: END IF;
1614: --

Line 2246: l_mig_rec.ATTRIBUTE_CATEGORY,fnd_global.user_id,

2242: LAST_UPDATE_DATE,
2243: LAST_UPDATE_LOGIN)
2244: select l_mig_rec.person_id, l_mig_rec.business_group_id,
2245: g_request_id, substr(l_error_code||l_error_desc,1,990),
2246: l_mig_rec.ATTRIBUTE_CATEGORY,fnd_global.user_id,
2247: sysdate, fnd_global.user_id,sysdate, fnd_global.login_id
2248: from dual;
2249: --
2250: END IF;

Line 2247: sysdate, fnd_global.user_id,sysdate, fnd_global.login_id

2243: LAST_UPDATE_LOGIN)
2244: select l_mig_rec.person_id, l_mig_rec.business_group_id,
2245: g_request_id, substr(l_error_code||l_error_desc,1,990),
2246: l_mig_rec.ATTRIBUTE_CATEGORY,fnd_global.user_id,
2247: sysdate, fnd_global.user_id,sysdate, fnd_global.login_id
2248: from dual;
2249: --
2250: END IF;
2251: --

Line 2324: null,fnd_global.user_id,

2320: LAST_UPDATE_DATE,
2321: LAST_UPDATE_LOGIN)
2322: select hr_api.g_number, l_business_group_id,
2323: g_request_id, 'FAILED',
2324: null,fnd_global.user_id,
2325: sysdate, fnd_global.user_id,sysdate,
2326: fnd_global.login_id
2327: from dual;
2328: --

Line 2325: sysdate, fnd_global.user_id,sysdate,

2321: LAST_UPDATE_LOGIN)
2322: select hr_api.g_number, l_business_group_id,
2323: g_request_id, 'FAILED',
2324: null,fnd_global.user_id,
2325: sysdate, fnd_global.user_id,sysdate,
2326: fnd_global.login_id
2327: from dual;
2328: --
2329: END IF;

Line 2326: fnd_global.login_id

2322: select hr_api.g_number, l_business_group_id,
2323: g_request_id, 'FAILED',
2324: null,fnd_global.user_id,
2325: sysdate, fnd_global.user_id,sysdate,
2326: fnd_global.login_id
2327: from dual;
2328: --
2329: END IF;
2330: --

Line 2353: null,fnd_global.user_id,

2349: LAST_UPDATE_DATE,
2350: LAST_UPDATE_LOGIN)
2351: select hr_api.g_number, l_business_group_id,
2352: g_request_id, 'SUCCESS',
2353: null,fnd_global.user_id,
2354: sysdate, fnd_global.user_id,sysdate,
2355: fnd_global.login_id
2356: from dual;
2357: --

Line 2354: sysdate, fnd_global.user_id,sysdate,

2350: LAST_UPDATE_LOGIN)
2351: select hr_api.g_number, l_business_group_id,
2352: g_request_id, 'SUCCESS',
2353: null,fnd_global.user_id,
2354: sysdate, fnd_global.user_id,sysdate,
2355: fnd_global.login_id
2356: from dual;
2357: --
2358: END IF;

Line 2355: fnd_global.login_id

2351: select hr_api.g_number, l_business_group_id,
2352: g_request_id, 'SUCCESS',
2353: null,fnd_global.user_id,
2354: sysdate, fnd_global.user_id,sysdate,
2355: fnd_global.login_id
2356: from dual;
2357: --
2358: END IF;
2359: END IF;

Line 2530: fnd_global.user_id,

2526: FDFC.DESCRIPTIVE_FLEX_CONTEXT_NAME,
2527: 'N', -- data mapping complete
2528: NULL, -- request id
2529: NULL, -- migration status
2530: fnd_global.user_id,
2531: sysdate,
2532: fnd_global.user_id,
2533: sysdate,
2534: fnd_global.login_id

Line 2532: fnd_global.user_id,

2528: NULL, -- request id
2529: NULL, -- migration status
2530: fnd_global.user_id,
2531: sysdate,
2532: fnd_global.user_id,
2533: sysdate,
2534: fnd_global.login_id
2535: FROM FND_DESCR_FLEX_CONTEXTS_VL FDFC,
2536: FND_DESCRIPTIVE_FLEXS_VL FDFV

Line 2534: fnd_global.login_id

2530: fnd_global.user_id,
2531: sysdate,
2532: fnd_global.user_id,
2533: sysdate,
2534: fnd_global.login_id
2535: FROM FND_DESCR_FLEX_CONTEXTS_VL FDFC,
2536: FND_DESCRIPTIVE_FLEXS_VL FDFV
2537: WHERE FDFC.DESCRIPTIVE_FLEXFIELD_NAME = FDFV.DESCRIPTIVE_FLEXFIELD_NAME
2538: AND FDFC.ENABLED_FLAG = 'Y'

Line 2566: fnd_global.user_id,

2562: NULL, -- PTU_DFF_CONTEXT_FIELD_CODE
2563: NULL, -- PTU_DFF_CONTEXT_FIELD_DESC
2564: NULL, -- PTU_DFF_ATTRIBUTE
2565: NULL, -- PTU_END_USER_COLUMN_NAME
2566: fnd_global.user_id,
2567: sysdate,
2568: fnd_global.user_id,
2569: sysdate,
2570: fnd_global.login_id

Line 2568: fnd_global.user_id,

2564: NULL, -- PTU_DFF_ATTRIBUTE
2565: NULL, -- PTU_END_USER_COLUMN_NAME
2566: fnd_global.user_id,
2567: sysdate,
2568: fnd_global.user_id,
2569: sysdate,
2570: fnd_global.login_id
2571: FROM FND_DESCR_FLEX_COL_USAGE_VL FDFU,
2572: FND_DESCR_FLEX_CONTEXTS_VL FDFC,

Line 2570: fnd_global.login_id

2566: fnd_global.user_id,
2567: sysdate,
2568: fnd_global.user_id,
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