DBA Data[Home] [Help]

APPS.PER_CPA_BUS dependencies on PER_CPA_BUS

Line 1: Package Body per_cpa_bus as

1: Package Body per_cpa_bus as
2: /* $Header: pecparhi.pkb 115.4 2002/12/04 15:03:48 pkakar noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_cpa_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 118: if ( nvl(per_cpa_bus.g_cagr_api_param_id, hr_api.g_number)

114: ,p_argument => 'cagr_api_param_id'
115: ,p_argument_value => p_cagr_api_param_id
116: );
117: --
118: if ( nvl(per_cpa_bus.g_cagr_api_param_id, hr_api.g_number)
119: = p_cagr_api_param_id) then
120: --
121: -- The legislation code has already been found with a previous
122: -- call to this function. Just return the value in the global

Line 125: l_legislation_code := per_cpa_bus.g_legislation_code;

121: -- The legislation code has already been found with a previous
122: -- call to this function. Just return the value in the global
123: -- variable.
124: --
125: l_legislation_code := per_cpa_bus.g_legislation_code;
126: hr_utility.set_location(l_proc, 20);
127: else
128: --
129: -- The ID is different to the last call to this function

Line 149: per_cpa_bus.g_cagr_api_param_id := p_cagr_api_param_id;

145: -- Set the global variables so the values are
146: -- available for the next call to this function.
147: --
148: close csr_leg_code;
149: per_cpa_bus.g_cagr_api_param_id := p_cagr_api_param_id;
150: per_cpa_bus.g_legislation_code := l_legislation_code;
151: end if;
152: hr_utility.set_location(' Leaving:'|| l_proc, 40);
153: return l_legislation_code;

Line 150: per_cpa_bus.g_legislation_code := l_legislation_code;

146: -- available for the next call to this function.
147: --
148: close csr_leg_code;
149: per_cpa_bus.g_cagr_api_param_id := p_cagr_api_param_id;
150: per_cpa_bus.g_legislation_code := l_legislation_code;
151: end if;
152: hr_utility.set_location(' Leaving:'|| l_proc, 40);
153: return l_legislation_code;
154: end return_legislation_code;

Line 1099: per_cpa_bus.chk_cagr_api_id

1095: -- "-- CLIENT_INFO not set. No lookup validation or joins to HR_LOOKUPS."
1096: --
1097: -- Validate cagr_api_id
1098: --
1099: per_cpa_bus.chk_cagr_api_id
1100: (p_cagr_api_id => p_rec.cagr_api_id
1101: ,p_cagr_api_param_id => p_rec.cagr_api_param_id);
1102: --
1103: hr_utility.set_location(l_proc, 10);

Line 1107: per_cpa_bus.chk_display_name

1103: hr_utility.set_location(l_proc, 10);
1104: --
1105: -- Validate Display Name
1106: --
1107: per_cpa_bus.chk_display_name
1108: (p_cagr_api_id => p_rec.cagr_api_id
1109: ,p_cagr_api_param_id => p_rec.cagr_api_param_id
1110: ,p_display_name => p_rec.display_name);
1111: --

Line 1116: per_cpa_bus.chk_parameter_name

1112: hr_utility.set_location(l_proc, 20);
1113: --
1114: -- Validate Parameter Name
1115: --
1116: per_cpa_bus.chk_parameter_name
1117: (p_parameter_name => p_rec.parameter_name
1118: ,p_cagr_api_id => p_rec.cagr_api_id
1119: ,p_cagr_api_param_id => p_rec.cagr_api_param_id);
1120: --

Line 1129: per_cpa_bus.chk_column_type

1125: hr_utility.set_location(l_proc, 40);
1126: --
1127: -- Validate Column Type
1128: --
1129: per_cpa_bus.chk_column_type
1130: (p_column_type => p_rec.column_type
1131: ,p_cagr_api_param_id => p_rec.cagr_api_param_id
1132: ,p_effective_date => p_effective_date);
1133: --

Line 1138: per_cpa_bus.chk_column_size

1134: hr_utility.set_location(l_proc, 50);
1135: --
1136: -- Validate Column Size
1137: --
1138: per_cpa_bus.chk_column_size
1139: (p_column_size => p_rec.column_size);
1140: --
1141: hr_utility.set_location(l_proc,60);
1142: --

Line 1145: per_cpa_bus.chk_uom_parameter

1141: hr_utility.set_location(l_proc,60);
1142: --
1143: -- Validate uom parameter
1144: --
1145: per_cpa_bus.chk_uom_parameter
1146: (p_uom_parameter => p_rec.uom_parameter
1147: ,p_cagr_api_param_id => p_rec.cagr_api_param_id
1148: ,p_cagr_api_id => p_rec.cagr_api_id);
1149: --

Line 1154: per_cpa_bus.chk_uom_lookup

1150: hr_utility.set_location(l_proc,70);
1151: --
1152: -- Validate uom lookup
1153: --
1154: per_cpa_bus.chk_uom_lookup
1155: (p_cagr_api_param_id => p_rec.cagr_api_param_id
1156: ,p_uom_lookup => p_rec.uom_lookup
1157: ,p_default_uom => p_rec.default_uom
1158: ,p_effective_date => p_effective_date);

Line 1162: per_cpa_bus.chk_hidden

1158: ,p_effective_date => p_effective_date);
1159: --
1160: hr_utility.set_location(l_proc,80);
1161: --
1162: per_cpa_bus.chk_hidden
1163: (p_hidden => p_rec.hidden
1164: ,p_cagr_api_param_id => p_rec.cagr_api_param_id
1165: ,p_effective_date => p_effective_date);
1166: --

Line 1169: per_cpa_bus.chk_default_uom

1165: ,p_effective_date => p_effective_date);
1166: --
1167: hr_utility.set_location(l_proc,90);
1168: --
1169: per_cpa_bus.chk_default_uom
1170: (p_cagr_api_param_id => p_rec.cagr_api_param_id
1171: ,p_default_uom => p_rec.default_uom
1172: ,p_uom_lookup => p_rec.uom_lookup
1173: ,p_effective_date => p_effective_date);

Line 1201: per_cpa_bus.chk_display_name

1197: );
1198: --
1199: -- Validate Display Name
1200: --
1201: per_cpa_bus.chk_display_name
1202: (p_cagr_api_id => p_rec.cagr_api_id
1203: ,p_cagr_api_param_id => p_rec.cagr_api_param_id
1204: ,p_display_name => p_rec.display_name);
1205: --

Line 1210: per_cpa_bus.chk_parameter_name

1206: hr_utility.set_location(l_proc, 20);
1207: --
1208: -- Validate Parameter Name
1209: --
1210: per_cpa_bus.chk_parameter_name
1211: (p_parameter_name => p_rec.parameter_name
1212: ,p_cagr_api_id => p_rec.cagr_api_id
1213: ,p_cagr_api_param_id => p_rec.cagr_api_param_id);
1214: --

Line 1221: per_cpa_bus.chk_column_type

1217: -- Validate Column Type
1218: --
1219: hr_utility.set_location(l_proc, 40);
1220: --
1221: per_cpa_bus.chk_column_type
1222: (p_column_type => p_rec.column_type
1223: ,p_cagr_api_param_id => p_rec.cagr_api_param_id
1224: ,p_effective_date => p_effective_date);
1225: --

Line 1230: per_cpa_bus.chk_column_size

1226: -- Validate Column Size
1227: --
1228: hr_utility.set_location(l_proc, 50);
1229: --
1230: per_cpa_bus.chk_column_size
1231: (p_column_size => p_rec.column_size);
1232: --
1233: hr_utility.set_location(l_proc, 60);
1234: --

Line 1237: per_cpa_bus.chk_uom_parameter

1233: hr_utility.set_location(l_proc, 60);
1234: --
1235: -- Validate uom parameter
1236: --
1237: per_cpa_bus.chk_uom_parameter
1238: (p_uom_parameter => p_rec.uom_parameter
1239: ,p_cagr_api_param_id => p_rec.cagr_api_param_id
1240: ,p_cagr_api_id => p_rec.cagr_api_id);
1241: --

Line 1246: per_cpa_bus.chk_uom_lookup

1242: hr_utility.set_location(l_proc,70);
1243: --
1244: -- Validate uom lookup
1245: --
1246: per_cpa_bus.chk_uom_lookup
1247: (p_cagr_api_param_id => p_rec.cagr_api_param_id
1248: ,p_uom_lookup => p_rec.uom_lookup
1249: ,p_default_uom => p_rec.default_uom
1250: ,p_effective_date => p_effective_date);

Line 1254: per_cpa_bus.chk_hidden

1250: ,p_effective_date => p_effective_date);
1251: --
1252: hr_utility.set_location(l_proc,80);
1253: --
1254: per_cpa_bus.chk_hidden
1255: (p_hidden => p_rec.hidden
1256: ,p_cagr_api_param_id => p_rec.cagr_api_param_id
1257: ,p_effective_date => p_effective_date);
1258: --

Line 1261: per_cpa_bus.chk_default_uom

1257: ,p_effective_date => p_effective_date);
1258: --
1259: hr_utility.set_location(l_proc,90);
1260: --
1261: per_cpa_bus.chk_default_uom
1262: (p_cagr_api_param_id => p_rec.cagr_api_param_id
1263: ,p_default_uom => p_rec.default_uom
1264: ,p_uom_lookup => p_rec.uom_lookup
1265: ,p_effective_date => p_effective_date);

Line 1285: per_cpa_bus.chk_parameter_use

1281: hr_utility.set_location('Entering:'||l_proc, 5);
1282: --
1283: -- Check the parameter is not being referenced
1284: --
1285: per_cpa_bus.chk_parameter_use
1286: (p_cagr_api_param_id => p_rec.cagr_api_param_id);
1287: --
1288: hr_utility.set_location(' Leaving:'||l_proc, 10);
1289: End delete_validate;

Line 1291: end per_cpa_bus;

1287: --
1288: hr_utility.set_location(' Leaving:'||l_proc, 10);
1289: End delete_validate;
1290: --
1291: end per_cpa_bus;