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 639: FROM hr_api_transactions hat,

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

Line 784: FROM hr_api_transactions

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

Line 1474: FROM hr_api_transactions

1470: --
1471: l_activity_id NUMBER; -- -- added for bug 12561019
1472: CURSOR cur_txn_status IS
1473: SELECT transaction_id, status, transaction_state
1474: FROM hr_api_transactions
1475: WHERE item_type = p_itemType
1476: AND item_key = p_itemKey;
1477: --
1478: BEGIN

Line 1899: -- FROM hr_api_transactions

1895: l_step_id NUMBER(15);
1896: --
1897: -- CURSOR cur_status IS
1898: -- SELECT status
1899: -- FROM hr_api_transactions
1900: -- WHERE transaction_id = l_transactionId;
1901: BEGIN
1902: IF (funcmode <> wf_engine.eng_run) THEN
1903: result := wf_engine.eng_null;

Line 1922: from hr_api_transactions

1918:
1919: -- need to check status too
1920: begin
1921: select status into l_status
1922: from hr_api_transactions
1923: where transaction_id=l_transactionId;
1924: exception
1925: when others then
1926: null;

Line 1999: FROM hr_api_transactions

1995: --
1996: -- ItemType aNd ItemKey are for the approval wf process
1997: CURSOR cur_txn IS
1998: SELECT NVL(status,'N')
1999: FROM hr_api_transactions
2000: WHERE item_type = itemType
2001: AND item_key = itemKey;
2002: l_status VARCHAR2(10);
2003: --

Line 2372: FROM hr_api_transactions

2368: CURSOR cur_txn (c_itemType VARCHAR2, c_itemKey VARCHAR2) IS
2369: SELECT -- to_char(NVL(transaction_effective_date,sysdate),g_date_format),
2370: -- assignment_id, selected_person_id,
2371: NVL(status,'N'), NVL(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N')
2372: FROM hr_api_transactions
2373: WHERE item_type = c_itemType
2374: AND item_key = c_itemKey;
2375: --
2376: BEGIN

Line 2450: FROM hr_api_transactions

2446: result OUT NOCOPY VARCHAR2 ) IS
2447: --
2448: CURSOR cur_txn IS
2449: SELECT transaction_id, NVL(effective_date_option,'X')
2450: FROM hr_api_transactions
2451: WHERE item_type = itemType
2452: AND item_key = itemKey;
2453: --
2454: l_txnId NUMBER(15);