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.OE_SERVICE_UTIL dependencies on OE_GLOBALS

Line 56: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=

52: Procedure Notify_OC
53: ( p_api_version_number IN NUMBER
54: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
55: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
56: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
57: OE_GLOBALS.G_MISS_CONTROL_REC
58: , x_return_status OUT NOCOPY VARCHAR2
59:
60: , x_msg_count OUT NOCOPY NUMBER

Line 57: OE_GLOBALS.G_MISS_CONTROL_REC

53: ( p_api_version_number IN NUMBER
54: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
55: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
56: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
57: OE_GLOBALS.G_MISS_CONTROL_REC
58: , x_return_status OUT NOCOPY VARCHAR2
59:
60: , x_msg_count OUT NOCOPY NUMBER
61:

Line 128: l_control_rec OE_GLOBALS.Control_Rec_Type;

124:
125: l_number NUMBER := 0;
126: l_api_name CONSTANT VARCHAR(30) := 'NOTIFY_OC';
127: l_return_status VARCHAR2(1);
128: l_control_rec OE_GLOBALS.Control_Rec_Type;
129: l_sql_stat VARCHAR2(3000);
130: l_init_msg_list VARCHAR2(240);
131: l_commit VARCHAR2(1);
132: l_msg_count NUMBER;

Line 160: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN

156:
157: -- IF Get_Product_Status(697) IN ('I','S') THEN
158:
159: -- lkxu, for bug 1701377
160: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
161: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
162: END IF;
163:
164: IF OE_GLOBALS.G_ASO_INSTALLED = 'Y' THEN

Line 161: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);

157: -- IF Get_Product_Status(697) IN ('I','S') THEN
158:
159: -- lkxu, for bug 1701377
160: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
161: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
162: END IF;
163:
164: IF OE_GLOBALS.G_ASO_INSTALLED = 'Y' THEN
165:

Line 164: IF OE_GLOBALS.G_ASO_INSTALLED = 'Y' THEN

160: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
161: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
162: END IF;
163:
164: IF OE_GLOBALS.G_ASO_INSTALLED = 'Y' THEN
165:
166:
167: IF l_debug_level > 0 THEN
168: oe_debug_pub.add( 'BYPASS VALUE:' || L_BYPASS_NOTIFY_OC ) ;

Line 463: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN

459: IF l_debug_level > 0 THEN
460: oe_debug_pub.add( 'LINE ID PASSED IS ' || to_char(p_line_id) ) ;
461: END IF;
462:
463: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
464: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
465: END IF;
466:
467: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN

Line 464: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);

460: oe_debug_pub.add( 'LINE ID PASSED IS ' || to_char(p_line_id) ) ;
461: END IF;
462:
463: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
464: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
465: END IF;
466:
467: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN
468:

Line 467: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN

463: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
464: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
465: END IF;
466:
467: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN
468:
469: l_sql_stat := '
470: Begin
471: OKS_OMINT_PUB.GET_SVC_SDATE(

Line 594: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN

590:
591: -- IF Get_Product_Status(515) IN ('I','S') THEN
592:
593: -- lkxu, for bug 1701377
594: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
595: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
596: END IF;
597:
598: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN

Line 595: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);

591: -- IF Get_Product_Status(515) IN ('I','S') THEN
592:
593: -- lkxu, for bug 1701377
594: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
595: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
596: END IF;
597:
598: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN
599:

Line 598: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN

594: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
595: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
596: END IF;
597:
598: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN
599:
600: l_sql_stat := '
601: Begin
602: OKS_OMINT_PUB.GET_DURATION(

Line 966: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN

962:
963: -- IF Get_Product_Status(515) IN ('I','S') THEN
964:
965: -- lkxu, for bug 1701377
966: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
967: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
968: END IF;
969:
970: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' AND -- AND added for 2331301

Line 967: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);

963: -- IF Get_Product_Status(515) IN ('I','S') THEN
964:
965: -- lkxu, for bug 1701377
966: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
967: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
968: END IF;
969:
970: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' AND -- AND added for 2331301
971: (NOT(l_top_model_id = l_line_id) OR l_serviceable = 'Y') THEN

Line 970: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' AND -- AND added for 2331301

966: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
967: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
968: END IF;
969:
970: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' AND -- AND added for 2331301
971: (NOT(l_top_model_id = l_line_id) OR l_serviceable = 'Y') THEN
972:
973: IF l_debug_level > 0 THEN
974: oe_debug_pub.add( 'IS SERVICE AVAILABLE IS AVAILABLE - RUN DYNAMIC' ) ;

Line 1319: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN

1315:
1316: -- IF Get_Product_Status(515) IN ('I','S') THEN
1317:
1318: -- lkxu, for bug 1701377
1319: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
1320: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
1321: END IF;
1322:
1323: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN

Line 1320: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);

1316: -- IF Get_Product_Status(515) IN ('I','S') THEN
1317:
1318: -- lkxu, for bug 1701377
1319: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
1320: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
1321: END IF;
1322:
1323: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN
1324:

Line 1323: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN

1319: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
1320: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
1321: END IF;
1322:
1323: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN
1324:
1325: -- Check
1326: /* Removed product_item_id and added customer_id, customer_product_id
1327: and request_date to fix 1720185 */

Line 1494: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN

1490:
1491: -- IF Get_Product_Status(515) IN ('I','S') THEN
1492:
1493: -- lkxu, for bug 1701377
1494: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
1495: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
1496: END IF;
1497:
1498: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN

Line 1495: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);

1491: -- IF Get_Product_Status(515) IN ('I','S') THEN
1492:
1493: -- lkxu, for bug 1701377
1494: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
1495: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
1496: END IF;
1497:
1498: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN
1499:

Line 1498: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN

1494: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
1495: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
1496: END IF;
1497:
1498: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN
1499:
1500: l_sql_stat := '
1501: Begin
1502: OKS_OMINT_PUB.GET_DURATION(

Line 1666: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN

1662:
1663: -- IF Get_Product_Status(515) IN ('I','S') THEN
1664:
1665: -- lkxu, for bug 1701377
1666: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
1667: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
1668: END IF;
1669:
1670: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' AND -- AND added for 2331301

Line 1667: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);

1663: -- IF Get_Product_Status(515) IN ('I','S') THEN
1664:
1665: -- lkxu, for bug 1701377
1666: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
1667: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
1668: END IF;
1669:
1670: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' AND -- AND added for 2331301
1671: (NOT(l_top_model_id = l_line_id) OR l_serviceable = 'Y') THEN

Line 1670: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' AND -- AND added for 2331301

1666: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
1667: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
1668: END IF;
1669:
1670: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' AND -- AND added for 2331301
1671: (NOT(l_top_model_id = l_line_id) OR l_serviceable = 'Y') THEN
1672:
1673:
1674: -- Check

Line 1861: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN

1857:
1858: -- IF Get_Product_Status(515) IN ('I','S') THEN
1859:
1860: -- lkxu, for bug 1701377
1861: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
1862: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
1863: END IF;
1864:
1865: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN

Line 1862: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);

1858: -- IF Get_Product_Status(515) IN ('I','S') THEN
1859:
1860: -- lkxu, for bug 1701377
1861: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
1862: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
1863: END IF;
1864:
1865: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN
1866:

Line 1865: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN

1861: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
1862: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
1863: END IF;
1864:
1865: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN
1866:
1867: -- Check
1868: /* Removed product_item_id and added customer_id, customer_product_id
1869: and request_date to fix 1720185 */

Line 2530: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN

2526:
2527: -- IF Get_Product_Status(515) IN ('I','S') THEN
2528:
2529: -- lkxu, for bug 1701377
2530: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
2531: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
2532: END IF;
2533:
2534: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN

Line 2531: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);

2527: -- IF Get_Product_Status(515) IN ('I','S') THEN
2528:
2529: -- lkxu, for bug 1701377
2530: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
2531: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
2532: END IF;
2533:
2534: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN
2535:

Line 2534: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN

2530: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
2531: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
2532: END IF;
2533:
2534: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN
2535:
2536: -- for bug 2170348
2537:
2538: l_sql_stat := 'Declare

Line 2702: ( p_x_line_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE or

2698: p_x_line_tbl(i).service_reference_type_code = 'ORDER' AND
2699: p_x_line_tbl(i).service_reference_line_id is NOT NULL AND
2700: --lchen fix for bug 2017271
2701: p_x_line_tbl(i).service_reference_line_id <> FND_API.G_MISS_NUM AND
2702: ( p_x_line_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE or
2703: p_x_line_tbl(i).operation= OE_GLOBALS.G_OPR_UPDATE) THEN
2704:
2705: IF l_debug_level > 0 THEN
2706: oe_debug_pub.add( 'IN OE_SERVICE_UTIL.UPDATE_SERVICE_LINES.ENTERING OE_SERVICE_UTIL.NEW_SERVICE_LINES' , 1 ) ;

Line 2703: p_x_line_tbl(i).operation= OE_GLOBALS.G_OPR_UPDATE) THEN

2699: p_x_line_tbl(i).service_reference_line_id is NOT NULL AND
2700: --lchen fix for bug 2017271
2701: p_x_line_tbl(i).service_reference_line_id <> FND_API.G_MISS_NUM AND
2702: ( p_x_line_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE or
2703: p_x_line_tbl(i).operation= OE_GLOBALS.G_OPR_UPDATE) THEN
2704:
2705: IF l_debug_level > 0 THEN
2706: oe_debug_pub.add( 'IN OE_SERVICE_UTIL.UPDATE_SERVICE_LINES.ENTERING OE_SERVICE_UTIL.NEW_SERVICE_LINES' , 1 ) ;
2707: END IF;

Line 2769: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

2765: END LOOP;
2766:
2767: -- for bug 2366503
2768: IF ( l_cascade_request_flag ) THEN
2769: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
2770: END IF;
2771:
2772: IF l_debug_level > 0 THEN
2773: oe_debug_pub.add( 'EXITING OE_SERVICE_UTIL.UPDATE_SERVICE_LINES' , 1 ) ;

Line 2812: l_control_rec OE_GLOBALS.Control_Rec_Type;

2808:
2809: IS
2810:
2811: -- process_order in variables
2812: l_control_rec OE_GLOBALS.Control_Rec_Type;
2813: l_header_rec OE_Order_PUB.Header_Rec_Type;
2814: l_line_rec OE_ORDER_PUB.Line_Rec_Type
2815: := OE_ORDER_PUB.G_MISS_LINE_REC;
2816: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type

Line 2969: l_line_tbl(I).OPERATION := OE_GLOBALS.G_OPR_UPDATE;

2965: IF l_service_end_date is not NULL THEN
2966: l_line_tbl(I).service_end_date := l_service_end_date;
2967: END IF;
2968:
2969: l_line_tbl(I).OPERATION := OE_GLOBALS.G_OPR_UPDATE;
2970:
2971: END LOOP;
2972:
2973: -- Call Process Order to update the record.

Line 2986: l_header_rec.operation := OE_GLOBALS.G_OPR_NONE;

2982: l_control_rec.clear_dependents := TRUE;
2983:
2984: -- Instruct API to retain its caches
2985:
2986: l_header_rec.operation := OE_GLOBALS.G_OPR_NONE;
2987:
2988: l_control_rec.clear_api_cache := FALSE;
2989: l_control_rec.clear_api_requests := FALSE;
2990: