APPS.PER_SP_STAGE dependencies on HR_WORKFLOW_ITEM_KEY_S

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 52: set item_key=hr_workflow_item_key_s.nextval

48:
49: else
50:
51: update HR_API_TRANSACTIONS
52: set item_key=hr_workflow_item_key_s.nextval
53: where item_key is null
54: and TRANSACTION_ID = p_hr_api_txn_id
55: and PROCESS_NAME='HR_SP_APPROVAL_PRC';
56: