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 646: p_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type

642:
643:
644: PROCEDURE Update_Service_Dates /* 2048753 */
645: (
646: p_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
647: )
648: IS
649: l_return_status VARCHAR2(1);
650: l_line_rec OE_Order_Pub.Line_Rec_Type; -- added for 2897505

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

646: p_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
647: )
648: IS
649: l_return_status VARCHAR2(1);
650: l_line_rec OE_Order_Pub.Line_Rec_Type; -- added for 2897505
651:
652: --
653: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
654: --

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

715: */
716:
717: PROCEDURE Fulfill_Line
718: (
719: p_line_rec IN OE_Order_Pub.Line_Rec_Type DEFAULT OE_Order_Pub.G_MISS_LINE_REC
720: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type DEFAULT OE_Order_Pub.G_MISS_LINE_TBL
721: ,p_mode IN VARCHAR2
722: ,p_fulfillment_type IN VARCHAR2
723: ,p_fulfillment_activity IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

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

716:
717: PROCEDURE Fulfill_Line
718: (
719: p_line_rec IN OE_Order_Pub.Line_Rec_Type DEFAULT OE_Order_Pub.G_MISS_LINE_REC
720: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type DEFAULT OE_Order_Pub.G_MISS_LINE_TBL
721: ,p_mode IN VARCHAR2
722: ,p_fulfillment_type IN VARCHAR2
723: ,p_fulfillment_activity IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
724: ,x_return_status OUT NOCOPY VARCHAR2

Line 727: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

723: ,p_fulfillment_activity IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
724: ,x_return_status OUT NOCOPY VARCHAR2
725: )
726: IS
727: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
728: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
729: l_aso_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
730: l_return_status VARCHAR2(1);
731: l_index NUMBER;

Line 728: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

724: ,x_return_status OUT NOCOPY VARCHAR2
725: )
726: IS
727: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
728: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
729: l_aso_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
730: l_return_status VARCHAR2(1);
731: l_index NUMBER;
732: l_fulfilled_quantity NUMBER;

Line 729: l_aso_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

725: )
726: IS
727: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
728: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
729: l_aso_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
730: l_return_status VARCHAR2(1);
731: l_index NUMBER;
732: l_fulfilled_quantity NUMBER;
733: l_fulfilled_quantity2 NUMBER; -- 5126873

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

730: l_return_status VARCHAR2(1);
731: l_index NUMBER;
732: l_fulfilled_quantity NUMBER;
733: l_fulfilled_quantity2 NUMBER; -- 5126873
734: l_line_rec OE_Order_Pub.Line_Rec_Type; /* 2048753 */
735: l_notify_index NUMBER;
736: l_user NUMBER := NVL(OE_STANDARD_WF.G_USER_ID, FND_GLOBAL.USER_ID); --3169637
737: -- Changes for AFD
738: l_ordered_date date;

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

798: -- end CHANGES for AFD
799:
800:
801: /* Commented for performance changes
802: l_update_line_tbl(1) := OE_Order_PUB.G_MISS_LINE_REC;
803: l_update_line_tbl(1).line_id := p_line_rec.line_id;
804: l_update_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
805: */
806: /* Start Audit Trail */

Line 2182: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

2178: )
2179: IS
2180: l_top_model_line_id NUMBER;
2181: l_return_status VARCHAR2(1);
2182: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2183: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2184: l_index NUMBER;
2185: --Changes for AFD
2186: l_ordered_date DATE;

Line 2183: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

2179: IS
2180: l_top_model_line_id NUMBER;
2181: l_return_status VARCHAR2(1);
2182: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2183: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2184: l_index NUMBER;
2185: --Changes for AFD
2186: l_ordered_date DATE;
2187: --

Line 2477: l_line_tbl OE_Order_Pub.Line_Tbl_Type;

2473: , x_fulfillment_status OUT NOCOPY VARCHAr2
2474:
2475: )
2476: IS
2477: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
2478: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;
2479: l_service_tbl OE_Order_Pub.Line_Tbl_Type;
2480: l_service_index NUMBER;
2481: l_line_index NUMBER;

Line 2478: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;

2474:
2475: )
2476: IS
2477: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
2478: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;
2479: l_service_tbl OE_Order_Pub.Line_Tbl_Type;
2480: l_service_index NUMBER;
2481: l_line_index NUMBER;
2482: l_fulfill_index NUMBER := 0 ;

Line 2479: l_service_tbl OE_Order_Pub.Line_Tbl_Type;

2475: )
2476: IS
2477: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
2478: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;
2479: l_service_tbl OE_Order_Pub.Line_Tbl_Type;
2480: l_service_index NUMBER;
2481: l_line_index NUMBER;
2482: l_fulfill_index NUMBER := 0 ;
2483: l_fulfilled_flag VARCHAR2(1) := FND_API.G_TRUE;

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

2721: p_process_all = FND_API.G_TRUE) AND
2722: nvl(l_line_tbl(l_line_index).fulfilled_flag,'N') <> 'Y' THEN
2723:
2724: l_fulfill_index := l_fulfill_index + 1;
2725: l_fulfill_tbl(l_fulfill_index) := OE_Order_PUB.G_MISS_LINE_REC;
2726: l_fulfill_tbl(l_fulfill_index).line_id := l_line_tbl(l_line_index).line_id;
2727: l_fulfill_tbl(l_fulfill_index).fulfilled_flag := 'Y';
2728: l_fulfill_tbl(l_fulfill_index).fulfillment_date := SYSDATE;
2729: 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 2782: l_fulfill_tbl(l_fulfill_index) := OE_Order_PUB.G_MISS_LINE_REC;

2778:
2779: FOR l_service_index IN 1 .. l_service_tbl.count
2780: LOOP
2781: l_fulfill_index := l_fulfill_index + 1;
2782: l_fulfill_tbl(l_fulfill_index) := OE_Order_PUB.G_MISS_LINE_REC;
2783: l_fulfill_tbl(l_fulfill_index).line_id := l_service_tbl(l_service_index).line_id;
2784: l_fulfill_tbl(l_fulfill_index).fulfilled_flag := 'Y';
2785: l_fulfill_tbl(l_fulfill_index).fulfillment_date := SYSDATE;
2786: 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 3014: l_line_rec OE_ORDER_PUB.Line_Rec_Type;

3010: )
3011: IS
3012: l_line_set_index NUMBER := 0;
3013: l_prev_set_id NUMBER := 0;
3014: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
3015: l_fulfilled_flag VARCHAR2(1) := FND_API.G_TRUE;
3016: l_item_key VARCHAR2(240);
3017: l_fulfill_activity VARCHAR2(30) := 'FULFILL_LINE';
3018: l_activity_status VARCHAR2(8);

Line 3030: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;

3026: TYPE set_tbl IS TABLE OF NUMBER
3027: INDEX BY BINARY_INTEGER;
3028: l_set_tbl set_tbl;
3029: l_set_tbl_index NUMBER := 0;
3030: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;
3031: l_fulfill_index NUMBER := 0 ;
3032: l_process_tbl Line_Set_Tbl_Type;
3033: l_process_index NUMBER := 0;
3034: l_fulfillment_status VARCHAR2(1);

Line 3038: l_service_tbl OE_Order_Pub.Line_Tbl_Type;

3034: l_fulfillment_status VARCHAR2(1);
3035: l_process_all VARCHAR2(1) := FND_API.G_TRUE;
3036: l_top_model_line_id NUMBER;
3037: l_header_id NUMBER;
3038: l_service_tbl OE_Order_Pub.Line_Tbl_Type;
3039: l_service_index NUMBER;
3040: --Start 7827727
3041: l_line_id_mod NUMBER;
3042: l_set_id_mod NUMBER;

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

