DBA Data[Home] [Help]

APPS.IRC_SEARCH_CRITERIA_API dependencies on IRC_SEARCH_CRITERIA

Line 1: Package Body IRC_SEARCH_CRITERIA_API as

1: Package Body IRC_SEARCH_CRITERIA_API as
2: /* $Header: iriscapi.pkb 120.0 2005/07/26 15:10:47 mbocutt noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' IRC_SEARCH_CRITERIA_API.';

2: /* $Header: iriscapi.pkb 120.0 2005/07/26 15:10:47 mbocutt noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' IRC_SEARCH_CRITERIA_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< CREATE_SAVED_SEARCH >--------------------------|
10: -- ----------------------------------------------------------------------------

Line 113: l_object_version_number irc_search_criteria.object_version_number%TYPE;

109: --
110:
111: l_proc varchar2(72) := g_package||'CREATE_SAVED_SEARCH';
112: l_effective_date date;
113: l_object_version_number irc_search_criteria.object_version_number%TYPE;
114: l_search_criteria_id irc_search_criteria.search_criteria_id%TYPE;
115:
116: begin
117: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 114: l_search_criteria_id irc_search_criteria.search_criteria_id%TYPE;

110:
111: l_proc varchar2(72) := g_package||'CREATE_SAVED_SEARCH';
112: l_effective_date date;
113: l_object_version_number irc_search_criteria.object_version_number%TYPE;
114: l_search_criteria_id irc_search_criteria.search_criteria_id%TYPE;
115:
116: begin
117: hr_utility.set_location('Entering:'|| l_proc, 10);
118: --

Line 130: IRC_SEARCH_CRITERIA_BK1.CREATE_SAVED_SEARCH_B

126: --
127: -- Call Before Process User Hook
128: --
129: begin
130: IRC_SEARCH_CRITERIA_BK1.CREATE_SAVED_SEARCH_B
131: (p_effective_date => l_effective_date
132: ,p_person_id => p_person_id
133: ,p_search_name => p_search_name
134: ,p_location => p_location

Line 333: IRC_SEARCH_CRITERIA_BK1.CREATE_SAVED_SEARCH_A

329: --
330: -- Call After Process User Hook
331: --
332: begin
333: IRC_SEARCH_CRITERIA_BK1.CREATE_SAVED_SEARCH_A
334: (p_effective_date => l_effective_date
335: ,p_person_id => p_person_id
336: ,p_search_name => p_search_name
337: ,p_location => p_location

Line 578: l_object_version_number irc_search_criteria.object_version_number%TYPE

574: --
575:
576: l_proc varchar2(72) := g_package||'UPDATE_SAVED_SEARCH';
577: l_effective_date date;
578: l_object_version_number irc_search_criteria.object_version_number%TYPE
579: := p_object_version_number;
580:
581: begin
582: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 595: IRC_SEARCH_CRITERIA_BK2.UPDATE_SAVED_SEARCH_B

591: --
592: -- Call Before Process User Hook
593: --
594: begin
595: IRC_SEARCH_CRITERIA_BK2.UPDATE_SAVED_SEARCH_B
596: (p_effective_date => l_effective_date
597: ,p_search_criteria_id => p_search_criteria_id
598: ,p_person_id => p_person_id
599: ,p_search_name => p_search_name

Line 800: IRC_SEARCH_CRITERIA_BK2.UPDATE_SAVED_SEARCH_A

796: --
797: -- Call After Process User Hook
798: --
799: begin
800: IRC_SEARCH_CRITERIA_BK2.UPDATE_SAVED_SEARCH_A
801: (p_effective_date => l_effective_date
802: ,p_search_criteria_id => p_search_criteria_id
803: ,p_person_id => p_person_id
804: ,p_search_name => p_search_name

Line 970: IRC_SEARCH_CRITERIA_BK3.DELETE_SAVED_SEARCH_B

966: --
967: -- Call Before Process User Hook
968: --
969: begin
970: IRC_SEARCH_CRITERIA_BK3.DELETE_SAVED_SEARCH_B
971: (p_search_criteria_id => p_search_criteria_id
972: ,p_object_version_number => p_object_version_number
973: );
974: exception

Line 994: IRC_SEARCH_CRITERIA_BK3.DELETE_SAVED_SEARCH_A

990: --
991: -- Call After Process User Hook
992: --
993: begin
994: IRC_SEARCH_CRITERIA_BK3.DELETE_SAVED_SEARCH_A
995: (p_search_criteria_id => p_search_criteria_id
996: ,p_object_version_number => p_object_version_number
997: );
998: exception

Line 1131: l_object_version_number irc_search_criteria.object_version_number%TYPE;

1127: -- Declare cursors and local variables
1128: --
1129:
1130: l_proc varchar2(72) := g_package||'CREATE_VACANCY_CRITERIA';
1131: l_object_version_number irc_search_criteria.object_version_number%TYPE;
1132: l_search_criteria_id irc_search_criteria.search_criteria_id%TYPE;
1133: l_effective_date date;
1134: begin
1135: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1132: l_search_criteria_id irc_search_criteria.search_criteria_id%TYPE;

1128: --
1129:
1130: l_proc varchar2(72) := g_package||'CREATE_VACANCY_CRITERIA';
1131: l_object_version_number irc_search_criteria.object_version_number%TYPE;
1132: l_search_criteria_id irc_search_criteria.search_criteria_id%TYPE;
1133: l_effective_date date;
1134: begin
1135: hr_utility.set_location('Entering:'|| l_proc, 10);
1136: --

Line 1148: IRC_SEARCH_CRITERIA_BK4.CREATE_VACANCY_CRITERIA_B

1144: --
1145: -- Call Before Process User Hook
1146: --
1147: begin
1148: IRC_SEARCH_CRITERIA_BK4.CREATE_VACANCY_CRITERIA_B
1149: (p_vacancy_id => p_vacancy_id
1150: ,p_effective_date => l_effective_date
1151: ,p_location => p_location
1152: ,p_contractor => p_contractor

Line 1329: IRC_SEARCH_CRITERIA_BK4.CREATE_VACANCY_CRITERIA_A

1325: --
1326: -- Call After Process User Hook
1327: --
1328: begin
1329: IRC_SEARCH_CRITERIA_BK4.CREATE_VACANCY_CRITERIA_A
1330: (p_vacancy_id => p_vacancy_id
1331: ,p_effective_date => l_effective_date
1332: ,p_location => p_location
1333: ,p_contractor => p_contractor

Line 1551: l_object_version_number irc_search_criteria.object_version_number%TYPE

1547: -- Declare cursors and local variables
1548: --
1549:
1550: l_proc varchar2(72) := g_package||'UPDATE_VACANCY_CRITERIA';
1551: l_object_version_number irc_search_criteria.object_version_number%TYPE
1552: := p_object_version_number;
1553: l_effective_date date;
1554:
1555: begin

Line 1569: IRC_SEARCH_CRITERIA_BK5.UPDATE_VACANCY_CRITERIA_B

1565: --
1566: -- Call Before Process User Hook
1567: --
1568: begin
1569: IRC_SEARCH_CRITERIA_BK5.UPDATE_VACANCY_CRITERIA_B
1570: (p_vacancy_id => p_vacancy_id
1571: ,p_search_criteria_id => p_search_criteria_id
1572: ,p_effective_date => l_effective_date
1573: ,p_location => p_location

Line 1752: IRC_SEARCH_CRITERIA_BK5.UPDATE_VACANCY_CRITERIA_A

1748: --
1749: -- Call After Process User Hook
1750: --
1751: begin
1752: IRC_SEARCH_CRITERIA_BK5.UPDATE_VACANCY_CRITERIA_A
1753: (p_vacancy_id => p_vacancy_id
1754: ,p_search_criteria_id => p_search_criteria_id
1755: ,p_effective_date => l_effective_date
1756: ,p_location => p_location

Line 1911: IRC_SEARCH_CRITERIA_BK6.DELETE_VACANCY_CRITERIA_B

1907: --
1908: -- Call Before Process User Hook
1909: --
1910: begin
1911: IRC_SEARCH_CRITERIA_BK6.DELETE_VACANCY_CRITERIA_B
1912: (p_search_criteria_id => p_search_criteria_id
1913: ,p_object_version_number => p_object_version_number
1914: );
1915: exception

Line 1935: IRC_SEARCH_CRITERIA_BK6.DELETE_VACANCY_CRITERIA_A

1931: --
1932: -- Call After Process User Hook
1933: --
1934: begin
1935: IRC_SEARCH_CRITERIA_BK6.DELETE_VACANCY_CRITERIA_A
1936: (p_search_criteria_id => p_search_criteria_id
1937: ,p_object_version_number => p_object_version_number
1938: );
1939: exception

Line 2082: l_object_version_number irc_search_criteria.object_version_number%TYPE;

2078: --
2079:
2080: l_proc varchar2(72) := g_package||'CREATE_WORK_CHOICES';
2081: l_effective_date date;
2082: l_object_version_number irc_search_criteria.object_version_number%TYPE;
2083: l_search_criteria_id irc_search_criteria.search_criteria_id%TYPE;
2084:
2085: begin
2086: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2083: l_search_criteria_id irc_search_criteria.search_criteria_id%TYPE;

2079:
2080: l_proc varchar2(72) := g_package||'CREATE_WORK_CHOICES';
2081: l_effective_date date;
2082: l_object_version_number irc_search_criteria.object_version_number%TYPE;
2083: l_search_criteria_id irc_search_criteria.search_criteria_id%TYPE;
2084:
2085: begin
2086: hr_utility.set_location('Entering:'|| l_proc, 10);
2087: --

Line 2099: IRC_SEARCH_CRITERIA_BK7.CREATE_WORK_CHOICES_B

2095: --
2096: -- Call Before Process User Hook
2097: --
2098: begin
2099: IRC_SEARCH_CRITERIA_BK7.CREATE_WORK_CHOICES_B
2100: (p_effective_date => l_effective_date
2101: ,p_person_id => p_person_id
2102: ,p_location => p_location
2103: ,p_distance_to_location => p_distance_to_location

Line 2297: IRC_SEARCH_CRITERIA_BK7.CREATE_WORK_CHOICES_A

2293: --
2294: -- Call After Process User Hook
2295: --
2296: begin
2297: IRC_SEARCH_CRITERIA_BK7.CREATE_WORK_CHOICES_A
2298: (p_effective_date => l_effective_date
2299: ,p_person_id => p_person_id
2300: ,p_location => p_location
2301: ,p_distance_to_location => p_distance_to_location

Line 2535: l_object_version_number irc_search_criteria.object_version_number%TYPE

2531: --
2532:
2533: l_proc varchar2(72) := g_package||'UPDATE_WORK_CHOICES';
2534: l_effective_date date;
2535: l_object_version_number irc_search_criteria.object_version_number%TYPE
2536: := p_object_version_number;
2537:
2538: begin
2539: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2552: IRC_SEARCH_CRITERIA_BK8.UPDATE_WORK_CHOICES_B

2548: --
2549: -- Call Before Process User Hook
2550: --
2551: begin
2552: IRC_SEARCH_CRITERIA_BK8.UPDATE_WORK_CHOICES_B
2553: (p_effective_date => l_effective_date
2554: ,p_search_criteria_id => p_search_criteria_id
2555: ,p_location => p_location
2556: ,p_distance_to_location => p_distance_to_location

Line 2749: IRC_SEARCH_CRITERIA_BK8.UPDATE_WORK_CHOICES_A

2745: --
2746: -- Call After Process User Hook
2747: --
2748: begin
2749: IRC_SEARCH_CRITERIA_BK8.UPDATE_WORK_CHOICES_A
2750: (p_effective_date => l_effective_date
2751: ,p_search_criteria_id => p_search_criteria_id
2752: ,p_location => p_location
2753: ,p_distance_to_location => p_distance_to_location

Line 2915: IRC_SEARCH_CRITERIA_BK9.DELETE_WORK_CHOICES_B

2911: --
2912: -- Call Before Process User Hook
2913: --
2914: begin
2915: IRC_SEARCH_CRITERIA_BK9.DELETE_WORK_CHOICES_B
2916: (p_search_criteria_id => p_search_criteria_id
2917: ,p_object_version_number => p_object_version_number
2918: );
2919: exception

Line 2939: IRC_SEARCH_CRITERIA_BK9.DELETE_WORK_CHOICES_A

2935: --
2936: -- Call After Process User Hook
2937: --
2938: begin
2939: IRC_SEARCH_CRITERIA_BK9.DELETE_WORK_CHOICES_A
2940: (p_search_criteria_id => p_search_criteria_id
2941: ,p_object_version_number => p_object_version_number
2942: );
2943: exception

Line 2983: end IRC_SEARCH_CRITERIA_API;

2979: hr_utility.set_location(' Leaving:'||l_proc, 90);
2980: raise;
2981: end DELETE_WORK_CHOICES;
2982: --
2983: end IRC_SEARCH_CRITERIA_API;