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 996: AND organization_id = okc_context.get_okc_organization_id;

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

Line 1017: Where mtl.id2 = okc_context.get_okc_organization_id

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

Line 1026: Where organization_id = okc_context.get_okc_organization_id

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

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

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

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

2157: AND b.inventory_item_id = ol.inventory_item_id
2158: AND b.inventory_item_id = t.inventory_item_id
2159: AND b.organization_id = t.organization_id
2160: AND t.LANGUAGE = USERENV ('LANG')
2161: AND b.organization_id = okc_context.get_okc_organization_id;
2162:
2163: CURSOR get_csr_order_line_id (p_service_line_id NUMBER)
2164: IS
2165: SELECT actual_shipment_date

Line 3529: AND organization_id = okc_context.get_okc_organization_id;

3525: IS
3526: SELECT shippable_item_flag, service_starting_delay
3527: FROM okx_system_items_v
3528: WHERE id1 = p_prod_item_id
3529: AND organization_id = okc_context.get_okc_organization_id;
3530: BEGIN
3531: okc_context.set_okc_org_context (p_org_id => p_org_id,
3532: p_organization_id => NULL
3533: );

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

3527: FROM okx_system_items_v
3528: WHERE id1 = p_prod_item_id
3529: AND organization_id = okc_context.get_okc_organization_id;
3530: BEGIN
3531: okc_context.set_okc_org_context (p_org_id => p_org_id,
3532: p_organization_id => NULL
3533: );
3534: x_return_status := okc_api.g_ret_sts_success;
3535:

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

3683: AND csi.inventory_item_id = b.inventory_item_id
3684: AND b.inventory_item_id = t.inventory_item_id
3685: AND b.organization_id = t.organization_id
3686: AND t.LANGUAGE = USERENV ('LANG')
3687: AND b.organization_id = okc_context.get_okc_organization_id;
3688:
3689: CURSOR order_csr (p_line_id NUMBER)
3690: IS
3691: SELECT ol.header_id, oh.transactional_curr_code, oh.cust_po_number,

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

3757: x_hdr_rec.order_hdr_id := order_rec.header_id;
3758: END IF;
3759:
3760: /*If Order_rec.Transactional_curr_code Is Null Then
3761: X_hdr_rec.currency := OKC_CURRENCY_API.GET_OU_CURRENCY(okc_context.get_okc_org_id);
3762:
3763: End If;*/
3764: x_hdr_rec.contract_number := NULL;
3765: x_hdr_rec.start_date := NULL;

Line 3980: AND srp.org_id = okc_context.get_okc_

3976: --AND nvl(rrl.end_date_active,TO_DATE('01/01/4713','MM/DD/RRRR')) >=
3977: --:NAME_IN('OKS_HEADER_CONTACTS.START_DATE')
3978: -- AND rrl.start_date_active <= :NAME_IN('OKS_HEADER_CONTACTS END_DATE ')
3979: AND srp.salesrep_id = p_salesrep_id
3980: AND srp.org_id = okc_context.get_okc_
3981: -- AND :END_DATE BETWEEN grp.start_date_active AND
3982: -- NVL(grp.end_date_active,TO_DATE('01/01/4713','MM/DD/RRRR'))
3983: UNION ALL
3984: SELECT group_name, group_id