3311: l_line_id_mod:=MOD(l_service_tbl(l_service_index).line_id,G_BINARY_LIMIT);--7827727
3312: --IF NOT l_line_tbl.EXISTS(l_service_tbl(l_service_index).line_id) THEN
3313: IF NOT l_line_tbl.EXISTS(l_line_id_mod) THEN --7827727
3314: l_fulfill_index := l_fulfill_index + 1;
3315: l_fulfill_tbl(l_fulfill_index) := OE_Order_PUB.G_MISS_LINE_REC;
3316: l_fulfill_tbl(l_fulfill_index).line_id := l_service_tbl(l_service_index).line_id;
3317: l_fulfill_tbl(l_fulfill_index).fulfilled_flag := 'Y';
3318: l_fulfill_tbl(l_fulfill_index).fulfillment_date := SYSDATE;
3319: 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 3382: l_fulfill_tbl(l_fulfill_index):= OE_Order_PUB.G_MISS_LINE_REC;

3378: oe_debug_pub.add( 'THE LINE IS NOT FULFILLED '||TO_CHAR ( L_PROCESS_TBL ( L_LINE_SET_INDEX ) .LINE_ID ) , 3 ) ;
3379: END IF;
3380:
3381: l_fulfill_index := l_fulfill_index + 1;
3382: l_fulfill_tbl(l_fulfill_index):= OE_Order_PUB.G_MISS_LINE_REC;
3383: l_fulfill_tbl(l_fulfill_index).line_id := l_process_tbl(l_line_set_index).line_id;
3384: l_fulfill_tbl(l_fulfill_index).fulfilled_flag := 'Y';
3385: l_fulfill_tbl(l_fulfill_index).fulfillment_date := SYSDATE;
3386: 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 3592: l_line_rec OE_Order_Pub.Line_Rec_Type;

3588:
3589: )
3590: IS
3591:
3592: l_line_rec OE_Order_Pub.Line_Rec_Type;
3593: l_return_status VARCHAR2(1);
3594: l_item_key VARCHAR2(240);
3595: l_fulfillment_activity VARCHAR2(30);
3596: l_fulfillment_type VARCHAR2(30);

Line 3603: l_line_tbl OE_Order_Pub.Line_Tbl_Type;

3599: l_flow_status_code VARCHAR2(30);
3600: l_activity_status VARCHAR2(8);
3601: l_activity_result VARCHAR2(30);
3602: l_activity_id NUMBER;
3603: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
3604: l_line_index NUMBER;
3605: l_config_index NUMBER := 0;
3606: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;
3607: l_fulfill_index NUMBER := 0 ;

Line 3606: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;

3602: l_activity_id NUMBER;
3603: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
3604: l_line_index NUMBER;
3605: l_config_index NUMBER := 0;
3606: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;
3607: l_fulfill_index NUMBER := 0 ;
3608: l_service_tbl OE_Order_Pub.Line_Tbl_Type;
3609: l_service_index NUMBER := 0 ;
3610: l_line_id NUMBER;

Line 3608: l_service_tbl OE_Order_Pub.Line_Tbl_Type;

3604: l_line_index NUMBER;
3605: l_config_index NUMBER := 0;
3606: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;
3607: l_fulfill_index NUMBER := 0 ;
3608: l_service_tbl OE_Order_Pub.Line_Tbl_Type;
3609: l_service_index NUMBER := 0 ;
3610: l_line_id NUMBER;
3611: l_fulfilled_flag VARCHAR2(1);
3612: l_top_model_line_id NUMBER;

Line 4765: l_line_rec OE_Order_Pub.Line_Rec_Type;

4761: l_activity_status VARCHAR2(8);
4762: l_activity_result VARCHAR2(30);
4763: l_activity_id NUMBER;
4764: l_return_status VARCHAR2(1);
4765: l_line_rec OE_Order_Pub.Line_Rec_Type;
4766: l_process_current_line BOOLEAN := TRUE;
4767: l_complete_fulfillment BOOLEAN := TRUE;
4768:
4769: /* 2525203 */