APPS.PQH_SS_WORKFLOW dependencies on HR_API_TRANSACTIONS

Line 283: FROM hr_api_transactions

279: p_itemType IN VARCHAR2
280: ,p_itemKey IN VARCHAR2 ) RETURN NUMBER IS
281: CURSOR cur_txn IS
282: SELECT transaction_id
283: FROM hr_api_transactions
284: WHERE item_type = p_itemType
285: AND item_key = p_itemKey;
286: l_transactionId NUMBER;
287: BEGIN

Line 636: FROM hr_api_transactions hat,

632:
633: CURSOR cur_sfl IS
634: SELECT nvl(decode(wav.text_value, null, hat.status,
635: decode(hat.status,'S','SUBMIT',hat.status)),'N')
636: FROM hr_api_transactions hat,
637: wf_item_attribute_values wav
638: WHERE hat.item_type = wav.item_Type
639: AND hat.item_key = wav.item_Key
640: AND wav.item_type = itemType

Line 781: FROM hr_api_transactions

777: CURSOR cur_txn IS
778: SELECT transaction_id, status, transaction_state, NVL(transaction_effective_date,sysdate),
779: assignment_id, effective_date_option, plan_id, rptg_grp_id,
780: NVL(selected_person_id,-1), process_name,function_id
781: FROM hr_api_transactions
782: WHERE item_type = p_itemType
783: AND item_key = p_itemKey;
784: --
785: -- Bug 2969312: 21-May-2003: ns

Line 1452: FROM hr_api_transactions

1448: l_newStatus VARCHAR2(10);
1449: --
1450: CURSOR cur_txn_status IS
1451: SELECT transaction_id, status, transaction_state
1452: FROM hr_api_transactions
1453: WHERE item_type = p_itemType
1454: AND item_key = p_itemKey;
1455: --
1456: BEGIN

Line 1876: -- FROM hr_api_transactions

1872: l_step_id NUMBER(15);
1873: --
1874: -- CURSOR cur_status IS
1875: -- SELECT status
1876: -- FROM hr_api_transactions
1877: -- WHERE transaction_id = l_transactionId;
1878: BEGIN
1879: IF (funcmode <> wf_engine.eng_run) THEN
1880: result := wf_engine.eng_null;

Line 1899: from hr_api_transactions

1895:
1896: -- need to check status too
1897: begin
1898: select status into l_status
1899: from hr_api_transactions
1900: where transaction_id=l_transactionId;
1901: exception
1902: when others then
1903: null;

Line 1976: FROM hr_api_transactions

1972: --
1973: -- ItemType aNd ItemKey are for the approval wf process
1974: CURSOR cur_txn IS
1975: SELECT NVL(status,'N')
1976: FROM hr_api_transactions
1977: WHERE item_type = itemType
1978: AND item_key = itemKey;
1979: l_status VARCHAR2(10);
1980: --

Line 2349: FROM hr_api_transactions

2345: CURSOR cur_txn (c_itemType VARCHAR2, c_itemKey VARCHAR2) IS
2346: SELECT -- to_char(NVL(transaction_effective_date,sysdate),g_date_format),
2347: -- assignment_id, selected_person_id,
2348: NVL(status,'N'), NVL(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N')
2349: FROM hr_api_transactions
2350: WHERE item_type = c_itemType
2351: AND item_key = c_itemKey;
2352: --
2353: BEGIN

Line 2427: FROM hr_api_transactions

2423: result OUT NOCOPY VARCHAR2 ) IS
2424: --
2425: CURSOR cur_txn IS
2426: SELECT transaction_id, NVL(effective_date_option,'X')
2427: FROM hr_api_transactions
2428: WHERE item_type = itemType
2429: AND item_key = itemKey;
2430: --
2431: l_txnId NUMBER(15);