[Home] [Help]
200: ,Information129 "ATTRIBUTE19"
201: ,Information130 "ATTRIBUTE20"
202: ,dml_operation
203: ,table_alias
204: FROM ben_copy_entity_results
205: WHERE copy_entity_txn_id = p_copy_entity_txn_id
206: AND table_alias = 'SP';
207:
208:
272: ,information267 "LAST_UPDATED_BY"
273: ,information307 "LAST_UPDATE_DATE"
274: ,dml_operation
275: ,table_alias
276: FROM ben_copy_entity_results
277: WHERE copy_entity_txn_id = p_copy_entity_txn_id
278: AND table_alias = 'SCSR'
279: AND parent_entity_result_id = p_parent_entity_result_id
280: ORDER BY information160;
565:
566: UPDATE fnd_attached_documents
567: SET PK1_VALUE=l_sip_id,
568: ENTITY_NAME='PER_SP_SUCCESSOR_IN_PLAN'
569: WHERE ENTITY_NAME='BEN_COPY_ENTITY_RESULTS_SCSR'
570: AND PK1_VALUE=j.copy_entity_result_id;
571: end if;
572:
573: END LOOP;
580:
581: UPDATE fnd_attached_documents
582: SET PK1_VALUE=l_spp_id,
583: ENTITY_NAME='PER_SP_PLAN'
584: WHERE ENTITY_NAME='BEN_COPY_ENTITY_RESULTS_PL'
585: AND PK1_VALUE=i.copy_entity_result_id;
586: end if;
587: END LOOP;
588:
766: LOOP
767:
768:
769:
770: INSERT INTO ben_copy_entity_results (copy_entity_result_id
771: ,information1
772: ,information11
773: ,information151
774: ,information4
816: ,RESULT_TYPE_CD
817: ,OBJECT_VERSION_NUMBER
818: ,STATUS)
819: VALUES
820: (ben_copy_entity_results_s.nextval
821: ,i.plan_id
822: ,i.plan_type
823: ,i.plan_name
824: ,i.successee_id
866: ,'DISPLAY'
867: ,1
868: ,'W');
869:
870: select ben_copy_entity_results_s.currval into l_pl_cer_id from dual;
871: --- Now insert the SPP records
872: FOR j IN csr_successors(p_plan_id)
873: LOOP
874: INSERT INTO ben_copy_entity_results
870: select ben_copy_entity_results_s.currval into l_pl_cer_id from dual;
871: --- Now insert the SPP records
872: FOR j IN csr_successors(p_plan_id)
873: LOOP
874: INSERT INTO ben_copy_entity_results
875: ( copy_entity_result_id
876: ,information160
877: ,information1
878: ,information4
942: ,OBJECT_VERSION_NUMBER
943: ,PARENT_ENTITY_RESULT_ID
944: )
945: VALUES
946: ( ben_copy_entity_results_s.nextval
947: ,j.successor_in_plan_id
948: ,j.plan_id
949: ,j.successor_id
950: ,j.potential
1054: response := wf_engine.getItemAttrText(itemtype=> itemtype,itemkey=> itemkey,aname => 'WF_NOTE' );
1055: WF_ENGINE.setitemattrtext(itemtype, itemkey, 'APPROVAL_COMMENT', response);
1056:
1057: -- reset the status to work in progress
1058: update ben_copy_entity_results
1059: set status='W', information220=response
1060: where copy_entity_txn_id=l_copy_entity_txn_id
1061: and table_alias='SP'
1062: and status='Y';
1144: --
1145: -- Purge data from transaction tables.
1146: --
1147:
1148: Delete from BEN_COPY_ENTITY_RESULTS
1149: where copy_entity_txn_id = p_copy_entity_txn_id
1150: and table_alias in ('SP','SCSR');
1151:
1152: delete from pqh_copy_entity_txns
1178:
1179: hr_utility.set_location('getting the plan Id....', 50);
1180:
1181: select distinct information1 into plan_id
1182: from ben_copy_entity_results
1183: where copy_entity_txn_id = p_copy_entity_txn_id
1184: and table_alias='SP';
1185:
1186: hr_utility.set_location('deleting from stage..PLAN:'||plan_id, 50);
1189: then
1190: --
1191: -- Purge all data from transaction tables with the above plan_id.
1192: --
1193: Delete from BEN_COPY_ENTITY_RESULTS
1194: where information1 = plan_id
1195: and table_alias in ('SP','SCSR');
1196: else
1197:
1197:
1198: --
1199: -- Purge data from transaction tables with the given txn id
1200: --
1201: Delete from BEN_COPY_ENTITY_RESULTS
1202: where copy_entity_txn_id = p_copy_entity_txn_id
1203: and table_alias in ('SP','SCSR');
1204: end if;
1205:
1317: AND wrpv.process_name = p_process;
1318:
1319: cursor get_plan_name is
1320: select Information151 plan_name
1321: from ben_copy_entity_results
1322: where copy_entity_txn_id=p_copy_entity_txn_id
1323: and table_alias='SP';
1324:
1325: begin
1448: end if;
1449:
1450:
1451:
1452: update ben_copy_entity_results
1453: set status='Y'
1454: where copy_entity_txn_id=p_copy_entity_txn_id
1455: and table_alias='SP'
1456: and status='W';