DBA Data[Home] [Help]

APPS.CSD_LOGISTICS_UTIL dependencies on OE_ORDER_PUB

Line 2633: l_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;

2629: l_order_line_id NUMBER;
2630: l_sr_account_id NUMBER; -- swai: bug 6001057
2631:
2632: --taklam
2633: l_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;
2634: x_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;
2635: l_p_ship_from_org_id NUMBER;
2636: l_project_count NUMBER;
2637:

Line 2634: x_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;

2630: l_sr_account_id NUMBER; -- swai: bug 6001057
2631:
2632: --taklam
2633: l_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;
2634: x_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;
2635: l_p_ship_from_org_id NUMBER;
2636: l_project_count NUMBER;
2637:
2638: --taklam

Line 2837: l_Line_Tbl_Type(1) := OE_Order_PUB.G_MISS_LINE_REC;

2833: FETCH order_line_cu into l_order_line_id, l_p_ship_from_org_id;
2834: CLOSE order_line_cu;
2835:
2836: if (l_order_line_id) is not null then
2837: l_Line_Tbl_Type(1) := OE_Order_PUB.G_MISS_LINE_REC;
2838: l_Line_Tbl_Type(1).line_id := l_order_line_id;
2839: l_Line_Tbl_Type(1).operation := OE_GLOBALS.G_OPR_UPDATE;
2840:
2841: -- taklam: update project and unit number fields

Line 2879: OE_ORDER_PUB.Process_Line(

2875: l_Line_Tbl_Type(1).end_customer_id := l_sr_account_id;
2876: end if;
2877: end if; -- end update 3rd party fields
2878:
2879: OE_ORDER_PUB.Process_Line(
2880: p_line_tbl => l_Line_Tbl_Type,
2881: x_line_out_tbl => x_Line_Tbl_Type,
2882: x_return_status => x_return_status,
2883: x_msg_count => l_msg_count,

Line 2949: l_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;

2945:
2946: l_sr_account_id NUMBER; -- swai: bug 6001057
2947:
2948: --taklam
2949: l_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;
2950: x_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;
2951: l_p_ship_from_org_id NUMBER;
2952: l_project_count NUMBER;
2953:

Line 2950: x_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;

2946: l_sr_account_id NUMBER; -- swai: bug 6001057
2947:
2948: --taklam
2949: l_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;
2950: x_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;
2951: l_p_ship_from_org_id NUMBER;
2952: l_project_count NUMBER;
2953:
2954: --taklam

Line 3084: l_Line_Tbl_Type(1) := OE_Order_PUB.G_MISS_LINE_REC;

3080: OR (p_product_txn_rec.action_type in ('RMA_THIRD_PTY', 'SHIP_THIRD_PTY')))
3081: and (p_product_txn_rec.project_id <> FND_API.G_MISS_NUM)) then --bug#6075825
3082:
3083: if (l_order_line_id) is not null then
3084: l_Line_Tbl_Type(1) := OE_Order_PUB.G_MISS_LINE_REC;
3085: l_Line_Tbl_Type(1).line_id := l_order_line_id;
3086: l_Line_Tbl_Type(1).operation := OE_GLOBALS.G_OPR_UPDATE;
3087:
3088: -- taklam: update projects fields

Line 3126: OE_ORDER_PUB.Process_Line(

3122: l_Line_Tbl_Type(1).end_customer_id := l_sr_account_id;
3123: end if;
3124: end if; -- end update 3rd party fields
3125:
3126: OE_ORDER_PUB.Process_Line(
3127: p_line_tbl => l_Line_Tbl_Type,
3128: x_line_out_tbl => x_Line_Tbl_Type,
3129: x_return_status => x_return_status,
3130: x_msg_count => l_msg_count,

Line 3949: l_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;

3945: WHERE header_id = p_header_id;
3946:
3947:
3948:
3949: l_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;
3950: x_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;
3951:
3952: BEGIN
3953:

Line 3950: x_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;

3946:
3947:
3948:
3949: l_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;
3950: x_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;
3951:
3952: BEGIN
3953:
3954: SAVEPOINT CANCEL_PRODTXN_PVT;

Line 3996: l_Line_Tbl_Type(1) := OE_Order_PUB.G_MISS_LINE_REC;/*Fixed for bug#5968687*/

3992:
3993: Oe_Standard_Wf.SAVE_MESSAGES_OFF;
3994:
3995: --dbms_output.put_line('Calling OE_Order_GRP.Process_Order');
3996: l_Line_Tbl_Type(1) := OE_Order_PUB.G_MISS_LINE_REC;/*Fixed for bug#5968687*/
3997:
3998: OPEN C_cancel_reason;
3999: FETCH C_cancel_reason INTO l_Line_Tbl_Type(1).change_reason;
4000: CLOSE C_cancel_reason;

Line 4006: /* l_Line_Tbl_Type(1) := OE_Order_PUB.G_MISS_LINE_REC; */

4002: /*Fixed for bug#5968687
4003: Initialization of line table type record is moved up.
4004: Initialization should be done before assigning any value to record.
4005: */
4006: /* l_Line_Tbl_Type(1) := OE_Order_PUB.G_MISS_LINE_REC; */
4007: l_Line_Tbl_Type(1).header_id := p_order_header_id;
4008: l_Line_Tbl_Type(1).line_id := p_order_line_id;
4009: l_Line_Tbl_Type(1).cancelled_flag := 'Y';
4010: l_Line_Tbl_Type(1).ordered_quantity := 0;

Line 4015: OE_ORDER_PUB.Process_Line(

4011:
4012:
4013: l_Line_Tbl_Type(1).operation := OE_GLOBALS.G_OPR_UPDATE;
4014: --bug#7551068
4015: OE_ORDER_PUB.Process_Line(
4016: p_line_tbl => l_Line_Tbl_Type,
4017: x_line_out_tbl => x_Line_Tbl_Type,
4018: x_return_status => x_return_status,
4019: x_msg_count => x_msg_count,