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 468: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN

464: IF l_debug_level > 0 THEN
465: oe_debug_pub.add( 'LINE ID PASSED IS ' || to_char(p_line_id) ) ;
466: END IF;
467:
468: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
469: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
470: END IF;
471:
472: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN

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

465: oe_debug_pub.add( 'LINE ID PASSED IS ' || to_char(p_line_id) ) ;
466: END IF;
467:
468: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
469: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
470: END IF;
471:
472: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN
473:

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

468: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
469: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
470: END IF;
471:
472: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN
473:
474: l_sql_stat := '
475: Begin
476: OKS_OMINT_PUB.GET_SVC_SDATE(

Line 599: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN

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

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

596: -- IF Get_Product_Status(515) IN ('I','S') THEN
597:
598: -- lkxu, for bug 1701377
599: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
600: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
601: END IF;
602:
603: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN
604:

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

599: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
600: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
601: END IF;
602:
603: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN
604:
605: l_sql_stat := '
606: Begin
607: OKS_OMINT_PUB.GET_DURATION(

Line 980: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN

976:
977: -- IF Get_Product_Status(515) IN ('I','S') THEN
978:
979: -- lkxu, for bug 1701377
980: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
981: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
982: END IF;
983:
984: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' AND -- AND added for 2331301

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

977: -- IF Get_Product_Status(515) IN ('I','S') THEN
978:
979: -- lkxu, for bug 1701377
980: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
981: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
982: END IF;
983:
984: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' AND -- AND added for 2331301
985: (NOT(l_top_model_id = l_line_id) OR l_serviceable = 'Y') THEN

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

980: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
981: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
982: END IF;
983:
984: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' AND -- AND added for 2331301
985: (NOT(l_top_model_id = l_line_id) OR l_serviceable = 'Y') THEN
986:
987: IF l_debug_level > 0 THEN
988: oe_debug_pub.add( 'IS SERVICE AVAILABLE IS AVAILABLE - RUN DYNAMIC',0.5 ) ; -- debug level 0.5 added for bug 13435459

Line 1337: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN

1333:
1334: -- IF Get_Product_Status(515) IN ('I','S') THEN
1335:
1336: -- lkxu, for bug 1701377
1337: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
1338: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
1339: END IF;
1340:
1341: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN

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

1334: -- IF Get_Product_Status(515) IN ('I','S') THEN
1335:
1336: -- lkxu, for bug 1701377
1337: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
1338: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
1339: END IF;
1340:
1341: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN
1342:

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

1337: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
1338: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
1339: END IF;
1340:
1341: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN
1342:
1343: -- Check
1344: /* Removed product_item_id and added customer_id, customer_product_id
1345: and request_date to fix 1720185 */

Line 1512: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN

1508:
1509: -- IF Get_Product_Status(515) IN ('I','S') THEN
1510:
1511: -- lkxu, for bug 1701377
1512: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
1513: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
1514: END IF;
1515:
1516: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN

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

1509: -- IF Get_Product_Status(515) IN ('I','S') THEN
1510:
1511: -- lkxu, for bug 1701377
1512: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
1513: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
1514: END IF;
1515:
1516: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN
1517:

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

1512: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
1513: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
1514: END IF;
1515:
1516: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN
1517:
1518: l_sql_stat := '
1519: Begin
1520: OKS_OMINT_PUB.GET_DURATION(

Line 1697: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN

1693:
1694: -- IF Get_Product_Status(515) IN ('I','S') THEN
1695:
1696: -- lkxu, for bug 1701377
1697: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
1698: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
1699: END IF;
1700:
1701: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' AND -- AND added for 2331301

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

1694: -- IF Get_Product_Status(515) IN ('I','S') THEN
1695:
1696: -- lkxu, for bug 1701377
1697: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
1698: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
1699: END IF;
1700:
1701: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' AND -- AND added for 2331301
1702: (NOT(l_top_model_id = l_line_id) OR l_serviceable = 'Y') THEN

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

1697: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
1698: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
1699: END IF;
1700:
1701: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' AND -- AND added for 2331301
1702: (NOT(l_top_model_id = l_line_id) OR l_serviceable = 'Y') THEN
1703:
1704:
1705: -- Check

Line 1896: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN

1892:
1893: -- IF Get_Product_Status(515) IN ('I','S') THEN
1894:
1895: -- lkxu, for bug 1701377
1896: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
1897: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
1898: END IF;
1899:
1900: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN

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

1893: -- IF Get_Product_Status(515) IN ('I','S') THEN
1894:
1895: -- lkxu, for bug 1701377
1896: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
1897: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
1898: END IF;
1899:
1900: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN
1901:

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

1896: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
1897: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
1898: END IF;
1899:
1900: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN
1901:
1902: -- Check
1903: /* Removed product_item_id and added customer_id, customer_product_id
1904: and request_date to fix 1720185 */

Line 2571: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN

2567:
2568: -- IF Get_Product_Status(515) IN ('I','S') THEN
2569:
2570: -- lkxu, for bug 1701377
2571: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
2572: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
2573: END IF;
2574:
2575: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN

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

2568: -- IF Get_Product_Status(515) IN ('I','S') THEN
2569:
2570: -- lkxu, for bug 1701377
2571: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
2572: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
2573: END IF;
2574:
2575: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN
2576:

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

2571: IF OE_GLOBALS.G_OKS_INSTALLED IS NULL THEN
2572: OE_GLOBALS.G_OKS_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(515);
2573: END IF;
2574:
2575: IF OE_GLOBALS.G_OKS_INSTALLED = 'Y' THEN
2576:
2577: -- for bug 2170348
2578:
2579: l_sql_stat := 'Declare

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

2744: p_x_line_tbl(i).service_reference_type_code = 'ORDER' AND
2745: p_x_line_tbl(i).service_reference_line_id is NOT NULL AND
2746: --lchen fix for bug 2017271
2747: p_x_line_tbl(i).service_reference_line_id <> FND_API.G_MISS_NUM AND
2748: ( p_x_line_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE or
2749: p_x_line_tbl(i).operation= OE_GLOBALS.G_OPR_UPDATE) THEN
2750:
2751: IF l_debug_level > 0 THEN
2752: oe_debug_pub.add( 'IN OE_SERVICE_UTIL.UPDATE_SERVICE_LINES.ENTERING OE_SERVICE_UTIL.NEW_SERVICE_LINES' , 1 ) ;

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

2745: p_x_line_tbl(i).service_reference_line_id is NOT NULL AND
2746: --lchen fix for bug 2017271
2747: p_x_line_tbl(i).service_reference_line_id <> FND_API.G_MISS_NUM AND
2748: ( p_x_line_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE or
2749: p_x_line_tbl(i).operation= OE_GLOBALS.G_OPR_UPDATE) THEN
2750:
2751: IF l_debug_level > 0 THEN
2752: oe_debug_pub.add( 'IN OE_SERVICE_UTIL.UPDATE_SERVICE_LINES.ENTERING OE_SERVICE_UTIL.NEW_SERVICE_LINES' , 1 ) ;
2753: END IF;

Line 2815: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

2811: END LOOP;
2812:
2813: -- for bug 2366503
2814: IF ( l_cascade_request_flag ) THEN
2815: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
2816: END IF;
2817:
2818: IF l_debug_level > 0 THEN
2819: oe_debug_pub.add( 'EXITING OE_SERVICE_UTIL.UPDATE_SERVICE_LINES' , 1 ) ;

Line 2858: l_control_rec OE_GLOBALS.Control_Rec_Type;

2854:
2855: IS
2856:
2857: -- process_order in variables
2858: l_control_rec OE_GLOBALS.Control_Rec_Type;
2859: l_header_rec OE_Order_PUB.Header_Rec_Type;
2860: l_line_rec OE_ORDER_PUB.Line_Rec_Type
2861: := OE_ORDER_PUB.G_MISS_LINE_REC;
2862: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type

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

3011: IF l_service_end_date is not NULL THEN
3012: l_line_tbl(I).service_end_date := l_service_end_date;
3013: END IF;
3014:
3015: l_line_tbl(I).OPERATION := OE_GLOBALS.G_OPR_UPDATE;
3016:
3017: END LOOP;
3018:
3019: -- Call Process Order to update the record.

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

3028: l_control_rec.clear_dependents := TRUE;
3029:
3030: -- Instruct API to retain its caches
3031:
3032: l_header_rec.operation := OE_GLOBALS.G_OPR_NONE;
3033:
3034: l_control_rec.clear_api_cache := FALSE;
3035: l_control_rec.clear_api_requests := FALSE;
3036: