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

Line 146: AND oh.org_id = okc_context.get_okc_org_id

142: IS
143: SELECT oh.header_id, oh.order_number
144: FROM oe_order_lines_all ol, oe_order_headers_all oh
145: WHERE ol.line_id = (p_ordlineid)
146: AND oh.org_id = okc_context.get_okc_org_id
147: AND oh.header_id = ol.header_id;
148:
149: CURSOR l_order_csr (p_ordlineid NUMBER)
150: IS

Line 359: okc_context.set_okc_org_context (l_order_rec.org_id,

355: fnd_file.put_line (fnd_file.LOG,
356: 'Sold from Org Id '
357: || l_order_rec.sold_from_org_id
358: );
359: okc_context.set_okc_org_context (l_order_rec.org_id,
360: NULL);
361: fnd_file.put_line (fnd_file.LOG,
362: 'org_context - '
363: || TO_CHAR (okc_context.get_okc_org_id)

Line 363: || TO_CHAR (okc_context.get_okc_org_id)

359: okc_context.set_okc_org_context (l_order_rec.org_id,
360: NULL);
361: fnd_file.put_line (fnd_file.LOG,
362: 'org_context - '
363: || TO_CHAR (okc_context.get_okc_org_id)
364: );
365: fnd_file.put_line
366: (fnd_file.LOG,
367: 'organization_context - '

Line 369: (okc_context.get_okc_organization_id)

365: fnd_file.put_line
366: (fnd_file.LOG,
367: 'organization_context - '
368: || TO_CHAR
369: (okc_context.get_okc_organization_id)
370: );
371:
372: --Check IB Trackable flag
373: IF NVL (l_line_tbl (l_count).service_reference_type_code,

Line 379: okc_context.get_okc_organization_id

375: ) = 'ORDER'
376: THEN
377: OPEN is_ib_trackable
378: (l_line_tbl (l_count).service_reference_line_id,
379: okc_context.get_okc_organization_id
380: );
381:
382: FETCH is_ib_trackable
383: INTO ib_flag;

Line 389: Open csi_ib_trackable(l_line_tbl(l_count).service_reference_line_id, okc_context.get_okc_organization_id);

385: CLOSE is_ib_trackable;
386: ELSE
387: --BUG6181908 --FP Bug 6006309
388: -- ib_flag := 'Y';
389: Open csi_ib_trackable(l_line_tbl(l_count).service_reference_line_id, okc_context.get_okc_organization_id);
390: Fetch csi_ib_trackable into ib_flag;
391: Close csi_ib_trackable;
392: --BUG6181908 --FP Bug 6006309
393:

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

945: AND b.inventory_item_id = ol.inventory_item_id
946: AND b.inventory_item_id = t.inventory_item_id
947: AND b.organization_id = t.organization_id
948: AND t.LANGUAGE = USERENV ('LANG')
949: AND b.organization_id = okc_context.get_okc_organization_id;
950:
951: CURSOR Check_Contract_Exists(p_instance_id NUMBER,p_order_header_id NUMBER) IS
952: SELECT okro.chr_id
953: FROM okc_k_rel_objs okro,oe_order_lines_all ol,csi_item_instances csi

Line 1408: --OKC_CONTEXT.SET_OKC_ORG_CONTEXT ( p_org_id => l_k_header_rec.authoring_org_id,

1404: l_contact_tbl (l_ptr1).flag := 'K'; -- changed 17-jul-2003
1405: l_ptr1 := l_ptr1 + 1;
1406: END LOOP;
1407:
1408: --OKC_CONTEXT.SET_OKC_ORG_CONTEXT ( p_org_id => l_k_header_rec.authoring_org_id,
1409: -- p_organization_id => Null
1410: -- );
1411:
1412: ---mmadhavi sales credit bug 4174921

Line 3075: --and Oh.org_id = okc_context.get_okc_org_id;

3071: FROM oe_order_lines_all ol, oe_order_headers oh
3072: WHERE oh.header_id = ol.header_id
3073: AND oh.order_number = p_ord_num;
3074:
3075: --and Oh.org_id = okc_context.get_okc_org_id;
3076:
3077: /*
3078: Cursor get_ordlines_dtls_csr(p_ord_line_id NUMBER)
3079: Is

Line 3083: and header_id IN (select header_id from oe_order_headers_all where org_id = okc_context.get_okc_org_id);

3079: Is
3080: Select Nvl(FULFILLED_QUANTITY,0),SERVICE_REFERENCE_TYPE_CODE,SERVICE_REFERENCE_LINE_ID
3081: From oe_order_lines_all
3082: Where line_id = p_ord_line_id
3083: and header_id IN (select header_id from oe_order_headers_all where org_id = okc_context.get_okc_org_id);
3084: */
3085:
3086: --mmadhavi modified the cursor for MOAC
3087: CURSOR check_duplicate_csr (p_ordline_id NUMBER)

Line 3115: --FND_FILE.PUT_LINE (FND_FILE.LOG, ' Okc_context = ' || nvl(okc_context.get_okc_org_id,-999));

3111: l_first_order_line := NULL;
3112: l_ptr1 := 0;
3113:
3114: -- mmadhavi commenting for MOAC
3115: --FND_FILE.PUT_LINE (FND_FILE.LOG, ' Okc_context = ' || nvl(okc_context.get_okc_org_id,-999));
3116: OPEN get_order_lines_csr (p_ord_num);
3117:
3118: LOOP
3119: FETCH get_order_lines_csr

Line 3532: --Okc_context.set_okc_org_context (l_order_rec.org_id, NULL ); --mmadhavi commenting for MOAC

3528: SQLERRM
3529: );
3530: END get_order_details;
3531: BEGIN
3532: --Okc_context.set_okc_org_context (l_order_rec.org_id, NULL ); --mmadhavi commenting for MOAC
3533: l_prog_id := fnd_global.conc_program_id;
3534: l_req_id := fnd_global.conc_request_id;
3535: fnd_file.put_line (fnd_file.LOG, 'conc_prog_id = ' || l_prog_id);
3536: fnd_file.put_line (fnd_file.LOG, 'conc_req_id = ' || l_req_id);

Line 3657: okc_context.set_okc_org_context (l_order_rec.org_id, NULL);

3653: END IF;
3654:
3655: CLOSE l_order_csr;
3656:
3657: okc_context.set_okc_org_context (l_order_rec.org_id, NULL);
3658:
3659: --FND_FILE.PUT_LINE (FND_FILE.LOG, 'success_flag = '||NVL(l_repv_tbl(l_count).success_flag,'S'));
3660: IF (NVL (l_repv_tbl (l_count).source_flag, 'S') = 'MANUAL')
3661: THEN

Line 3732: Okc_context.set_okc_org_context (l_order_rec.org_id, NULL );

3728: /*
3729: If Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') IN ('IB', 'MO') OR
3730: Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') Is NULL Then
3731:
3732: Okc_context.set_okc_org_context (l_order_rec.org_id, NULL );
3733:
3734: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SO' Then
3735:
3736: l_organization_id := Null;

Line 3745: Okc_context.set_okc_org_context (l_order_rec.org_id, l_organization_id);

3741: Else
3742: l_organization_id := Null;
3743: End If;
3744:
3745: Okc_context.set_okc_org_context (l_order_rec.org_id, l_organization_id);
3746:
3747: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SH' Then
3748:
3749: Okc_context.set_okc_org_context (l_order_rec.org_id, l_order_rec.ship_from_org_id);

Line 3749: Okc_context.set_okc_org_context (l_order_rec.org_id, l_order_rec.ship_from_org_id);

3745: Okc_context.set_okc_org_context (l_order_rec.org_id, l_organization_id);
3746:
3747: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SH' Then
3748:
3749: Okc_context.set_okc_org_context (l_order_rec.org_id, l_order_rec.ship_from_org_id);
3750:
3751: End If;
3752: */
3753: l_cp_tbl.DELETE;

Line 3784: (l_serv_ref_rec.service_reference_line_id, okc_context.get_okc_organization_id)

3780:
3781: /*modified for bug6181908 --fp bug6006309*/
3782: FOR rec IN
3783: l_custprod_csr
3784: (l_serv_ref_rec.service_reference_line_id, okc_context.get_okc_organization_id)
3785: LOOP
3786: fnd_file.put_line (fnd_file.LOG,
3787: 'L_CP_TBL CP ID '
3788: || rec.cp_id

Line 3811: (l_serv_ref_rec.service_reference_line_id, okc_context.get_okc_organization_id)

3807:
3808: /*modified for bug6181908 -- fp bug6006309*/
3809: FOR rec IN
3810: l_custprod_csr
3811: (l_serv_ref_rec.service_reference_line_id, okc_context.get_okc_organization_id)
3812: LOOP
3813: fnd_file.put_line (fnd_file.LOG,
3814: 'L_CP_TBL CP ID '
3815: || rec.cp_id

Line 4494: AND oh.org_id = okc_context.get_okc_org_id

4490: IS
4491: SELECT oh.header_id, oh.order_number
4492: FROM oe_order_lines_all ol, oe_order_headers_all oh
4493: WHERE ol.line_id = (p_ordlineid)
4494: AND oh.org_id = okc_context.get_okc_org_id
4495: AND oh.header_id = ol.header_id;
4496:
4497: CURSOR l_order_csr (p_ordlineid NUMBER)
4498: IS

Line 4694: okc_context.set_okc_org_context (l_order_rec.org_id,

4690: fnd_file.put_line (fnd_file.LOG,
4691: 'Sold from Org Id '
4692: || l_order_rec.sold_from_org_id
4693: );
4694: okc_context.set_okc_org_context (l_order_rec.org_id,
4695: NULL);
4696: fnd_file.put_line (fnd_file.LOG,
4697: 'org_context - '
4698: || TO_CHAR (okc_context.get_okc_org_id)

Line 4698: || TO_CHAR (okc_context.get_okc_org_id)

4694: okc_context.set_okc_org_context (l_order_rec.org_id,
4695: NULL);
4696: fnd_file.put_line (fnd_file.LOG,
4697: 'org_context - '
4698: || TO_CHAR (okc_context.get_okc_org_id)
4699: );
4700: fnd_file.put_line
4701: (fnd_file.LOG,
4702: 'organization_context - '

Line 4704: (okc_context.get_okc_organization_id)

4700: fnd_file.put_line
4701: (fnd_file.LOG,
4702: 'organization_context - '
4703: || TO_CHAR
4704: (okc_context.get_okc_organization_id)
4705: );
4706:
4707: --Check IB Trackable flag
4708: IF NVL (l_line_tbl (l_count).service_reference_type_code,

Line 4714: okc_context.get_okc_organization_id

4710: ) = 'ORDER'
4711: THEN
4712: OPEN is_ib_trackable
4713: (l_line_tbl (l_count).service_reference_line_id,
4714: okc_context.get_okc_organization_id
4715: );
4716:
4717: FETCH is_ib_trackable
4718: INTO ib_flag;