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.OKS_WF_K_PROCESS_PVT dependencies on WF_ITEMS

Line 237: l_item_key wf_items.item_key%TYPE :=NULL;

233: p_contract_id IN NUMBER
234: ) RETURN VARCHAR2 AS
235:
236: l_api_name CONSTANT VARCHAR2(30) := 'get_concat_k_number';
237: l_item_key wf_items.item_key%TYPE :=NULL;
238:
239: CURSOR l_kdetails_csr(p_contract_id NUMBER) IS
240: SELECT contract_number,contract_number_modifier
241: FROM okc_k_headers_all_b

Line 347: l_item_key wf_items.item_key%TYPE :=NULL;

343: p_contract_id IN NUMBER
344: ) RETURN VARCHAR2 AS
345:
346: l_api_name CONSTANT VARCHAR2(30) := 'get_wf_item_key';
347: l_item_key wf_items.item_key%TYPE :=NULL;
348:
349:
350: CURSOR csr_k_item_key IS
351: SELECT wf_item_key

Line 663: l_item_key wf_items.item_key%TYPE :=NULL;

659: p_item_key IN VARCHAR2
660: ) RETURN VARCHAR2 AS
661:
662: l_api_name CONSTANT VARCHAR2(30) := 'get_irr_flag';
663: l_item_key wf_items.item_key%TYPE :=NULL;
664: l_irr_flag VARCHAR2(1) := NULL;
665:
666: BEGIN
667:

Line 861: l_item_key wf_items.item_key%TYPE;

857:
858: l_api_version CONSTANT NUMBER := 1.0;
859: l_api_name CONSTANT VARCHAR2(50) := 'is_online_k_yn';
860:
861: l_item_key wf_items.item_key%TYPE;
862: l_publish_manually VARCHAR2(1);
863: l_process_type VARCHAR2(30);
864:
865: BEGIN

Line 977: l_item_key wf_items.item_key%TYPE;

973: ) AS
974:
975: l_api_version CONSTANT NUMBER := 1;
976: l_api_name CONSTANT VARCHAR2(30) := 'complete_activity';
977: l_item_key wf_items.item_key%TYPE;
978:
979: BEGIN
980: -- start debug log
981: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1190: FROM wf_items

1186: l_api_name CONSTANT VARCHAR2(30) := 'in_process_yn';
1187:
1188: CURSOR l_wfactive_csr IS
1189: SELECT 'Y'
1190: FROM wf_items
1191: WHERE item_type = p_workflow_name
1192: AND item_key = p_contract_number || p_contract_number_modifier
1193: AND end_date IS NULL;
1194:

Line 1422: l_item_key wf_items.item_key%TYPE;

1418: AND ol.process_flag = 'P'
1419: AND ol.object_chr_id = kh.id;
1420:
1421: l_kdetails_rec l_kdetails_csr%ROWTYPE;
1422: l_item_key wf_items.item_key%TYPE;
1423: l_party_name VARCHAR2(360);
1424: l_notif_subject VARCHAR2(2000);
1425: l_salesrep_id NUMBER;
1426: l_salesrep_name VARCHAR2(100);

Line 1997: l_item_key wf_items.item_key%TYPE;

1993: l_ih_subject VARCHAR2(4000);
1994: l_ih_message VARCHAR2(4000);
1995:
1996: l_kdetails_rec l_kdetails_csr%ROWTYPE;
1997: l_item_key wf_items.item_key%TYPE;
1998: l_party_name VARCHAR2(360);
1999: l_concat_k_number VARCHAR2(300);
2000: l_accepted_by VARCHAR2(100);
2001: l_iso_language VARCHAR2(6);

Line 2470: l_item_key wf_items.item_key%TYPE;

2466: l_api_version CONSTANT NUMBER := 1;
2467: l_api_name CONSTANT VARCHAR2(30) := 'customer_accept_quote';
2468:
2469: l_send_email_yn VARCHAR2(1) := 'N';
2470: l_item_key wf_items.item_key%TYPE;
2471: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
2472: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
2473:
2474: CURSOR l_payment_csr(p_chr_id NUMBER) IS

Line 2845: l_item_key wf_items.item_key%TYPE;

2841: /*Added for ER 13869562 spingali*/
2842:
2843:
2844: l_send_email_yn VARCHAR2(1) := 'N';
2845: l_item_key wf_items.item_key%TYPE;
2846: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
2847: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
2848: l_old_sts OKC_STATUSES_B.CODE%TYPE;
2849: l_new_sts OKC_STATUSES_B.CODE%TYPE;

Line 3188: l_item_key wf_items.item_key%TYPE;

3184: ) AS
3185:
3186: l_api_version CONSTANT NUMBER := 1;
3187: l_api_name CONSTANT VARCHAR2(30) := 'customer_request_assistance';
3188: l_item_key wf_items.item_key%TYPE;
3189: l_interaction_subject VARCHAR2(4000);
3190: l_interaction_message VARCHAR2(4000);
3191: l_role_name wf_roles.name%TYPE := NULL;
3192: l_role_email wf_roles.email_address%TYPE;

Line 4418: FROM WF_ITEMS

4414:
4415: /*start bug8705707*/
4416: CURSOR wf_cur(p_wf_item_key varchar2) IS
4417: SELECT ITEM_TYPE
4418: FROM WF_ITEMS
4419: WHERE item_key = p_wf_item_key;
4420:
4421: l_item_type VARCHAR2(30);
4422: /*end bug8705707*/

Line 4426: l_item_key wf_items.item_key%TYPE;

4422: /*end bug8705707*/
4423:
4424: l_contract_number VARCHAR2(120);
4425: l_contract_modifier VARCHAR2(120);
4426: l_item_key wf_items.item_key%TYPE;
4427: l_user_key VARCHAR2(240);
4428: l_save_threshold NUMBER;
4429:
4430: BEGIN

Line 4762: l_item_key wf_items.item_key%TYPE;

4758: ) IS
4759: l_api_version CONSTANT NUMBER := 1.0;
4760: l_api_name CONSTANT VARCHAR2(50) := 'assign_new_qto_contact';
4761:
4762: l_item_key wf_items.item_key%TYPE;
4763: l_activity_name VARCHAR2(30);
4764:
4765: BEGIN
4766:

Line 4924: l_item_key wf_items.item_key%TYPE;

4920: ) IS
4921: l_api_version CONSTANT NUMBER := 1.0;
4922: l_api_name CONSTANT VARCHAR2(50) := 'clean_wf';
4923:
4924: l_item_key wf_items.item_key%TYPE;
4925: l_activity_name VARCHAR2(30);
4926: l_count NUMBER; -- Added for Bug#14150408
4927: BEGIN
4928:

Line 4972: FROM wf_items

4968: END IF;
4969: -- Added for Bug#14150408
4970: SELECT count(1)
4971: INTO l_count
4972: FROM wf_items
4973: WHERE item_type = G_ITEM_TYPE
4974: AND item_key = to_char(p_item_key);
4975:
4976: IF l_count > 0 THEN

Line 5837: l_item_key wf_items.item_key%TYPE;

5833: ) IS
5834:
5835: l_api_version CONSTANT NUMBER := 1.0;
5836: l_api_name CONSTANT VARCHAR2(50) := 'is_submit_for_approval_allowed';
5837: l_item_key wf_items.item_key%TYPE;
5838: l_contract_number VARCHAR2(120);
5839: l_contract_modifier VARCHAR2(120);
5840:
5841: BEGIN

Line 6097: l_item_key wf_items.item_key%TYPE;

6093: l_api_version CONSTANT NUMBER := 1.0;
6094: l_api_name CONSTANT VARCHAR2(50) := 'submit_for_approval';
6095:
6096: l_send_email_yn VARCHAR2(1) := 'N';
6097: l_item_key wf_items.item_key%TYPE;
6098: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
6099: l_activity_name VARCHAR2(30);
6100: l_irr_flag VARCHAR2(1);
6101:

Line 8067: l_item_key wf_items.item_key%TYPE;

8063:
8064: l_api_version CONSTANT NUMBER := 1.0;
8065: l_api_name CONSTANT VARCHAR2(30) := 'accept_quote';
8066:
8067: l_item_key wf_items.item_key%TYPE;
8068: l_activity_name VARCHAR2(30);
8069: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
8070:
8071: BEGIN

Line 8296: l_item_key wf_items.item_key%TYPE;

8292:
8293: l_send_email_yn VARCHAR2(1) := 'N';
8294: l_reason VARCHAR2(250);
8295:
8296: l_item_key wf_items.item_key%TYPE;
8297: l_result_out wf_item_activity_statuses.activity_result_code%TYPE;
8298: l_process_status VARCHAR2(30);
8299: l_activity_name VARCHAR2(30);
8300: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;

Line 8866: FROM WF_ITEMS WF,

8862: AND okck.template_yn = 'N'
8863: --no active approval workflow exists
8864: AND NOT EXISTS
8865: (SELECT 1
8866: FROM WF_ITEMS WF,
8867: OKC_PROCESS_DEFS_B KPDF
8868: WHERE WF.item_key = okck.contract_number || okck.contract_number_modifier
8869: AND WF.end_date IS NULL
8870: AND WF.item_type = KPDF.wf_name

Line 8875: FROM WF_ITEMS WF

8871: AND KPDF.pdf_type = 'WPS')
8872: --for an ENTERED status contract, no active base workflow exists
8873: AND NOT EXISTS
8874: (SELECT 1
8875: FROM WF_ITEMS WF
8876: WHERE WF.item_key = oksk.wf_item_key
8877: AND WF.end_date IS NULL
8878: AND WF.item_type = G_ITEM_TYPE);
8879: