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.PQH_GSP_PRGRULES dependencies on BEN_COPY_ENTITY_RESULTS_API

Line 555: ben_copy_entity_results_api.create_copy_entity_results(

551: bcer_rec ben_copy_entity_results%rowtype ;
552: begin
553: hr_utility.set_location('Entering creating bcer rec', 10);
554: bcer_rec := p_bcer_rec ;
555: ben_copy_entity_results_api.create_copy_entity_results(
556: p_effective_date => l_effective_date
557: ,p_copy_entity_txn_id => bcer_rec.copy_entity_txn_id
558: ,p_result_type_cd => bcer_rec.result_type_cd
559: ,p_src_copy_entity_result_id => bcer_rec.src_copy_entity_result_id

Line 1309: Ben_Copy_Entity_Results_Api.DELETE_COPY_ENTITY_RESULTS

1305: l_Dml_Opr := NULL;
1306: L_Dml_Opr := Get_Dml_Operation(l_PrtnPrfl_Copy_Entity_Rslt_Id, 'D');
1307:
1308: if L_Dml_Opr = 'PURGE' then
1309: Ben_Copy_Entity_Results_Api.DELETE_COPY_ENTITY_RESULTS
1310: (P_COPY_ENTITY_RESULT_ID => l_PrtnPrfl_Copy_Entity_Rslt_Id,
1311: P_OBJECT_VERSION_NUMBER => l_Prtn_Elig_Prfl_ovn,
1312: P_EFFECTIVE_DATE => P_Effective_Date);
1313: Else

Line 1314: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS

1310: (P_COPY_ENTITY_RESULT_ID => l_PrtnPrfl_Copy_Entity_Rslt_Id,
1311: P_OBJECT_VERSION_NUMBER => l_Prtn_Elig_Prfl_ovn,
1312: P_EFFECTIVE_DATE => P_Effective_Date);
1313: Else
1314: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS
1315: (P_EFFECTIVE_DATE => P_Effective_Date,
1316: P_COPY_ENTITY_TXN_ID => p_Copy_Entity_txn_Id,
1317: P_DML_OPERATION => 'DELETE',
1318: P_INFORMATION323 => NULL,

Line 1330: Ben_Copy_Entity_Results_Api.DELETE_COPY_ENTITY_RESULTS

1326: l_Dml_Opr := NULL;
1327: L_Dml_Opr := Get_Dml_Operation(l_DelPrtn_Copy_Entity_Rslt_Id, 'D');
1328:
1329: If L_Dml_Opr = 'PURGE' then
1330: Ben_Copy_Entity_Results_Api.DELETE_COPY_ENTITY_RESULTS
1331: (P_COPY_ENTITY_RESULT_ID => l_DelPrtn_Copy_Entity_Rslt_Id,
1332: P_OBJECT_VERSION_NUMBER => l_DelPrtn_ovn,
1333: P_EFFECTIVE_DATE => P_Effective_Date);
1334: Else

Line 1335: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS

1331: (P_COPY_ENTITY_RESULT_ID => l_DelPrtn_Copy_Entity_Rslt_Id,
1332: P_OBJECT_VERSION_NUMBER => l_DelPrtn_ovn,
1333: P_EFFECTIVE_DATE => P_Effective_Date);
1334: Else
1335: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS
1336: (P_EFFECTIVE_DATE => P_Effective_Date,
1337: P_COPY_ENTITY_TXN_ID => p_Copy_Entity_txn_Id,
1338: P_DML_OPERATION => 'DELETE',
1339: P_INFORMATION323 => NULL,

Line 1358: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS

1354: Fetch Prtn into l_Prtn_Elig_id, l_Prtn_Copy_Entity_Rslt_Id, l_Prtn_ovn, L_DML_OPERATION;
1355: If Prtn%FOUND Then
1356: l_InsYN := 'N';
1357: If L_DML_OPERATION = 'DELETE' Then
1358: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS
1359: (P_EFFECTIVE_DATE => P_Effective_Date,
1360: P_COPY_ENTITY_TXN_ID => p_Copy_Entity_txn_Id,
1361: P_COPY_ENTITY_RESULT_ID => l_Prtn_Copy_Entity_Rslt_Id,
1362: P_DML_OPeration => 'UPDATE',

Line 1421: Ben_Copy_Entity_Results_Api.CREATE_COPY_ENTITY_RESULTS

1417:
1418: /* This Insert Links the Ben Object with the Eligibility Profiles (CEP) */
1419: hr_utility.set_location('Inserting EPA .. L_Prtn_Mirror_result_Id ' || L_Prtn_Mirror_result_Id , 80);
1420:
1421: Ben_Copy_Entity_Results_Api.CREATE_COPY_ENTITY_RESULTS
1422: (P_EFFECTIVE_DATE => P_Effective_Date,
1423: P_COPY_ENTITY_TXN_ID => p_Copy_Entity_txn_Id,
1424: P_RESULT_TYPE_CD => 'DISPLAY',
1425: P_NUMBER_OF_COPIES => 1,

Line 1457: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS

1453:
1454: If PrtnElig%FOUND Then
1455: hr_utility.set_location('Inserting CEP ..l_Prtn_Copy_Entity_Rslt_Id ' || l_Prtn_Copy_Entity_Rslt_Id , 90);
1456:
1457: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS
1458: (P_EFFECTIVE_DATE => P_Effective_Date,
1459: P_COPY_ENTITY_TXN_ID => p_Copy_Entity_txn_Id,
1460: P_RESULT_TYPE_CD => 'DISPLAY',
1461: P_NUMBER_OF_COPIES => 1,

Line 1486: Ben_Copy_Entity_Results_Api.CREATE_COPY_ENTITY_RESULTS

1482: Else
1483:
1484: hr_utility.set_location('Updating CEP ..l_Prtn_Copy_Entity_Rslt_Id ' || l_Prtn_Copy_Entity_Rslt_Id , 90);
1485:
1486: Ben_Copy_Entity_Results_Api.CREATE_COPY_ENTITY_RESULTS
1487: (P_EFFECTIVE_DATE => P_Effective_Date,
1488: P_COPY_ENTITY_TXN_ID => p_Copy_Entity_txn_Id,
1489: P_RESULT_TYPE_CD => 'DISPLAY',
1490: P_NUMBER_OF_COPIES => 1,

Line 1512: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS

1508: P_GS_MR_SRC_ENTITY_RESULT_ID => l_Prtn_Copy_Entity_Rslt_Id,
1509: P_OBJECT_VERSION_NUMBER => l_Prtn_Elig_Prfl_Ovn);
1510:
1511: If p_Txn_Mode <> 'I' Then
1512: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS
1513: (P_EFFECTIVE_DATE => P_Effective_Date,
1514: P_COPY_ENTITY_TXN_ID => p_Copy_Entity_txn_Id,
1515: P_Gs_Parent_Entity_Result_Id => P_Gs_Parent_Entity_Result_Id,
1516: P_GS_MR_SRC_ENTITY_RESULT_ID => l_PrtnPrfl_Copy_Entity_Rslt_Id,

Line 1534: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS

1530: Open ovn;
1531: Fetch ovn into l_ovn;
1532: Close ovn;
1533:
1534: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS
1535: (P_EFFECTIVE_DATE => P_Effective_Date,
1536: P_COPY_ENTITY_TXN_ID => p_Copy_Entity_txn_Id,
1537: P_Gs_Parent_Entity_Result_Id => P_Gs_Parent_Entity_Result_Id,
1538: P_GS_MR_SRC_ENTITY_RESULT_ID => l_PrtnPrfl_Copy_Entity_Rslt_Id,

Line 1636: Ben_Copy_Entity_Results_Api.DELETE_COPY_ENTITY_RESULTS

1632: If L_Cnt = 0 then
1633: L_Dml_Opr := Get_Dml_Operation(L_Epa_Cer_Id, 'D');
1634:
1635: If L_Dml_Opr = 'PURGE' then
1636: Ben_Copy_Entity_Results_Api.DELETE_COPY_ENTITY_RESULTS
1637: (P_COPY_ENTITY_RESULT_ID => L_Epa_Cer_Id,
1638: P_OBJECT_VERSION_NUMBER => L_Epa_Ovn,
1639: P_EFFECTIVE_DATE => Trunc(Sysdate));
1640: Else

Line 1641: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS

1637: (P_COPY_ENTITY_RESULT_ID => L_Epa_Cer_Id,
1638: P_OBJECT_VERSION_NUMBER => L_Epa_Ovn,
1639: P_EFFECTIVE_DATE => Trunc(Sysdate));
1640: Else
1641: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS
1642: (P_EFFECTIVE_DATE => Trunc(Sysdate),
1643: P_COPY_ENTITY_TXN_ID => p_Copy_Entity_txn_Id,
1644: P_DML_OPERATION => 'DELETE',
1645: P_INFORMATION323 => NULL,

Line 1655: Ben_Copy_Entity_Results_Api.DELETE_COPY_ENTITY_RESULTS

1651: l_Dml_opr := NULL;
1652: L_Dml_Opr := Get_Dml_Operation(L_Cep_Cer_Id, 'D');
1653:
1654: If L_Dml_Opr = 'PURGE' then
1655: Ben_Copy_Entity_Results_Api.DELETE_COPY_ENTITY_RESULTS
1656: (P_COPY_ENTITY_RESULT_ID => L_Cep_Cer_Id,
1657: P_OBJECT_VERSION_NUMBER => L_Cep_Ovn,
1658: P_EFFECTIVE_DATE => Trunc(Sysdate));
1659: Else

Line 1660: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS

1656: (P_COPY_ENTITY_RESULT_ID => L_Cep_Cer_Id,
1657: P_OBJECT_VERSION_NUMBER => L_Cep_Ovn,
1658: P_EFFECTIVE_DATE => Trunc(Sysdate));
1659: Else
1660: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS
1661: (P_EFFECTIVE_DATE => Trunc(Sysdate),
1662: P_COPY_ENTITY_TXN_ID => p_Copy_Entity_txn_Id,
1663: P_DML_OPERATION => 'DELETE',
1664: P_INFORMATION323 => NULL,

Line 1671: Ben_Copy_Entity_Results_Api.DELETE_COPY_ENTITY_RESULTS

1667: End If;
1668:
1669: For Del_Elp_rec in Del_Elp
1670: Loop
1671: Ben_Copy_Entity_Results_Api.DELETE_COPY_ENTITY_RESULTS
1672: (P_COPY_ENTITY_RESULT_ID => Del_Elp_rec.Copy_Entity_result_id,
1673: P_OBJECT_VERSION_NUMBER => Del_Elp_rec.Object_version_number,
1674: P_EFFECTIVE_DATE => Trunc(Sysdate));
1675: End Loop;