DBA Data[Home] [Help]

APPS.OKS_OMINT_PUB dependencies on OKC_CONTEXT

Line 528: if okc_context.get_okc_org_id IS NULL

524: Close l_product_item_id_csr;
525: End If;
526: /* start fixes 4605912
527: --set org_id if it is null
528: if okc_context.get_okc_org_id IS NULL
529: then
530: okc_context.set_okc_org_context;
531: end if;
532:

Line 530: okc_context.set_okc_org_context;

526: /* start fixes 4605912
527: --set org_id if it is null
528: if okc_context.get_okc_org_id IS NULL
529: then
530: okc_context.set_okc_org_context;
531: end if;
532:
533: l_organization_id := okc_context.get_okc_organization_id;
534: end fixes 4605912*/

Line 533: l_organization_id := okc_context.get_okc_organization_id;

529: then
530: okc_context.set_okc_org_context;
531: end if;
532:
533: l_organization_id := okc_context.get_okc_organization_id;
534: end fixes 4605912*/
535:
536: --NPALEPU 21-sep-2005 for bug # 4608694
537:

Line 544: /* okc_context.set_okc_org_context(p_org_id =>P_ORG_ID); */

540: l_original_access_mode := mo_global.get_access_mode();
541:
542: IF p_org_id IS NOT NULL THEN
543: --npalepu added on 23-dec-2005 for bug # 4897884
544: /* okc_context.set_okc_org_context(p_org_id =>P_ORG_ID); */
545: l_org_id := p_org_id;
546: --end 4897884
547: ELSIF l_original_org_id IS NOT NULL THEN
548: --npalepu added on 23-dec-2005 for bug # 4897884

Line 549: /* okc_context.set_okc_org_context(p_org_id =>l_original_org_id); */

545: l_org_id := p_org_id;
546: --end 4897884
547: ELSIF l_original_org_id IS NOT NULL THEN
548: --npalepu added on 23-dec-2005 for bug # 4897884
549: /* okc_context.set_okc_org_context(p_org_id =>l_original_org_id); */
550: l_org_id := l_original_org_id;
551: --end 4897884
552: ELSE
553: --npalepu added on 23-dec-2005 for bug # 4897884

Line 554: /* okc_context.set_okc_org_context; */

550: l_org_id := l_original_org_id;
551: --end 4897884
552: ELSE
553: --npalepu added on 23-dec-2005 for bug # 4897884
554: /* okc_context.set_okc_org_context; */
555: mo_utils.get_default_ou(l_default_org_id, l_default_ou_name, l_ou_count);
556: l_org_id := l_default_org_id;
557: --end 4897884
558: END IF;

Line 741: /* And ORGANIZATION_ID = okc_context.get_okc_organization_id */

737: And SERVICE_ITEM_FLAG = 'Y'
738: AND CUSTOMER_ORDER_ENABLED_FLAG = 'Y'
739: AND DECODE(ENABLED_FLAG,'Y','A','I') = 'A'
740: --npalepu modified on 23-dec-2005 for bug # 4897884
741: /* And ORGANIZATION_ID = okc_context.get_okc_organization_id */
742: And ORGANIZATION_ID = v_organization_id
743: --end 4897884
744: order by CONCATENATED_SEGMENTS;
745:

Line 784: if okc_context.get_okc_org_id IS NULL then

780:
781: --NPALEPU 21-sep-2005 for bug # 4608694
782:
783: /* --set org_id if it is null
784: if okc_context.get_okc_org_id IS NULL then
785: okc_context.set_okc_org_context;
786: end if; */
787:
788: --capturing the original context

Line 785: okc_context.set_okc_org_context;

781: --NPALEPU 21-sep-2005 for bug # 4608694
782:
783: /* --set org_id if it is null
784: if okc_context.get_okc_org_id IS NULL then
785: okc_context.set_okc_org_context;
786: end if; */
787:
788: --capturing the original context
789: l_original_org_id := mo_global.get_current_org_id;

Line 794: /* okc_context.set_okc_org_context(p_org_id =>P_ORG_ID); */

790: l_original_access_mode := mo_global.get_access_mode();
791:
792: IF p_org_id IS NOT NULL THEN
793: --npalepu added on 23-dec-2005 for bug # 4897884
794: /* okc_context.set_okc_org_context(p_org_id =>P_ORG_ID); */
795: l_org_id := p_org_id;
796: --end 4897884
797: ELSIF l_original_org_id IS NOT NULL THEN
798: --npalepu added on 23-dec-2005 for bug # 4897884

Line 799: /* okc_context.set_okc_org_context(p_org_id =>l_original_org_id); */

795: l_org_id := p_org_id;
796: --end 4897884
797: ELSIF l_original_org_id IS NOT NULL THEN
798: --npalepu added on 23-dec-2005 for bug # 4897884
799: /* okc_context.set_okc_org_context(p_org_id =>l_original_org_id); */
800: l_org_id := l_original_org_id;
801: --end 4897884
802: ELSE
803: --npalepu added on 23-dec-2005 for bug # 4897884

