APPS.PER_SP_STAGE dependencies on PER_SP_PLAN

Line 30: and TRANSACTION_REF_TABLE='PER_SP_PLAN'

26: cursor csrHrApiTxnId is
27: select TRANSACTION_ID
28: from HR_API_TRANSACTIONS
29: where TRANSACTION_REF_ID=p_copy_entity_txn_id
30: and TRANSACTION_REF_TABLE='PER_SP_PLAN'
31: and PROCESS_NAME='HR_SP_APPROVAL_PRC';
32:
33: begin
34:

Line 47: VALUES(p_hr_api_txn_id,p_person_id,'W', p_copy_entity_txn_id,'PER_SP_PLAN','NWF','HR_SP_APPROVAL_PRC','PRIVATE','HRSSA',hr_workflow_item_key_s.nextval);

43: if p_hr_api_txn_id is null then
44: p_hr_api_txn_id := HR_API_TRANSACTIONS_S.NEXTVAL;
45:
46: INSERT INTO HR_API_TRANSACTIONS (TRANSACTION_ID, CREATOR_PERSON_ID, STATUS, TRANSACTION_REF_ID, TRANSACTION_REF_TABLE, TRANSACTION_TYPE, PROCESS_NAME,TRANSACTION_PRIVILEGE,ITEM_TYPE,ITEM_KEY)
47: VALUES(p_hr_api_txn_id,p_person_id,'W', p_copy_entity_txn_id,'PER_SP_PLAN','NWF','HR_SP_APPROVAL_PRC','PRIVATE','HRSSA',hr_workflow_item_key_s.nextval);
48:
49: else
50:
51: update HR_API_TRANSACTIONS

Line 306: per_sp_plan_api.create_sp_plan(p_validate => false

302: LOOP
303: IF i.dml_operation = 'CREATE' THEN
304: hr_utility.trace('Inserting the new Succession Plan: '||i.plan_name);
305: hr_utility.set_location(l_proc,15);
306: per_sp_plan_api.create_sp_plan(p_validate => false
307: ,p_effective_date => l_effective_date
308: ,p_plan_type => i.plan_type
309: ,p_plan_name => i.plan_name
310: ,p_successee_id => i.successee_id

Line 351: per_sp_plan_api.update_sp_plan(p_validate => false

347: hr_utility.trace('Updating the new Succession Plan: '||i.plan_name);
348: l_spp_id := i.plan_id;
349: l_spp_ovn := i.object_version_number;
350: hr_utility.set_location(l_proc,25);
351: per_sp_plan_api.update_sp_plan(p_validate => false
352: ,p_effective_date => l_effective_date
353: ,p_plan_type => i.plan_type
354: ,p_plan_name => i.plan_name
355: ,p_successee_id => i.successee_id

Line 406: per_sp_plan_api.delete_sp_plan(p_validate => false

402: ,p_object_version_number => j.object_version_number);
403: END IF;
404: hr_utility.set_location(l_proc,39);
405: END LOOP;
406: per_sp_plan_api.delete_sp_plan(p_validate => false
407: ,p_plan_id => l_spp_id
408: ,p_object_version_number => l_spp_ovn);
409: hr_utility.set_location(l_proc,40);
410:

Line 583: ENTITY_NAME='PER_SP_PLAN'

579: --
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;

Line 673: FROM per_sp_plan

669: ,attribute17
670: ,attribute18
671: ,attribute19
672: ,attribute20
673: FROM per_sp_plan
674: WHERE plan_id = p_plan_id;
675:
676: CURSOR csr_successors(p_plan_id IN number) IS
677: SELECT plan_id

Line 755: FROM PER_SP_PLAN WHERE PLAN_ID=p_plan_id;

751:
752: IF p_business_group_id IS NULL
753: THEN
754: SELECT business_group_id INTO l_business_group_id
755: FROM PER_SP_PLAN WHERE PLAN_ID=p_plan_id;
756: END IF;
757:
758: create_sp(p_business_group_id => l_business_group_id,
759: p_copy_entity_txn_id => l_copy_entity_txn_id);

Line 1302: l_plan_name per_sp_plan.plan_name%type;

1298: l_return_status varchar2(1000);
1299: l_process_display_name varchar2(240);
1300: l_role_name wf_roles.name%type;
1301: l_role_displayname wf_roles.display_name%type;
1302: l_plan_name per_sp_plan.plan_name%type;
1303: l_hrApiTxnId number;
1304:
1305: lv_status varchar2(8);
1306: l_status varchar2(8);

Line 1332: and TRANSACTION_REF_TABLE='PER_SP_PLAN'

1328:
1329: select transaction_id, item_key into l_hrApiTxnId, l_item_key
1330: from hr_api_transactions
1331: where TRANSACTION_REF_ID=p_copy_entity_txn_id
1332: and TRANSACTION_REF_TABLE='PER_SP_PLAN'
1333: and PROCESS_NAME='HR_SP_APPROVAL_PRC';
1334:
1335: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);
1336: