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_LINE_FULLFILL dependencies on OE_ORDER_PUB

Line 19: (p_line_rec IN OE_Order_PUB.Line_Rec_Type

15: -- updates returned quantity as return lines are received.
16: -------------------------------------------------------------------
17: -- 5126873 - Blankets not supported for fulfilled quantity2 as per initial INV design from PM so no need to calculate fulfilled quantity2
18: PROCEDURE Update_Blanket_Qty
19: (p_line_rec IN OE_Order_PUB.Line_Rec_Type
20: ,p_fulfilled_quantity IN NUMBER DEFAULT NULL
21: )
22: IS
23:

Line 266: x_line_tbl OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

262: p_line_id IN NUMBER,
263: p_header_id IN NUMBER DEFAULT NULL, -- 1717444
264: x_return_status OUT NOCOPY VARCHAR2,
265:
266: x_line_tbl OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
267:
268: )
269: IS
270:

Line 439: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;

435:
436: )
437:
438: IS
439: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;
440: l_fulfill_index NUMBER := 0 ;
441: l_service_tbl OE_Order_Pub.Line_Tbl_Type;
442: l_service_index NUMBER := 0 ;
443: l_line_id NUMBER;

Line 441: l_service_tbl OE_Order_Pub.Line_Tbl_Type;

437:
438: IS
439: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;
440: l_fulfill_index NUMBER := 0 ;
441: l_service_tbl OE_Order_Pub.Line_Tbl_Type;
442: l_service_index NUMBER := 0 ;
443: l_line_id NUMBER;
444: l_return_status VARCHAR2(1);
445: l_parent_line_fulfilled_qty NUMBER := null; --5699215

Line 487: l_fulfill_tbl(l_fulfill_index) := OE_Order_PUB.G_MISS_LINE_REC;

483:
484: FOR l_service_index IN 1 .. l_service_tbl.count
485: LOOP
486: l_fulfill_index := l_fulfill_index + 1;
487: l_fulfill_tbl(l_fulfill_index) := OE_Order_PUB.G_MISS_LINE_REC;
488: l_fulfill_tbl(l_fulfill_index).line_id := l_service_tbl(l_service_index).line_id;
489: l_fulfill_tbl(l_fulfill_index).fulfilled_flag := 'Y';
490: l_fulfill_tbl(l_fulfill_index).fulfillment_date := SYSDATE;
491: --5699215

Line 640: p_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type

636:
637:
638: PROCEDURE Update_Service_Dates /* 2048753 */
639: (
640: p_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
641: )
642: IS
643: l_return_status VARCHAR2(1);
644: l_line_rec OE_Order_Pub.Line_Rec_Type; -- added for 2897505

Line 644: l_line_rec OE_Order_Pub.Line_Rec_Type; -- added for 2897505

640: p_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
641: )
642: IS
643: l_return_status VARCHAR2(1);
644: l_line_rec OE_Order_Pub.Line_Rec_Type; -- added for 2897505
645:
646: --
647: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
648: --

Line 713: p_line_rec IN OE_Order_Pub.Line_Rec_Type DEFAULT OE_Order_Pub.G_MISS_LINE_REC

