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

Line 2318: AND a.org_id = okc_context.get_okc_org_id;

2314: SELECT a.id1
2315: FROM okx_cust_sites_v a, okx_cust_contacts_v b
2316: WHERE b.id1 = p_contact_id
2317: AND a.id1 = b.cust_acct_site_id
2318: AND a.org_id = okc_context.get_okc_org_id;
2319:
2320: -- party contact id
2321: CURSOR party_cont_cur (p_contact_id NUMBER)
2322: IS

Line 2375: AND org_id = okc_context.get_okc_org_id

2371: IS
2372: SELECT GROUP_ID
2373: FROM jtf_rs_srp_groups
2374: WHERE salesrep_id = p_id
2375: AND org_id = okc_context.get_okc_org_id
2376: AND p_start_date BETWEEN start_date AND end_date
2377: AND p_end_date BETWEEN start_date AND end_date;
2378:
2379: CURSOR l_bookdt_csr (p_ord_hdrid NUMBER)

Line 2626: okc_context.get_okc_organization_id

2622: l_chrv_tbl_in (1).scs_code := NVL (p_k_header_rec.scs_code, 'WARRANTY');
2623: l_chrv_tbl_in (1).authoring_org_id := p_k_header_rec.authoring_org_id;
2624: l_chrv_tbl_in (1).inv_organization_id :=
2625: NVL (p_k_header_rec.inv_organization_id,
2626: okc_context.get_okc_organization_id
2627: );
2628: l_chrv_tbl_in (1).pre_pay_req_yn := 'N';
2629: l_chrv_tbl_in (1).cust_po_number := p_k_header_rec.cust_po_number;
2630: l_chrv_tbl_in (1).qcl_id := p_k_header_rec.qcl_id;

Line 3295: l_new_org_id := okc_context.get_okc_org_id;

3291: send_notification (p_k_header_rec.order_hdr_id, NULL, 'NRS');
3292: End If;
3293: ELSIF l_count >= 1
3294: THEN
3295: l_new_org_id := okc_context.get_okc_org_id;
3296:
3297: OPEN l_salesrep_csr (l_derived_res_id, l_new_org_id);
3298:
3299: FETCH l_salesrep_csr

Line 3329: IF (Nvl(OKS_EXTWARPRGM_PVT.G_TRF_K_CREATE,'N') ='Y') AND (l_auth_org_id<>(nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99)))THEN

3325: OPEN get_k_auth_org(l_chrid);
3326: FETCH get_k_auth_org INTO l_auth_org_id;
3327: CLOSE get_k_auth_org;
3328:
3329: IF (Nvl(OKS_EXTWARPRGM_PVT.G_TRF_K_CREATE,'N') ='Y') AND (l_auth_org_id<>(nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99)))THEN
3330: l_okc_org_id := l_auth_org_id;
3331: ELSE
3332: l_okc_org_id := Okc_context.get_okc_org_id;
3333: END IF;

Line 3332: l_okc_org_id := Okc_context.get_okc_org_id;

3328:
3329: IF (Nvl(OKS_EXTWARPRGM_PVT.G_TRF_K_CREATE,'N') ='Y') AND (l_auth_org_id<>(nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99)))THEN
3330: l_okc_org_id := l_auth_org_id;
3331: ELSE
3332: l_okc_org_id := Okc_context.get_okc_org_id;
3333: END IF;
3334:
3335: /*spingali BUGFIX FOR BUG12747411-END salesperson*/
3336:

Line 3340: p_org_id => okc_context.get_okc_org_id,

3336:
3337: l_salesgroup_id :=
3338: jtf_rs_integration_pub.get_default_sales_group
3339: (p_salesrep_id => l_salesrep_id,
3340: p_org_id => okc_context.get_okc_org_id,
3341: p_date => p_k_header_rec.start_date
3342: );
3343: l_ctcv_tbl_in (1).object1_id1 := l_salesrep_id;
3344: l_ctcv_tbl_in (1).cpl_id := l_partyid_v;

Line 3902: AND org_id = okc_context.get_okc_org_id

3898: IS
3899: SELECT GROUP_ID
3900: FROM jtf_rs_srp_groups
3901: WHERE salesrep_id = p_id
3902: AND org_id = okc_context.get_okc_org_id
3903: AND p_start_date BETWEEN start_date AND end_date
3904: AND p_end_date BETWEEN start_date AND end_date;
3905:
3906: /*spingali - bugfix for bug12747411*/

Line 4530: IF (Nvl(OKS_EXTWARPRGM_PVT.G_TRF_K_CREATE,'N') ='Y') AND (l_inv_org_id<>(nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99)))THEN

4526: OPEN get_k_inv_org(p_k_line_rec.k_id);
4527: FETCH get_k_inv_org INTO l_inv_org_id;
4528: CLOSE get_k_inv_org;
4529:
4530: IF (Nvl(OKS_EXTWARPRGM_PVT.G_TRF_K_CREATE,'N') ='Y') AND (l_inv_org_id<>(nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99)))THEN
4531: l_cimv_tbl_in( 1 ).object1_id2 := l_inv_org_id;
4532: ELSE
4533: l_cimv_tbl_in( 1 ).object1_id2 := okc_context.get_okc_organization_id;
4534: END IF;

Line 4533: l_cimv_tbl_in( 1 ).object1_id2 := okc_context.get_okc_organization_id;

4529:
4530: IF (Nvl(OKS_EXTWARPRGM_PVT.G_TRF_K_CREATE,'N') ='Y') AND (l_inv_org_id<>(nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99)))THEN
4531: l_cimv_tbl_in( 1 ).object1_id2 := l_inv_org_id;
4532: ELSE
4533: l_cimv_tbl_in( 1 ).object1_id2 := okc_context.get_okc_organization_id;
4534: END IF;
4535: /*spingali bugfix for bug12747411 - end */
4536: ---l_cimv_tbl_in (1).object1_id2 := okc_context.get_okc_organization_id;
4537: l_cimv_tbl_in (1).jtot_object1_code := l_jtot_object;

Line 4536: ---l_cimv_tbl_in (1).object1_id2 := okc_context.get_okc_organization_id;

4532: ELSE
4533: l_cimv_tbl_in( 1 ).object1_id2 := okc_context.get_okc_organization_id;
4534: END IF;
4535: /*spingali bugfix for bug12747411 - end */
4536: ---l_cimv_tbl_in (1).object1_id2 := okc_context.get_okc_organization_id;
4537: l_cimv_tbl_in (1).jtot_object1_code := l_jtot_object;
4538: l_cimv_tbl_in (1).exception_yn := 'N';
4539: /*Modified for ER 16036980*/
4540: IF l_lsl_id <> 46 THEN

Line 4582: + okc_context.get_okc_organization_id

4578: g_col_name_token,
4579: 'Service Inventory Item ID '
4580: || p_k_line_rec.srv_id
4581: || ' ORG '
4582: + okc_context.get_okc_organization_id
4583: );
4584: RAISE g_exception_halt_validation;
4585: END IF;
4586:

Line 7004: okc_context.set_okc_org_context

7000: THEN
7001: l_ctr := p_kdtl_tbl.FIRST;
7002:
7003: LOOP
7004: okc_context.set_okc_org_context
7005: (p_kdtl_tbl (l_ctr).hdr_org_id,
7006: p_kdtl_tbl (l_ctr).organization_id
7007: );
7008: l_inst_dtls_tbl.DELETE;

Line 7884: okc_context.set_okc_org_context

7880: THEN
7881: l_ctr := p_kdtl_tbl.FIRST;
7882:
7883: LOOP
7884: okc_context.set_okc_org_context
7885: (p_kdtl_tbl (l_ctr).hdr_org_id,
7886: p_kdtl_tbl (l_ctr).organization_id
7887: );
7888: l_inst_dtls_tbl.DELETE;

Line 8861: okc_context.set_okc_org_context

8857: l_chrv_tbl_in.delete;
8858:
8859: l_inst_dtls_tbl.DELETE;
8860:
8861: okc_context.set_okc_org_context
8862: (p_kdtl_tbl (l_ctr).hdr_org_id,
8863: p_kdtl_tbl (l_ctr).organization_id
8864: );
8865: get_sts_code (NULL,

Line 11131: okc_context.set_okc_org_context

11127: LOOP
11128: --Fix for Bug 5406201
11129: l_clev_tbl_in.delete;
11130: l_chrv_tbl_in.delete;
11131: okc_context.set_okc_org_context
11132: (p_kdtl_tbl (l_ctr).hdr_org_id,
11133: p_kdtl_tbl (l_ctr).organization_id
11134: );
11135: get_party_id (p_kdtl_tbl (l_ctr).new_account_id,

Line 14305: okc_context.set_okc_org_context

14301: l_chrv_tbl_in.delete;
14302: l_inst_dtls_tbl.DELETE;
14303:
14304:
14305: okc_context.set_okc_org_context
14306: (p_kdtl_tbl (l_ctr).hdr_org_id,
14307: p_kdtl_tbl (l_ctr).organization_id
14308: );
14309: get_sts_code (NULL,

Line 15028: okc_context.set_okc_org_context

15024: THEN
15025: l_ctr := p_kdtl_tbl.FIRST;
15026:
15027: LOOP
15028: okc_context.set_okc_org_context
15029: (p_kdtl_tbl (l_ctr).hdr_org_id,
15030: p_kdtl_tbl (l_ctr).organization_id
15031: );
15032:

Line 15787: AND mtl.organization_id = okc_context.get_okc_organization_id;

15783: IS
15784: SELECT mtl.NAME, mtl.description
15785: FROM okx_system_items_v mtl
15786: WHERE mtl.inventory_item_id = p_inventory_item_id
15787: AND mtl.organization_id = okc_context.get_okc_organization_id;
15788:
15789: CURSOR l_bill_csr (p_cle_id NUMBER)
15790: IS
15791: SELECT SUM (amount)

Line 15907: okc_context.set_okc_org_context

15903:
15904: LOOP
15905: l_ptr := 1;
15906: l_inst_dtls_tbl.DELETE;
15907: okc_context.set_okc_org_context
15908: (p_kdtl_tbl (l_ctr).hdr_org_id,
15909: p_kdtl_tbl (l_ctr).organization_id
15910: );
15911: