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_EXTWAR_UTIL_PVT dependencies on OKC_CONTEXT

Line 41: okc_context.set_okc_org_context;

37: cursor l_sname_csr (p_resid number) is select name from jtf_rs_salesreps where resource_id = p_resid;
38: l_sname Varchar2(240);
39:
40: Begin
41: okc_context.set_okc_org_context;
42: l_org_id := okc_context.get_okc_org_id;
43:
44: MO_GLOBAL.set_org_context(p_org_id,Null);
45: FND_PROFILE.PUT ('ORG_ID',p_org_id);

Line 42: l_org_id := okc_context.get_okc_org_id;

38: l_sname Varchar2(240);
39:
40: Begin
41: okc_context.set_okc_org_context;
42: l_org_id := okc_context.get_okc_org_id;
43:
44: MO_GLOBAL.set_org_context(p_org_id,Null);
45: FND_PROFILE.PUT ('ORG_ID',p_org_id);
46:

Line 760: WHERE mtl.id2 = okc_context.get_okc_organization_id

756: WHERE bic.bill_sequence_id = c_bill_seq_id
757: AND EXISTS (
758: SELECT 'Component is a Warranty'
759: FROM okx_system_items_v mtl
760: WHERE mtl.id2 = okc_context.get_okc_organization_id
761: AND mtl.id1 = bic.component_item_id
762: AND mtl.vendor_warranty_flag = 'Y')
763: AND TRUNC (p_datec) >= TRUNC (bic.effectivity_date)
764: AND TRUNC (p_datec) <=

Line 772: WHERE organization_id = okc_context.get_okc_organization_id

768: CURSOR bill_seq_csr
769: IS
770: SELECT common_bill_sequence_id
771: FROM bom_bill_of_materials --OKX_BILL_OF_MATERIALS_V
772: WHERE organization_id = okc_context.get_okc_organization_id
773: AND assembly_item_id = p_inventory_item_id
774: AND alternate_bom_designator IS NULL;
775: BEGIN
776: x_return_status := 'S';

Line 886: AND b.organization_id = okc_context.get_okc_organization_id

882: b.coverage_schedule_id coverage_template_id
883: FROM mtl_system_items_b_kfv b, --okx_system_items_v mtl,
884: bom_inventory_components bic --okx_inv_components_v bic
885: WHERE bic.component_item_id = b.inventory_item_id
886: AND b.organization_id = okc_context.get_okc_organization_id
887: AND bic.bill_sequence_id = p_comm_bill_seq_id
888: AND bic.component_item_id = p_war_inv_item_id
889: AND TRUNC (l_war_date) >= TRUNC (bic.effectivity_date)
890: AND TRUNC (l_war_date) <=

Line 997: AND organization_id = okc_context.get_okc_organization_id;

993: IS
994: SELECT service_starting_delay
995: FROM mtl_system_items_b_kfv
996: WHERE inventory_item_id = p_prod_item_id
997: AND organization_id = okc_context.get_okc_organization_id;
998:
999: CURSOR get_ship_flag_csr
1000: IS
1001: SELECT DECODE (ol.actual_shipment_date,

Line 1018: Where mtl.id2 = okc_context.get_okc_organization_id

1014: And exists
1015: (
1016: Select 'Component is a Warranty'
1017: From OKX_SYSTEM_ITEMS_V mtl
1018: Where mtl.id2 = okc_context.get_okc_organization_id
1019: And mtl.id1 = bic.component_item_id
1020: And mtl.vendor_warranty_flag = 'Y'
1021: )
1022: Order by bic.component_item_id;

Line 1027: Where organization_id = okc_context.get_okc_organization_id

1023:
1024: Cursor Bill_Seq_Csr Is
1025: Select common_bill_sequence_id
1026: From BOM_BILL_OF_MATERIALS --OKX_BILL_OF_MATERIALS_V
1027: Where organization_id = okc_context.get_okc_organization_id
1028: And assembly_item_id = P_prod_item_id
1029: And alternate_bom_designator is Null;
1030:
1031: /* end of fix for bug#6047047-fp of bug#5939487 */

Line 1931: AND b.organization_id = okc_context.get_okc_organization_id;

1927: b.inventory_item_id = t.inventory_item_id
1928: AND b.organization_id = t.organization_id
1929: AND t.LANGUAGE = USERENV ('LANG')
1930: AND b.inventory_item_id = p_product_item
1931: AND b.organization_id = okc_context.get_okc_organization_id;
1932:
1933: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
1934: l_warranty_tbl war_tbl;
1935: l_ptr BINARY_INTEGER;

Line 2166: AND b.organization_id = okc_context.get_okc_organization_id;

2162: AND b.inventory_item_id = ol.inventory_item_id
2163: AND b.inventory_item_id = t.inventory_item_id
2164: AND b.organization_id = t.organization_id
2165: AND t.LANGUAGE = USERENV ('LANG')
2166: AND b.organization_id = okc_context.get_okc_organization_id;
2167:
2168: CURSOR get_csr_order_line_id (p_service_line_id NUMBER)
2169: IS
2170: SELECT actual_shipment_date

Line 3575: AND organization_id = okc_context.get_okc_organization_id;

3571: IS
3572: SELECT shippable_item_flag, service_starting_delay
3573: FROM okx_system_items_v
3574: WHERE id1 = p_prod_item_id
3575: AND organization_id = okc_context.get_okc_organization_id;
3576: BEGIN
3577: okc_context.set_okc_org_context (p_org_id => p_org_id,
3578: p_organization_id => NULL
3579: );

Line 3577: okc_context.set_okc_org_context (p_org_id => p_org_id,

3573: FROM okx_system_items_v
3574: WHERE id1 = p_prod_item_id
3575: AND organization_id = okc_context.get_okc_organization_id;
3576: BEGIN
3577: okc_context.set_okc_org_context (p_org_id => p_org_id,
3578: p_organization_id => NULL
3579: );
3580: x_return_status := okc_api.g_ret_sts_success;
3581:

Line 3733: AND b.organization_id = okc_context.get_okc_organization_id;

3729: AND csi.inventory_item_id = b.inventory_item_id
3730: AND b.inventory_item_id = t.inventory_item_id
3731: AND b.organization_id = t.organization_id
3732: AND t.LANGUAGE = USERENV ('LANG')
3733: AND b.organization_id = okc_context.get_okc_organization_id;
3734:
3735: CURSOR order_csr (p_line_id NUMBER)
3736: IS
3737: SELECT ol.header_id, oh.transactional_curr_code, oh.cust_po_number,

Line 3807: X_hdr_rec.currency := OKC_CURRENCY_API.GET_OU_CURRENCY(okc_context.get_okc_org_id);

3803: x_hdr_rec.order_hdr_id := order_rec.header_id;
3804: END IF;
3805:
3806: /*If Order_rec.Transactional_curr_code Is Null Then
3807: X_hdr_rec.currency := OKC_CURRENCY_API.GET_OU_CURRENCY(okc_context.get_okc_org_id);
3808:
3809: End If;*/
3810: x_hdr_rec.contract_number := NULL;
3811: x_hdr_rec.start_date := NULL;

Line 4026: AND srp.org_id = okc_context.get_okc_

4022: --AND nvl(rrl.end_date_active,TO_DATE('01/01/4713','MM/DD/RRRR')) >=
4023: --:NAME_IN('OKS_HEADER_CONTACTS.START_DATE')
4024: -- AND rrl.start_date_active <= :NAME_IN('OKS_HEADER_CONTACTS END_DATE ')
4025: AND srp.salesrep_id = p_salesrep_id
4026: AND srp.org_id = okc_context.get_okc_
4027: -- AND :END_DATE BETWEEN grp.start_date_active AND
4028: -- NVL(grp.end_date_active,TO_DATE('01/01/4713','MM/DD/RRRR'))
4029: UNION ALL
4030: SELECT group_name, group_id