709: */
710:
711: PROCEDURE Fulfill_Line
712: (
713: p_line_rec IN OE_Order_Pub.Line_Rec_Type DEFAULT OE_Order_Pub.G_MISS_LINE_REC
714: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type DEFAULT OE_Order_Pub.G_MISS_LINE_TBL
715: ,p_mode IN VARCHAR2
716: ,p_fulfillment_type IN VARCHAR2
717: ,p_fulfillment_activity IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

Line 714: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type DEFAULT OE_Order_Pub.G_MISS_LINE_TBL

710:
711: PROCEDURE Fulfill_Line
712: (
713: p_line_rec IN OE_Order_Pub.Line_Rec_Type DEFAULT OE_Order_Pub.G_MISS_LINE_REC
714: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type DEFAULT OE_Order_Pub.G_MISS_LINE_TBL
715: ,p_mode IN VARCHAR2
716: ,p_fulfillment_type IN VARCHAR2
717: ,p_fulfillment_activity IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
718: ,x_return_status OUT NOCOPY VARCHAR2

Line 721: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

717: ,p_fulfillment_activity IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
718: ,x_return_status OUT NOCOPY VARCHAR2
719: )
720: IS
721: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
722: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
723: l_aso_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
724: l_return_status VARCHAR2(1);
725: l_index NUMBER;

Line 722: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

718: ,x_return_status OUT NOCOPY VARCHAR2
719: )
720: IS
721: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
722: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
723: l_aso_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
724: l_return_status VARCHAR2(1);
725: l_index NUMBER;
726: l_fulfilled_quantity NUMBER;

Line 723: l_aso_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

719: )
720: IS
721: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
722: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
723: l_aso_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
724: l_return_status VARCHAR2(1);
725: l_index NUMBER;
726: l_fulfilled_quantity NUMBER;
727: l_fulfilled_quantity2 NUMBER; -- 5126873

Line 728: l_line_rec OE_Order_Pub.Line_Rec_Type; /* 2048753 */

724: l_return_status VARCHAR2(1);
725: l_index NUMBER;
726: l_fulfilled_quantity NUMBER;
727: l_fulfilled_quantity2 NUMBER; -- 5126873
728: l_line_rec OE_Order_Pub.Line_Rec_Type; /* 2048753 */
729: l_notify_index NUMBER;
730: l_user NUMBER := NVL(OE_STANDARD_WF.G_USER_ID, FND_GLOBAL.USER_ID); --3169637
731: -- Changes for AFD
732: l_ordered_date date;

Line 794: l_update_line_tbl(1) := OE_Order_PUB.G_MISS_LINE_REC;

790: -- end CHANGES for AFD
791:
792:
793: /* Commented for performance changes
794: l_update_line_tbl(1) := OE_Order_PUB.G_MISS_LINE_REC;
795: l_update_line_tbl(1).line_id := p_line_rec.line_id;
796: l_update_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
797: */
798: /* Start Audit Trail */

Line 2095: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

2091: )
2092: IS
2093: l_top_model_line_id NUMBER;
2094: l_return_status VARCHAR2(1);
2095: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2096: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2097: l_index NUMBER;
2098: --Changes for AFD
2099: l_ordered_date DATE;

Line 2096: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

2092: IS
2093: l_top_model_line_id NUMBER;
2094: l_return_status VARCHAR2(1);
2095: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2096: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2097: l_index NUMBER;
2098: --Changes for AFD
2099: l_ordered_date DATE;
2100: --

Line 2349: l_line_tbl OE_Order_Pub.Line_Tbl_Type;

2345: , x_fulfillment_status OUT NOCOPY VARCHAr2
2346:
2347: )
2348: IS
2349: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
2350: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;
2351: l_service_tbl OE_Order_Pub.Line_Tbl_Type;
2352: l_service_index NUMBER;
2353: l_line_index NUMBER;

Line 2350: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;

2346:
2347: )
2348: IS
2349: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
2350: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;
2351: l_service_tbl OE_Order_Pub.Line_Tbl_Type;
2352: l_service_index NUMBER;
2353: l_line_index NUMBER;
2354: l_fulfill_index NUMBER := 0 ;

Line 2351: l_service_tbl OE_Order_Pub.Line_Tbl_Type;

2347: )
2348: IS
2349: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
2350: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;
2351: l_service_tbl OE_Order_Pub.Line_Tbl_Type;
2352: l_service_index NUMBER;
2353: l_line_index NUMBER;
2354: l_fulfill_index NUMBER := 0 ;
2355: l_fulfilled_flag VARCHAR2(1) := FND_API.G_TRUE;

Line 2597: l_fulfill_tbl(l_fulfill_index) := OE_Order_PUB.G_MISS_LINE_REC;

2593: p_process_all = FND_API.G_TRUE) AND
2594: nvl(l_line_tbl(l_line_index).fulfilled_flag,'N') <> 'Y' THEN
2595:
2596: l_fulfill_index := l_fulfill_index + 1;
2597: l_fulfill_tbl(l_fulfill_index) := OE_Order_PUB.G_MISS_LINE_REC;
2598: l_fulfill_tbl(l_fulfill_index).line_id := l_line_tbl(l_line_index).line_id;
2599: l_fulfill_tbl(l_fulfill_index).fulfilled_flag := 'Y';
2600: l_fulfill_tbl(l_fulfill_index).fulfillment_date := SYSDATE;
2601: l_fulfill_tbl(l_fulfill_index).fulfilled_quantity := nvl(l_line_tbl(l_line_index).shipped_quantity,l_line_tbl(l_line_index).ordered_quantity);

Line 2649: l_fulfill_tbl(l_fulfill_index) := OE_Order_PUB.G_MISS_LINE_REC;

2645:
2646: FOR l_service_index IN 1 .. l_service_tbl.count
2647: LOOP
2648: l_fulfill_index := l_fulfill_index + 1;
2649: l_fulfill_tbl(l_fulfill_index) := OE_Order_PUB.G_MISS_LINE_REC;
2650: l_fulfill_tbl(l_fulfill_index).line_id := l_service_tbl(l_service_index).line_id;
2651: l_fulfill_tbl(l_fulfill_index).fulfilled_flag := 'Y';
2652: l_fulfill_tbl(l_fulfill_index).fulfillment_date := SYSDATE;
2653: l_fulfill_tbl(l_fulfill_index).fulfilled_quantity := nvl(l_service_tbl(l_service_index).shipped_quantity,l_service_tbl(l_service_index).ordered_quantity);

Line 2864: l_line_rec OE_ORDER_PUB.Line_Rec_Type;

2860: )
2861: IS
2862: l_line_set_index NUMBER := 0;
2863: l_prev_set_id NUMBER := 0;
2864: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
2865: l_fulfilled_flag VARCHAR2(1) := FND_API.G_TRUE;
2866: l_item_key VARCHAR2(240);
2867: l_fulfill_activity VARCHAR2(30) := 'FULFILL_LINE';
2868: l_activity_status VARCHAR2(8);

Line 2880: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;

2876: TYPE set_tbl IS TABLE OF NUMBER
2877: INDEX BY BINARY_INTEGER;
2878: l_set_tbl set_tbl;
2879: l_set_tbl_index NUMBER := 0;
2880: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;
2881: l_fulfill_index NUMBER := 0 ;
2882: l_process_tbl Line_Set_Tbl_Type;
2883: l_process_index NUMBER := 0;
2884: l_fulfillment_status VARCHAR2(1);

Line 2888: l_service_tbl OE_Order_Pub.Line_Tbl_Type;

2884: l_fulfillment_status VARCHAR2(1);
2885: l_process_all VARCHAR2(1) := FND_API.G_TRUE;
2886: l_top_model_line_id NUMBER;
2887: l_header_id NUMBER;
2888: l_service_tbl OE_Order_Pub.Line_Tbl_Type;
2889: l_service_index NUMBER;
2890: -- Bug 3061559
2891: -- Select fields used in blankets processing
2892: CURSOR c_line(l_cursor_line_id IN NUMBER) IS

Line 3145: l_fulfill_tbl(l_fulfill_index) := OE_Order_PUB.G_MISS_LINE_REC;

3141: FOR l_service_index IN 1 .. l_service_tbl.count
3142: LOOP
3143: IF NOT l_line_tbl.EXISTS(l_service_tbl(l_service_index).line_id) THEN
3144: l_fulfill_index := l_fulfill_index + 1;
3145: l_fulfill_tbl(l_fulfill_index) := OE_Order_PUB.G_MISS_LINE_REC;
3146: l_fulfill_tbl(l_fulfill_index).line_id := l_service_tbl(l_service_index).line_id;
3147: l_fulfill_tbl(l_fulfill_index).fulfilled_flag := 'Y';
3148: l_fulfill_tbl(l_fulfill_index).fulfillment_date := SYSDATE;
3149: l_fulfill_tbl(l_fulfill_index).fulfilled_quantity := nvl(l_service_tbl(l_service_index).shipped_quantity,l_service_tbl(l_service_index).ordered_quantity);

Line 3209: l_fulfill_tbl(l_fulfill_index):= OE_Order_PUB.G_MISS_LINE_REC;

3205: oe_debug_pub.add( 'THE LINE IS NOT FULFILLED '||TO_CHAR ( L_PROCESS_TBL ( L_LINE_SET_INDEX ) .LINE_ID ) , 3 ) ;
3206: END IF;
3207:
3208: l_fulfill_index := l_fulfill_index + 1;
3209: l_fulfill_tbl(l_fulfill_index):= OE_Order_PUB.G_MISS_LINE_REC;
3210: l_fulfill_tbl(l_fulfill_index).line_id := l_process_tbl(l_line_set_index).line_id;
3211: l_fulfill_tbl(l_fulfill_index).fulfilled_flag := 'Y';
3212: l_fulfill_tbl(l_fulfill_index).fulfillment_date := SYSDATE;
3213: l_fulfill_tbl(l_fulfill_index).fulfilled_quantity := nvl(l_process_tbl(l_line_set_index).ordered_quantity,l_process_tbl(l_line_set_index).ordered_quantity);

Line 3413: l_line_rec OE_Order_Pub.Line_Rec_Type;

3409:
3410: )
3411: IS
3412:
3413: l_line_rec OE_Order_Pub.Line_Rec_Type;
3414: l_return_status VARCHAR2(1);
3415: l_item_key VARCHAR2(240);
3416: l_fulfillment_activity VARCHAR2(30);
3417: l_fulfillment_type VARCHAR2(30);

Line 3424: l_line_tbl OE_Order_Pub.Line_Tbl_Type;

3420: l_flow_status_code VARCHAR2(30);
3421: l_activity_status VARCHAR2(8);
3422: l_activity_result VARCHAR2(30);
3423: l_activity_id NUMBER;
3424: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
3425: l_line_index NUMBER;
3426: l_config_index NUMBER := 0;
3427: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;
3428: l_fulfill_index NUMBER := 0 ;

Line 3427: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;

3423: l_activity_id NUMBER;
3424: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
3425: l_line_index NUMBER;
3426: l_config_index NUMBER := 0;
3427: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;
3428: l_fulfill_index NUMBER := 0 ;
3429: l_service_tbl OE_Order_Pub.Line_Tbl_Type;
3430: l_service_index NUMBER := 0 ;
3431: l_line_id NUMBER;

Line 3429: l_service_tbl OE_Order_Pub.Line_Tbl_Type;

3425: l_line_index NUMBER;
3426: l_config_index NUMBER := 0;
3427: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;
3428: l_fulfill_index NUMBER := 0 ;
3429: l_service_tbl OE_Order_Pub.Line_Tbl_Type;
3430: l_service_index NUMBER := 0 ;
3431: l_line_id NUMBER;
3432: l_fulfilled_flag VARCHAR2(1);
3433: l_top_model_line_id NUMBER;

Line 4538: l_line_rec OE_Order_Pub.Line_Rec_Type;

4534: l_activity_status VARCHAR2(8);
4535: l_activity_result VARCHAR2(30);
4536: l_activity_id NUMBER;
4537: l_return_status VARCHAR2(1);
4538: l_line_rec OE_Order_Pub.Line_Rec_Type;
4539: l_process_current_line BOOLEAN := TRUE;
4540: l_complete_fulfillment BOOLEAN := TRUE;
4541:
4542: /* 2525203 */