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 1242: --OKC_CONTEXT.SET_OKC_ORG_CONTEXT ( p_org_id => l_k_header_rec.authoring_org_id,

1238: l_contact_tbl (l_ptr1).flag := 'K'; -- changed 17-jul-2003
1239: l_ptr1 := l_ptr1 + 1;
1240: END LOOP;
1241:
1242: --OKC_CONTEXT.SET_OKC_ORG_CONTEXT ( p_org_id => l_k_header_rec.authoring_org_id,
1243: -- p_organization_id => Null
1244: -- );
1245:
1246: ---mmadhavi sales credit bug 4174921

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

2427: FROM oe_order_lines_all ol, oe_order_headers oh
2428: WHERE oh.header_id = ol.header_id
2429: AND oh.order_number = p_ord_num;
2430:
2431: --and Oh.org_id = okc_context.get_okc_org_id;
2432:
2433: /*
2434: Cursor get_ordlines_dtls_csr(p_ord_line_id NUMBER)
2435: Is

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

2435: Is
2436: Select Nvl(FULFILLED_QUANTITY,0),SERVICE_REFERENCE_TYPE_CODE,SERVICE_REFERENCE_LINE_ID
2437: From oe_order_lines_all
2438: Where line_id = p_ord_line_id
2439: and header_id IN (select header_id from oe_order_headers_all where org_id = okc_context.get_okc_org_id);
2440: */
2441:
2442: --mmadhavi modified the cursor for MOAC
2443: CURSOR check_duplicate_csr (p_ordline_id NUMBER)

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

2467: l_first_order_line := NULL;
2468: l_ptr1 := 0;
2469:
2470: -- mmadhavi commenting for MOAC
2471: --FND_FILE.PUT_LINE (FND_FILE.LOG, ' Okc_context = ' || nvl(okc_context.get_okc_org_id,-999));
2472: OPEN get_order_lines_csr (p_ord_num);
2473:
2474: LOOP
2475: FETCH get_order_lines_csr

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

2884: SQLERRM
2885: );
2886: END get_order_details;
2887: BEGIN
2888: --Okc_context.set_okc_org_context (l_order_rec.org_id, NULL ); --mmadhavi commenting for MOAC
2889: l_prog_id := fnd_global.conc_program_id;
2890: l_req_id := fnd_global.conc_request_id;
2891: fnd_file.put_line (fnd_file.LOG, 'conc_prog_id = ' || l_prog_id);
2892: fnd_file.put_line (fnd_file.LOG, 'conc_req_id = ' || l_req_id);

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

3009: END IF;
3010:
3011: CLOSE l_order_csr;
3012:
3013: okc_context.set_okc_org_context (l_order_rec.org_id, NULL);
3014:
3015: --FND_FILE.PUT_LINE (FND_FILE.LOG, 'success_flag = '||NVL(l_repv_tbl(l_count).success_flag,'S'));
3016: IF (NVL (l_repv_tbl (l_count).source_flag, 'S') = 'MANUAL')
3017: THEN

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

3084: /*
3085: If Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') IN ('IB', 'MO') OR
3086: Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') Is NULL Then
3087:
3088: Okc_context.set_okc_org_context (l_order_rec.org_id, NULL );
3089:
3090: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SO' Then
3091:
3092: l_organization_id := Null;

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

3097: Else
3098: l_organization_id := Null;
3099: End If;
3100:
3101: Okc_context.set_okc_org_context (l_order_rec.org_id, l_organization_id);
3102:
3103: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SH' Then
3104:
3105: Okc_context.set_okc_org_context (l_order_rec.org_id, l_order_rec.ship_from_org_id);

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

3101: Okc_context.set_okc_org_context (l_order_rec.org_id, l_organization_id);
3102:
3103: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SH' Then
3104:
3105: Okc_context.set_okc_org_context (l_order_rec.org_id, l_order_rec.ship_from_org_id);
3106:
3107: End If;
3108: */
3109: l_cp_tbl.DELETE;

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

3136:
3137: /*modified for bug6181908 --fp bug6006309*/
3138: FOR rec IN
3139: l_custprod_csr
3140: (l_serv_ref_rec.service_reference_line_id, okc_context.get_okc_organization_id)
3141: LOOP
3142: fnd_file.put_line (fnd_file.LOG,
3143: 'L_CP_TBL CP ID '
3144: || rec.cp_id

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

3163:
3164: /*modified for bug6181908 -- fp bug6006309*/
3165: FOR rec IN
3166: l_custprod_csr
3167: (l_serv_ref_rec.service_reference_line_id, okc_context.get_okc_organization_id)
3168: LOOP
3169: fnd_file.put_line (fnd_file.LOG,
3170: 'L_CP_TBL CP ID '
3171: || rec.cp_id

Line 3850: AND oh.org_id = okc_context.get_okc_org_id

3846: IS
3847: SELECT oh.header_id, oh.order_number
3848: FROM oe_order_lines_all ol, oe_order_headers_all oh
3849: WHERE ol.line_id = (p_ordlineid)
3850: AND oh.org_id = okc_context.get_okc_org_id
3851: AND oh.header_id = ol.header_id;
3852:
3853: CURSOR l_order_csr (p_ordlineid NUMBER)
3854: IS

Line 4050: okc_context.set_okc_org_context (l_order_rec.org_id,

4046: fnd_file.put_line (fnd_file.LOG,
4047: 'Sold from Org Id '
4048: || l_order_rec.sold_from_org_id
4049: );
4050: okc_context.set_okc_org_context (l_order_rec.org_id,
4051: NULL);
4052: fnd_file.put_line (fnd_file.LOG,
4053: 'org_context - '
4054: || TO_CHAR (okc_context.get_okc_org_id)

Line 4054: || TO_CHAR (okc_context.get_okc_org_id)

4050: okc_context.set_okc_org_context (l_order_rec.org_id,
4051: NULL);
4052: fnd_file.put_line (fnd_file.LOG,
4053: 'org_context - '
4054: || TO_CHAR (okc_context.get_okc_org_id)
4055: );
4056: fnd_file.put_line
4057: (fnd_file.LOG,
4058: 'organization_context - '

Line 4060: (okc_context.get_okc_organization_id)

4056: fnd_file.put_line
4057: (fnd_file.LOG,
4058: 'organization_context - '
4059: || TO_CHAR
4060: (okc_context.get_okc_organization_id)
4061: );
4062:
4063: --Check IB Trackable flag
4064: IF NVL (l_line_tbl (l_count).service_reference_type_code,

Line 4070: okc_context.get_okc_organization_id

4066: ) = 'ORDER'
4067: THEN
4068: OPEN is_ib_trackable
4069: (l_line_tbl (l_count).service_reference_line_id,
4070: okc_context.get_okc_organization_id
4071: );
4072:
4073: FETCH is_ib_trackable
4074: INTO ib_flag;