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.PER_SP_STAGE dependencies on HR_API

Line 22: p_hr_api_txn_id out nocopy number) is

18: --
19:
20: procedure createHRApiTransaction(p_person_id in number,
21: p_copy_entity_txn_id in number,
22: p_hr_api_txn_id out nocopy number) is
23:
24: PRAGMA AUTONOMOUS_TRANSACTION;
25:
26: cursor csrHrApiTxnId is

Line 28: from HR_API_TRANSACTIONS

24: PRAGMA AUTONOMOUS_TRANSACTION;
25:
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:

Line 38: fetch csrHrApiTxnId into p_hr_api_txn_id;

34:
35: hr_utility.set_location('Creating createHRApiTransaction',10);
36:
37: open csrHrApiTxnId;
38: fetch csrHrApiTxnId into p_hr_api_txn_id;
39: close csrHrApiTxnId;
40:
41: hr_utility.set_location('p_hr_api_txn_id:'||p_hr_api_txn_id,15);
42:

Line 41: hr_utility.set_location('p_hr_api_txn_id:'||p_hr_api_txn_id,15);

37: open csrHrApiTxnId;
38: fetch csrHrApiTxnId into p_hr_api_txn_id;
39: close csrHrApiTxnId;
40:
41: hr_utility.set_location('p_hr_api_txn_id:'||p_hr_api_txn_id,15);
42:
43: if p_hr_api_txn_id is null then
44: p_hr_api_txn_id := HR_API_TRANSACTIONS_S.NEXTVAL;
45:

Line 43: if p_hr_api_txn_id is null then

39: close csrHrApiTxnId;
40:
41: hr_utility.set_location('p_hr_api_txn_id:'||p_hr_api_txn_id,15);
42:
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);

Line 44: p_hr_api_txn_id := HR_API_TRANSACTIONS_S.NEXTVAL;

40:
41: hr_utility.set_location('p_hr_api_txn_id:'||p_hr_api_txn_id,15);
42:
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:

Line 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)

42:
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:

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 51: update HR_API_TRANSACTIONS

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
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';

Line 54: and TRANSACTION_ID = p_hr_api_txn_id

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:
57: end if;
58:

Line 594: raise hr_api.validate_enabled;

590: --
591: -- When in validation only mode raise the Validate_Enabled exception
592: --
593: if p_validate = 'Y' then
594: raise hr_api.validate_enabled;
595: end if;
596:
597: exception
598: when hr_api.validate_enabled then

Line 598: when hr_api.validate_enabled then

594: raise hr_api.validate_enabled;
595: end if;
596:
597: exception
598: when hr_api.validate_enabled then
599: --
600: -- As the Validate_Enabled exception has been raised
601: -- we must rollback to the savepoint
602: --

Line 1050: from hr_api_transactions

1046:
1047: l_hrApiTxnId := wf_engine.GetItemAttrNumber(itemtype=> itemtype,itemkey=> itemkey,aname => 'TRANSACTION_ID' );
1048:
1049: select transaction_ref_id into l_copy_entity_txn_id
1050: from hr_api_transactions
1051: where transaction_id=l_hrApiTxnId
1052: and process_name='HR_SP_APPROVAL_PRC';
1053:
1054: response := wf_engine.getItemAttrText(itemtype=> itemtype,itemkey=> itemkey,aname => 'WF_NOTE' );

Line 1064: update hr_api_transactions

1060: where copy_entity_txn_id=l_copy_entity_txn_id
1061: and table_alias='SP'
1062: and status='Y';
1063:
1064: update hr_api_transactions
1065: set item_key=null
1066: where transaction_id=l_hrApiTxnId
1067: and process_name='HR_SP_APPROVAL_PRC';
1068:

Line 1106: from hr_api_transactions

1102: response := wf_engine.getItemAttrText(itemtype=> itemtype,itemkey=> itemkey,aname => 'WF_NOTE' );
1103: WF_ENGINE.setitemattrtext(itemtype, itemkey, 'APPROVAL_COMMENT', response);
1104:
1105: select transaction_ref_id into l_copy_entity_txn_id
1106: from hr_api_transactions
1107: where transaction_id=l_hrApiTxnId
1108: and process_name='HR_SP_APPROVAL_PRC';
1109:
1110: hr_utility.set_location('l_copy_entity_txn_id:'||l_copy_entity_txn_id, 40);

Line 1114: hr_utility.set_location('delete from hr_api_transactions..', 50);

1110: hr_utility.set_location('l_copy_entity_txn_id:'||l_copy_entity_txn_id, 40);
1111:
1112: commit_txn(l_copy_entity_txn_id);
1113:
1114: hr_utility.set_location('delete from hr_api_transactions..', 50);
1115:
1116: delete from hr_api_transactions
1117: where item_type=itemtype and item_key=itemkey;
1118:

Line 1116: delete from hr_api_transactions

1112: commit_txn(l_copy_entity_txn_id);
1113:
1114: hr_utility.set_location('delete from hr_api_transactions..', 50);
1115:
1116: delete from hr_api_transactions
1117: where item_type=itemtype and item_key=itemkey;
1118:
1119: resultout:='COMPLETE:SUCCESS';
1120:

Line 1156: delete from hr_api_transactions

1152: delete from pqh_copy_entity_txns
1153: where copy_entity_txn_id = p_copy_entity_txn_id
1154: and context='SP';
1155:
1156: delete from hr_api_transactions
1157: where transaction_ref_id = p_copy_entity_txn_id
1158: and process_name='HR_SP_APPROVAL_PRC';
1159:
1160:

Line 1211: delete from hr_api_transactions

1207: --
1208: delete from pqh_copy_entity_txns
1209: where copy_entity_txn_id = p_copy_entity_txn_id;
1210:
1211: delete from hr_api_transactions
1212: where transaction_ref_id = p_copy_entity_txn_id
1213: and process_name='HR_SP_APPROVAL_PRC';
1214:
1215:

Line 1330: from hr_api_transactions

1326:
1327: hr_utility.set_location('Entering:'||l_proc, 10);
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: