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 2767: l_item_key wf_items.item_key%TYPE;

2763: AND default_yn = 'Y'
2764: AND sysdate BETWEEN START_DATE AND NVL(end_date,SYSDATE+1);
2765:
2766: l_send_email_yn VARCHAR2(1) := 'N';
2767: l_item_key wf_items.item_key%TYPE;
2768: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
2769: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
2770: l_old_sts OKC_STATUSES_B.CODE%TYPE;
2771: l_new_sts OKC_STATUSES_B.CODE%TYPE;

Line 3072: l_item_key wf_items.item_key%TYPE;

3068: ) AS
3069:
3070: l_api_version CONSTANT NUMBER := 1;
3071: l_api_name CONSTANT VARCHAR2(30) := 'customer_request_assistance';
3072: l_item_key wf_items.item_key%TYPE;
3073: l_interaction_subject VARCHAR2(4000);
3074: l_interaction_message VARCHAR2(4000);
3075: l_role_name wf_roles.name%TYPE := NULL;
3076: l_role_email wf_roles.email_address%TYPE;

Line 4299: l_item_key wf_items.item_key%TYPE;

4295: WHERE id = l_contract_id;
4296:
4297: l_contract_number VARCHAR2(120);
4298: l_contract_modifier VARCHAR2(120);
4299: l_item_key wf_items.item_key%TYPE;
4300: l_user_key VARCHAR2(240);
4301: l_save_threshold NUMBER;
4302:
4303: BEGIN

Line 4607: l_item_key wf_items.item_key%TYPE;

4603: ) IS
4604: l_api_version CONSTANT NUMBER := 1.0;
4605: l_api_name CONSTANT VARCHAR2(50) := 'assign_new_qto_contact';
4606:
4607: l_item_key wf_items.item_key%TYPE;
4608: l_activity_name VARCHAR2(30);
4609:
4610: BEGIN
4611:

Line 4769: l_item_key wf_items.item_key%TYPE;

4765: ) IS
4766: l_api_version CONSTANT NUMBER := 1.0;
4767: l_api_name CONSTANT VARCHAR2(50) := 'clean_wf';
4768:
4769: l_item_key wf_items.item_key%TYPE;
4770: l_activity_name VARCHAR2(30);
4771:
4772: BEGIN
4773:

Line 5533: l_item_key wf_items.item_key%TYPE;

5529: ) IS
5530:
5531: l_api_version CONSTANT NUMBER := 1.0;
5532: l_api_name CONSTANT VARCHAR2(50) := 'is_submit_for_approval_allowed';
5533: l_item_key wf_items.item_key%TYPE;
5534: l_contract_number VARCHAR2(120);
5535: l_contract_modifier VARCHAR2(120);
5536:
5537: BEGIN

Line 5793: l_item_key wf_items.item_key%TYPE;

5789: l_api_version CONSTANT NUMBER := 1.0;
5790: l_api_name CONSTANT VARCHAR2(50) := 'submit_for_approval';
5791:
5792: l_send_email_yn VARCHAR2(1) := 'N';
5793: l_item_key wf_items.item_key%TYPE;
5794: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
5795: l_activity_name VARCHAR2(30);
5796: l_irr_flag VARCHAR2(1);
5797:

Line 7763: l_item_key wf_items.item_key%TYPE;

7759:
7760: l_api_version CONSTANT NUMBER := 1.0;
7761: l_api_name CONSTANT VARCHAR2(30) := 'accept_quote';
7762:
7763: l_item_key wf_items.item_key%TYPE;
7764: l_activity_name VARCHAR2(30);
7765: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
7766:
7767: BEGIN

Line 7992: l_item_key wf_items.item_key%TYPE;

7988:
7989: l_send_email_yn VARCHAR2(1) := 'N';
7990: l_reason VARCHAR2(250);
7991:
7992: l_item_key wf_items.item_key%TYPE;
7993: l_result_out wf_item_activity_statuses.activity_result_code%TYPE;
7994: l_process_status VARCHAR2(30);
7995: l_activity_name VARCHAR2(30);
7996: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;

Line 8562: FROM WF_ITEMS WF,

8558: AND okck.template_yn = 'N'
8559: --no active approval workflow exists
8560: AND NOT EXISTS
8561: (SELECT 1
8562: FROM WF_ITEMS WF,
8563: OKC_PROCESS_DEFS_B KPDF
8564: WHERE WF.item_key = okck.contract_number || okck.contract_number_modifier
8565: AND WF.end_date IS NULL
8566: AND WF.item_type = KPDF.wf_name

Line 8571: FROM WF_ITEMS WF

8567: AND KPDF.pdf_type = 'WPS')
8568: --for an ENTERED status contract, no active base workflow exists
8569: AND NOT EXISTS
8570: (SELECT 1
8571: FROM WF_ITEMS WF
8572: WHERE WF.item_key = oksk.wf_item_key
8573: AND WF.end_date IS NULL
8574: AND WF.item_type = G_ITEM_TYPE);
8575: