eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_LOADER_UTILS_PKG dependencies on PAY_ELEMENT_CLASS_USAGES_F

Line 1193: -- This procedure uploads a single row into pay_element_class_usages_f table.

1189: -- |------------------------------< load_ecu_row >----------------------------|
1190: -- ----------------------------------------------------------------------------
1191: --
1192: -- Description:
1193: -- This procedure uploads a single row into pay_element_class_usages_f table.
1194: --
1195: -- ----------------------------------------------------------------------------
1196: PROCEDURE load_ecu_row(
1197: p_usage_id in number,

Line 1216: l_business_group_id PAY_ELEMENT_CLASS_USAGES_F.BUSINESS_GROUP_ID%TYPE;

1212: p_eof_number in number
1213: ) is
1214: --
1215: l_proc varchar2(72) := g_package||'load_ecu_row';
1216: l_business_group_id PAY_ELEMENT_CLASS_USAGES_F.BUSINESS_GROUP_ID%TYPE;
1217: l_rec PAY_ECU_SHD.G_REC_TYPE;
1218: l_element_class_usage_id PAY_ELEMENT_CLASS_USAGES_F.ELEMENT_CLASS_USAGE_ID%TYPE;
1219: l_run_type_id PAY_ELEMENT_CLASS_USAGES_F.RUN_TYPE_ID%TYPE;
1220: l_classification_id PAY_ELEMENT_CLASS_USAGES_F.CLASSIFICATION_ID%TYPE;

Line 1218: l_element_class_usage_id PAY_ELEMENT_CLASS_USAGES_F.ELEMENT_CLASS_USAGE_ID%TYPE;

1214: --
1215: l_proc varchar2(72) := g_package||'load_ecu_row';
1216: l_business_group_id PAY_ELEMENT_CLASS_USAGES_F.BUSINESS_GROUP_ID%TYPE;
1217: l_rec PAY_ECU_SHD.G_REC_TYPE;
1218: l_element_class_usage_id PAY_ELEMENT_CLASS_USAGES_F.ELEMENT_CLASS_USAGE_ID%TYPE;
1219: l_run_type_id PAY_ELEMENT_CLASS_USAGES_F.RUN_TYPE_ID%TYPE;
1220: l_classification_id PAY_ELEMENT_CLASS_USAGES_F.CLASSIFICATION_ID%TYPE;
1221: l_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
1222: --

Line 1219: l_run_type_id PAY_ELEMENT_CLASS_USAGES_F.RUN_TYPE_ID%TYPE;

1215: l_proc varchar2(72) := g_package||'load_ecu_row';
1216: l_business_group_id PAY_ELEMENT_CLASS_USAGES_F.BUSINESS_GROUP_ID%TYPE;
1217: l_rec PAY_ECU_SHD.G_REC_TYPE;
1218: l_element_class_usage_id PAY_ELEMENT_CLASS_USAGES_F.ELEMENT_CLASS_USAGE_ID%TYPE;
1219: l_run_type_id PAY_ELEMENT_CLASS_USAGES_F.RUN_TYPE_ID%TYPE;
1220: l_classification_id PAY_ELEMENT_CLASS_USAGES_F.CLASSIFICATION_ID%TYPE;
1221: l_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
1222: --
1223: -- Cursor for fetching the run type id.

Line 1220: l_classification_id PAY_ELEMENT_CLASS_USAGES_F.CLASSIFICATION_ID%TYPE;

1216: l_business_group_id PAY_ELEMENT_CLASS_USAGES_F.BUSINESS_GROUP_ID%TYPE;
1217: l_rec PAY_ECU_SHD.G_REC_TYPE;
1218: l_element_class_usage_id PAY_ELEMENT_CLASS_USAGES_F.ELEMENT_CLASS_USAGE_ID%TYPE;
1219: l_run_type_id PAY_ELEMENT_CLASS_USAGES_F.RUN_TYPE_ID%TYPE;
1220: l_classification_id PAY_ELEMENT_CLASS_USAGES_F.CLASSIFICATION_ID%TYPE;
1221: l_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
1222: --
1223: -- Cursor for fetching the run type id.
1224: Cursor csr_get_rt_id is

Line 1221: l_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;

1217: l_rec PAY_ECU_SHD.G_REC_TYPE;
1218: l_element_class_usage_id PAY_ELEMENT_CLASS_USAGES_F.ELEMENT_CLASS_USAGE_ID%TYPE;
1219: l_run_type_id PAY_ELEMENT_CLASS_USAGES_F.RUN_TYPE_ID%TYPE;
1220: l_classification_id PAY_ELEMENT_CLASS_USAGES_F.CLASSIFICATION_ID%TYPE;
1221: l_object_version_number PAY_ELEMENT_CLASS_USAGES_F.OBJECT_VERSION_NUMBER%TYPE;
1222: --
1223: -- Cursor for fetching the run type id.
1224: Cursor csr_get_rt_id is
1225: select prt.run_type_id

Line 1256: from pay_element_class_usages_f

1252:
1253: -- Cursor for cheking the rows exists or not.
1254: Cursor csr_exists is
1255: select element_class_usage_id, object_version_number
1256: from pay_element_class_usages_f
1257: where run_type_id = l_run_type_id
1258: and classification_id = l_classification_id
1259: and NVL(business_group_id, hr_api.g_number) = NVL(l_business_group_id, hr_api.g_number)
1260: and NVL(legislation_code, hr_api.g_varchar2) = NVL(p_legislation_code, hr_api.g_varchar2)