Line 804: /* okc_context.set_okc_org_context; */

800: l_org_id := l_original_org_id;
801: --end 4897884
802: ELSE
803: --npalepu added on 23-dec-2005 for bug # 4897884
804: /* okc_context.set_okc_org_context; */
805: mo_utils.get_default_ou(l_default_org_id, l_default_ou_name, l_ou_count);
806: l_org_id := l_default_org_id;
807: --end 4897884
808: END IF;

Line 947: /* And B.ORGANIZATION_ID = okc_context.get_okc_organization_id; */

943: And B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
944: AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
945: AND T.LANGUAGE = userenv('LANG')
946: --npalepu modified on 23-dec-2005 for bug # 4897884
947: /* And B.ORGANIZATION_ID = okc_context.get_okc_organization_id; */
948: AND B.ORGANIZATION_ID = v_organization_id;
949: --end 4897884
950:
951: Cursor l_party_csr (l_custid Number) Is

Line 1004: if okc_context.get_okc_org_id IS NULL then

1000:
1001: --NPALEPU 21-sep-2005 for bug # 4608694
1002:
1003: /* --set org_id if it is null
1004: if okc_context.get_okc_org_id IS NULL then
1005: okc_context.set_okc_org_context;
1006: end if; */
1007:
1008: --capturing the original context

Line 1005: okc_context.set_okc_org_context;

1001: --NPALEPU 21-sep-2005 for bug # 4608694
1002:
1003: /* --set org_id if it is null
1004: if okc_context.get_okc_org_id IS NULL then
1005: okc_context.set_okc_org_context;
1006: end if; */
1007:
1008: --capturing the original context
1009: l_original_org_id := mo_global.get_current_org_id;

Line 1014: /* okc_context.set_okc_org_context(p_org_id =>P_ORG_ID); */

1010: l_original_access_mode := mo_global.get_access_mode();
1011:
1012: IF p_org_id IS NOT NULL THEN
1013: --npalepu added on 23-dec-2005 for bug # 4897884
1014: /* okc_context.set_okc_org_context(p_org_id =>P_ORG_ID); */
1015: l_org_id := p_org_id;
1016: --end 4897884
1017: ELSIF l_original_org_id IS NOT NULL THEN
1018: --npalepu added on 23-dec-2005 for bug # 4897884

Line 1019: /* okc_context.set_okc_org_context(p_org_id =>l_original_org_id); */

1015: l_org_id := p_org_id;
1016: --end 4897884
1017: ELSIF l_original_org_id IS NOT NULL THEN
1018: --npalepu added on 23-dec-2005 for bug # 4897884
1019: /* okc_context.set_okc_org_context(p_org_id =>l_original_org_id); */
1020: l_org_id := l_original_org_id;
1021: --end 4897884
1022: ELSE
1023: --npalepu added on 23-dec-2005 for bug # 4897884

Line 1024: /* okc_context.set_okc_org_context; */

1020: l_org_id := l_original_org_id;
1021: --end 4897884
1022: ELSE
1023: --npalepu added on 23-dec-2005 for bug # 4897884
1024: /* okc_context.set_okc_org_context; */
1025: mo_utils.get_default_ou(l_default_org_id, l_default_ou_name, l_ou_count);
1026: l_org_id := l_default_org_id;
1027: --end 4897884
1028: END IF;

Line 1445: AND mtl.id2 = OKC_CONTEXT.GET_OKC_ORGANIZATION_ID

1441: oe_order_lines_all ol,
1442: okx_system_items_v mtl
1443: WHERE csi.inventory_item_id = mtl.id1
1444: AND ol.inventory_item_id = csi.inventory_item_id
1445: AND mtl.id2 = OKC_CONTEXT.GET_OKC_ORGANIZATION_ID
1446: AND csi.last_oe_order_line_id = ol.line_id
1447: AND ol.line_id = p_line_id;
1448:
1449: Cursor l_product_csr(p_cp_id Number) Is

Line 1485: Okc_context.set_okc_org_context (l_line_rec.org_id, l_line_rec.ship_from_org_id);

1481: Close l_oline_csr;
1482:
1483: /* Added for Bug#15885433*/
1484: If Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'IB' OR Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') Is NULL Then
1485: Okc_context.set_okc_org_context (l_line_rec.org_id, l_line_rec.ship_from_org_id);
1486: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'MO' Then
1487: Okc_context.set_okc_org_context (l_line_rec.org_id, NULL );
1488: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SO' Then
1489: l_organization_id := Null;

Line 1487: Okc_context.set_okc_org_context (l_line_rec.org_id, NULL );

