DBA Data[Home] [Help]

APPS.PER_ECA_BUS dependencies on PER_ECA_BUS

Line 1: Package Body per_eca_bus as

1: Package Body per_eca_bus as
2: /* $Header: peecarhi.pkb 115.6 2002/12/05 10:25:53 pkakar noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' per_eca_bus.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_eca_bus.'; -- Global package name
9: --
10: -- The following two global variables are only to be
11: -- used by the return_legislation_code function.
12: --

Line 110: if ( nvl(per_eca_bus.g_election_candidate_id, hr_api.g_number)

106: ,p_argument => 'election_candidate_id'
107: ,p_argument_value => p_election_candidate_id
108: );
109: --
110: if ( nvl(per_eca_bus.g_election_candidate_id, hr_api.g_number)
111: = p_election_candidate_id) then
112: --
113: -- The legislation code has already been found with a previous
114: -- call to this function. Just return the value in the global

Line 117: l_legislation_code := per_eca_bus.g_legislation_code;

113: -- The legislation code has already been found with a previous
114: -- call to this function. Just return the value in the global
115: -- variable.
116: --
117: l_legislation_code := per_eca_bus.g_legislation_code;
118: hr_utility.set_location(l_proc, 20);
119: else
120: --
121: -- The ID is different to the last call to this function

Line 141: per_eca_bus.g_election_candidate_id:= p_election_candidate_id;

137: -- Set the global variables so the values are
138: -- available for the next call to this function.
139: --
140: close csr_leg_code;
141: per_eca_bus.g_election_candidate_id:= p_election_candidate_id;
142: per_eca_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;

Line 142: per_eca_bus.g_legislation_code := l_legislation_code;

138: -- available for the next call to this function.
139: --
140: close csr_leg_code;
141: per_eca_bus.g_election_candidate_id:= p_election_candidate_id;
142: per_eca_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;
146: end return_legislation_code;

Line 960: per_eca_bus.chk_person_id

956: hr_utility.set_location('Entering:'||l_proc, 5);
957: --
958: -- Validate PERSON_ID
959: --
960: per_eca_bus.chk_person_id
961: (p_person_id => p_rec.person_id
962: );
963:
964: --

Line 971: per_eca_bus.chk_election_id

967: hr_api.validate_bus_grp_id(p_rec.business_group_id);
968: --
969: -- Validate election_id
970: --
971: per_eca_bus.chk_election_id
972: (p_election_id => p_rec.election_id
973: );
974: --
975: -- Validate duplicate candidate for an election

Line 986: per_eca_bus.chk_role_id

982: --
983: -- Validate role_id
984: --
985: if p_rec.role_id is not null then
986: per_eca_bus.chk_role_id
987: (p_role_id => p_rec.role_id
988: );
989: end if;
990:

Line 993: per_eca_bus.chk_ddf(p_rec);

989: end if;
990:
991: --
992: -- Validate DFs
993: per_eca_bus.chk_ddf(p_rec);
994: --
995: -- Validate DDFs
996: per_eca_bus.chk_df(p_rec);
997: --

Line 996: per_eca_bus.chk_df(p_rec);

992: -- Validate DFs
993: per_eca_bus.chk_ddf(p_rec);
994: --
995: -- Validate DDFs
996: per_eca_bus.chk_df(p_rec);
997: --
998: hr_utility.set_location(' Leaving:'||l_proc, 10);
999: End insert_validate;
1000: --

Line 1016: per_eca_bus.chk_person_id

1012: hr_utility.set_location('Entering:'||l_proc, 5);
1013: --
1014: -- Validate PERSON_ID
1015: --
1016: per_eca_bus.chk_person_id
1017: (p_person_id => p_rec.person_id
1018: );
1019:
1020: --

Line 1027: per_eca_bus.chk_election_id

1023: hr_api.validate_bus_grp_id(p_rec.business_group_id);
1024: --
1025: -- Validate election_id
1026: --
1027: per_eca_bus.chk_election_id
1028: (p_election_id => p_rec.election_id
1029: );
1030: --
1031: -- Validate duplicate candidate for an election

Line 1042: per_eca_bus.chk_role_id

1038: --
1039: -- Validate role_id
1040: --
1041: if p_rec.role_id is not null then
1042: per_eca_bus.chk_role_id
1043: (p_role_id => p_rec.role_id
1044: );
1045: end if;
1046:

Line 1050: per_eca_bus.chk_df(p_rec);

1046:
1047: --
1048: --
1049: -- Validate DFs
1050: per_eca_bus.chk_df(p_rec);
1051: --
1052: -- Validate DDFs
1053: per_eca_bus.chk_ddf(p_rec);
1054: --

Line 1053: per_eca_bus.chk_ddf(p_rec);

1049: -- Validate DFs
1050: per_eca_bus.chk_df(p_rec);
1051: --
1052: -- Validate DDFs
1053: per_eca_bus.chk_ddf(p_rec);
1054: --
1055: hr_utility.set_location(' Leaving:'||l_proc, 10);
1056: End update_validate;
1057: end per_eca_bus;

Line 1057: end per_eca_bus;

1053: per_eca_bus.chk_ddf(p_rec);
1054: --
1055: hr_utility.set_location(' Leaving:'||l_proc, 10);
1056: End update_validate;
1057: end per_eca_bus;