DBA Data[Home] [Help]

APPS.PSB_WRHR_EXTRACT_PROCESS dependencies on PSB_HR_EXTRACT_DATA_PVT

Line 1069: PSB_HR_EXTRACT_DATA_PVT.Init(g_req_data_as_of_date);

1065: -- de by org
1066: l_extract_by_org := C_Data_Extract_Rec.extract_by_org;
1067: End Loop;
1068:
1069: PSB_HR_EXTRACT_DATA_PVT.Init(g_req_data_as_of_date);
1070:
1071: -- de by org
1072: if l_extract_by_org = 'Y' then
1073: PSB_WRHR_EXTRACT_PROCESS.INSERT_ORGANIZATIONS

Line 1164: PSB_HR_EXTRACT_DATA_PVT.Final_Process;

1160: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1161: raise FND_API.G_EXC_ERROR;
1162: end if;
1163:
1164: PSB_HR_EXTRACT_DATA_PVT.Final_Process;
1165:
1166: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
1167: p_data => l_msg_data );
1168: IF l_msg_count > 0 THEN

Line 1758: PSB_HR_EXTRACT_DATA_PVT.Init(l_effective_date);

1754: if (p_populate_interface_flag = 'Y') then
1755: if ((p_populate_interface_status is null) or (p_populate_interface_status <> 'C')) then
1756:
1757: l_effective_date := p_req_data_as_of_date;
1758: PSB_HR_EXTRACT_DATA_PVT.Init(l_effective_date);
1759:
1760: PSB_HR_EXTRACT_DATA_PVT.Get_Position_Information
1761: ( p_api_version => 1.0,
1762: p_init_msg_list => FND_API.G_TRUE,

Line 1760: PSB_HR_EXTRACT_DATA_PVT.Get_Position_Information

1756:
1757: l_effective_date := p_req_data_as_of_date;
1758: PSB_HR_EXTRACT_DATA_PVT.Init(l_effective_date);
1759:
1760: PSB_HR_EXTRACT_DATA_PVT.Get_Position_Information
1761: ( p_api_version => 1.0,
1762: p_init_msg_list => FND_API.G_TRUE,
1763: p_commit => FND_API.G_TRUE,
1764: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1849: PSB_HR_EXTRACT_DATA_PVT.Final_Process;

1845: end if;
1846: end if;
1847: end if;
1848:
1849: PSB_HR_EXTRACT_DATA_PVT.Final_Process;
1850:
1851: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
1852: p_data => l_msg_data );
1853: IF l_msg_count > 0 THEN

Line 1946: PSB_HR_EXTRACT_DATA_PVT.Init(l_effective_date);

1942:
1943: if (p_populate_interface_flag = 'Y') then
1944: if ((p_populate_interface_status is null) or (p_populate_interface_status <> 'C')) then
1945: l_effective_date := p_req_data_as_of_date;
1946: PSB_HR_EXTRACT_DATA_PVT.Init(l_effective_date);
1947:
1948: PSB_HR_EXTRACT_DATA_PVT.Get_Salary_Information
1949: ( p_api_version => 1.0,
1950: p_init_msg_list => FND_API.G_TRUE,

Line 1948: PSB_HR_EXTRACT_DATA_PVT.Get_Salary_Information

1944: if ((p_populate_interface_status is null) or (p_populate_interface_status <> 'C')) then
1945: l_effective_date := p_req_data_as_of_date;
1946: PSB_HR_EXTRACT_DATA_PVT.Init(l_effective_date);
1947:
1948: PSB_HR_EXTRACT_DATA_PVT.Get_Salary_Information
1949: ( p_api_version => 1.0,
1950: p_init_msg_list => FND_API.G_TRUE,
1951: p_commit => FND_API.G_TRUE,
1952: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2033: PSB_HR_EXTRACT_DATA_PVT.Final_Process;

2029: end if;
2030: end if;
2031:
2032:
2033: PSB_HR_EXTRACT_DATA_PVT.Final_Process;
2034: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
2035: p_data => l_msg_data );
2036: IF l_msg_count > 0 THEN
2037:

Line 2148: PSB_HR_EXTRACT_DATA_PVT.Init(l_effective_date);

2144:
2145: if (p_populate_interface_flag = 'Y') then
2146: if ((p_populate_interface_status is null) or (p_populate_interface_status <> 'C')) then
2147: l_effective_date := p_req_data_as_of_date;
2148: PSB_HR_EXTRACT_DATA_PVT.Init(l_effective_date);
2149:
2150: PSB_HR_EXTRACT_DATA_PVT.Get_Attributes
2151: ( p_api_version => 1.0,
2152: p_init_msg_list => FND_API.G_TRUE,

Line 2150: PSB_HR_EXTRACT_DATA_PVT.Get_Attributes

2146: if ((p_populate_interface_status is null) or (p_populate_interface_status <> 'C')) then
2147: l_effective_date := p_req_data_as_of_date;
2148: PSB_HR_EXTRACT_DATA_PVT.Init(l_effective_date);
2149:
2150: PSB_HR_EXTRACT_DATA_PVT.Get_Attributes
2151: ( p_api_version => 1.0,
2152: p_init_msg_list => FND_API.G_TRUE,
2153: p_commit => FND_API.G_TRUE,
2154: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2232: PSB_HR_EXTRACT_DATA_PVT.Final_Process;

2228: end if;
2229: end if;
2230:
2231:
2232: PSB_HR_EXTRACT_DATA_PVT.Final_Process;
2233: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
2234: p_data => l_msg_data );
2235: IF l_msg_count > 0 THEN
2236:

Line 2321: PSB_HR_EXTRACT_DATA_PVT.Init(l_effective_date);

2317:
2318: if (p_populate_interface_flag = 'Y') then
2319: if ((p_populate_interface_status is null) or (p_populate_interface_status <> 'C')) then
2320: l_effective_date := p_req_data_as_of_date;
2321: PSB_HR_EXTRACT_DATA_PVT.Init(l_effective_date);
2322:
2323: PSB_HR_EXTRACT_DATA_PVT.Get_Employee_Information
2324: ( p_api_version => 1.0,
2325: p_init_msg_list => FND_API.G_TRUE,

Line 2323: PSB_HR_EXTRACT_DATA_PVT.Get_Employee_Information

2319: if ((p_populate_interface_status is null) or (p_populate_interface_status <> 'C')) then
2320: l_effective_date := p_req_data_as_of_date;
2321: PSB_HR_EXTRACT_DATA_PVT.Init(l_effective_date);
2322:
2323: PSB_HR_EXTRACT_DATA_PVT.Get_Employee_Information
2324: ( p_api_version => 1.0,
2325: p_init_msg_list => FND_API.G_TRUE,
2326: p_commit => FND_API.G_TRUE,
2327: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2431: PSB_HR_EXTRACT_DATA_PVT.Final_Process;

2427: p_msg_data => l_msg_data);
2428:
2429: END IF;
2430:
2431: PSB_HR_EXTRACT_DATA_PVT.Final_Process;
2432: PSB_MESSAGE_S.Print_Success;
2433: retcode := 0 ;
2434: COMMIT WORK ;
2435:

Line 2520: PSB_HR_EXTRACT_DATA_PVT.Init(l_effective_date);

2516: if (p_populate_interface_flag = 'Y') then
2517: if ((p_populate_interface_status is null) or (p_populate_interface_status <> 'C')) then
2518:
2519: l_effective_date := p_req_data_as_of_date;
2520: PSB_HR_EXTRACT_DATA_PVT.Init(l_effective_date);
2521:
2522: PSB_HR_EXTRACT_DATA_PVT.Get_Costing_Information
2523: ( p_api_version => 1.0,
2524: p_init_msg_list => FND_API.G_TRUE,

Line 2522: PSB_HR_EXTRACT_DATA_PVT.Get_Costing_Information

2518:
2519: l_effective_date := p_req_data_as_of_date;
2520: PSB_HR_EXTRACT_DATA_PVT.Init(l_effective_date);
2521:
2522: PSB_HR_EXTRACT_DATA_PVT.Get_Costing_Information
2523: ( p_api_version => 1.0,
2524: p_init_msg_list => FND_API.G_TRUE,
2525: p_commit => FND_API.G_TRUE,
2526: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2629: PSB_HR_EXTRACT_DATA_PVT.Final_Process;

2625: p_msg_data => l_msg_data);
2626:
2627: END IF;
2628:
2629: PSB_HR_EXTRACT_DATA_PVT.Final_Process;
2630: PSB_MESSAGE_S.Print_Success;
2631: retcode := 0 ;
2632:
2633: COMMIT WORK;

Line 2702: PSB_HR_EXTRACT_DATA_PVT.Init(l_effective_date);

2698:
2699: if (p_populate_interface_flag = 'Y') then
2700: if ((p_populate_interface_status is null) or (p_populate_interface_status <> 'C')) then
2701: l_effective_date := p_req_data_as_of_date;
2702: PSB_HR_EXTRACT_DATA_PVT.Init(l_effective_date);
2703:
2704: PSB_HR_EXTRACT_DATA_PVT.Get_Employee_Attributes
2705: ( p_api_version => 1.0,
2706: p_init_msg_list => FND_API.G_TRUE,

Line 2704: PSB_HR_EXTRACT_DATA_PVT.Get_Employee_Attributes

2700: if ((p_populate_interface_status is null) or (p_populate_interface_status <> 'C')) then
2701: l_effective_date := p_req_data_as_of_date;
2702: PSB_HR_EXTRACT_DATA_PVT.Init(l_effective_date);
2703:
2704: PSB_HR_EXTRACT_DATA_PVT.Get_Employee_Attributes
2705: ( p_api_version => 1.0,
2706: p_init_msg_list => FND_API.G_TRUE,
2707: p_commit => FND_API.G_TRUE,
2708: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2806: PSB_HR_EXTRACT_DATA_PVT.Final_Process;

2802: p_msg_count => l_msg_count,
2803: p_msg_data => l_msg_data);
2804:
2805: END IF;
2806: PSB_HR_EXTRACT_DATA_PVT.Final_Process;
2807: PSB_MESSAGE_S.Print_Success;
2808: retcode := 0 ;
2809:
2810: COMMIT WORK;

Line 2875: PSB_HR_EXTRACT_DATA_PVT.Init(l_effective_date);

2871: BEGIN
2872:
2873: if p_validate_data_flag = 'Y' then
2874: l_effective_date := p_req_data_as_of_date;
2875: PSB_HR_EXTRACT_DATA_PVT.Init(l_effective_date);
2876:
2877: PSB_VALIDATE_DATA_EXTRACT_PVT.Data_Extract_Summary
2878: ( p_api_version => 1.0,
2879: p_init_msg_list => FND_API.G_FALSE,

Line 2953: PSB_HR_EXTRACT_DATA_PVT.Final_Process;

2949: --
2950: end if;
2951:
2952: end if;
2953: PSB_HR_EXTRACT_DATA_PVT.Final_Process;
2954: PSB_MESSAGE_S.Print_Success;
2955: retcode := 0 ;
2956:
2957:

Line 3151: --PSB_HR_EXTRACT_DATA_PVT.Final_Process;

3147:
3148: End loop;
3149: End loop;
3150:
3151: --PSB_HR_EXTRACT_DATA_PVT.Final_Process;
3152:
3153: /* Bug 3451357 Start */
3154: IF (lc_return_status = 'E') then
3155: l_return_status := FND_API.G_RET_STS_ERROR;