1483: /* Added for Bug#15885433*/
1484: If Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'IB' OR Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') Is NULL Then
1485: Okc_context.set_okc_org_context (l_line_rec.org_id, l_line_rec.ship_from_org_id);
1486: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'MO' Then
1487: Okc_context.set_okc_org_context (l_line_rec.org_id, NULL );
1488: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SO' Then
1489: l_organization_id := Null;
1490: If l_line_rec.sold_from_org_id Is Not Null Then
1491: Open l_organization_csr(l_line_rec.sold_from_org_id);

Line 1497: Okc_context.set_okc_org_context (l_line_rec.org_id, l_organization_id);

1493: Close l_organization_csr;
1494: Else
1495: l_organization_id := Null;
1496: End If;
1497: Okc_context.set_okc_org_context (l_line_rec.org_id, l_organization_id);
1498: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SH' Then
1499: Okc_context.set_okc_org_context (l_line_rec.org_id, l_line_rec.ship_from_org_id);
1500: End If;
1501: /* End of Code Added for Bug#15885433*/

Line 1499: Okc_context.set_okc_org_context (l_line_rec.org_id, l_line_rec.ship_from_org_id);

1495: l_organization_id := Null;
1496: End If;
1497: Okc_context.set_okc_org_context (l_line_rec.org_id, l_organization_id);
1498: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SH' Then
1499: Okc_context.set_okc_org_context (l_line_rec.org_id, l_line_rec.ship_from_org_id);
1500: End If;
1501: /* End of Code Added for Bug#15885433*/
1502:
1503: If l_line_rec.Service_reference_type_code = 'ORDER' Then

Line 2082: /* AND kfv.organization_id = okc_context.get_okc_organization_id */

2078: AND kfv.service_item_flag = 'Y'
2079: AND kfv.customer_order_enabled_flag = 'Y'
2080: AND kfv.enabled_flag = 'Y'
2081: --npalepu modified on 23-dec-2005 for bug # 4897884
2082: /* AND kfv.organization_id = okc_context.get_okc_organization_id */
2083: AND kfv.organization_id = v_organization_id
2084: --end npalepu
2085: --NPALEPU,11-AUG-2005
2086: --Used UPPER Function as Requested by Quoting Team.

Line 2132: /* AND kfv.organization_id = okc_context.get_okc_organization_id */

2128: AND kfv.service_item_flag = 'Y'
2129: AND kfv.customer_order_enabled_flag = 'Y'
2130: AND kfv.enabled_flag = 'Y'
2131: --npalepu modified on 23-dec-2005 for bug # 4897884
2132: /* AND kfv.organization_id = okc_context.get_okc_organization_id */
2133: AND kfv.organization_id = v_organization_id
2134: --end npalepu
2135: AND uom.uom_code = primary_uom_code
2136: AND srvuom.uom_code = service_duration_period_code

Line 2184: if okc_context.get_okc_org_id IS NULL then

2180:
2181: --NPALEPU 21-sep-2005 for bug # 4608694
2182:
2183: /* --set org_id if it is null
2184: if okc_context.get_okc_org_id IS NULL then
2185: okc_context.set_okc_org_context;
2186: end if; */
2187:
2188: --capturing the original context

Line 2185: okc_context.set_okc_org_context;

2181: --NPALEPU 21-sep-2005 for bug # 4608694
2182:
2183: /* --set org_id if it is null
2184: if okc_context.get_okc_org_id IS NULL then
2185: okc_context.set_okc_org_context;
2186: end if; */
2187:
2188: --capturing the original context
2189: l_original_org_id := mo_global.get_current_org_id;

Line 2194: /* okc_context.set_okc_org_context(p_org_id =>P_ORG_ID); */

2190: l_original_access_mode := mo_global.get_access_mode();
2191:
2192: IF p_org_id IS NOT NULL THEN
2193: --npalepu added on 23-dec-2005 for bug # 4897884
2194: /* okc_context.set_okc_org_context(p_org_id =>P_ORG_ID); */
2195: l_org_id := p_org_id;
2196: --end 4897884
2197: ELSIF l_original_org_id IS NOT NULL THEN
2198: --npalepu added on 23-dec-2005 for bug # 4897884

Line 2199: /* okc_context.set_okc_org_context(p_org_id =>l_original_org_id); */

2195: l_org_id := p_org_id;
2196: --end 4897884
2197: ELSIF l_original_org_id IS NOT NULL THEN
2198: --npalepu added on 23-dec-2005 for bug # 4897884
2199: /* okc_context.set_okc_org_context(p_org_id =>l_original_org_id); */
2200: l_org_id := l_original_org_id;
2201: --end 4897884
2202: ELSE
2203: --npalepu added on 23-dec-2005 for bug # 4897884

Line 2204: /* okc_context.set_okc_org_context; */

2200: l_org_id := l_original_org_id;
2201: --end 4897884
2202: ELSE
2203: --npalepu added on 23-dec-2005 for bug # 4897884
2204: /* okc_context.set_okc_org_context; */
2205: mo_utils.get_default_ou(l_default_org_id, l_default_ou_name, l_ou_count);
2206: l_org_id := l_default_org_id;
2207: --end 4897884
2208: END IF;