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 2838: l_Line_Tbl_Type(1) := OE_Order_PUB.G_MISS_LINE_REC;

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

Line 2886: OE_ORDER_PUB.Process_Line(

2882: l_Line_Tbl_Type(1).end_customer_id := l_sr_account_id;
2883: end if;
2884: end if; -- end update 3rd party fields
2885:
2886: OE_ORDER_PUB.Process_Line(
2887: p_line_tbl => l_Line_Tbl_Type,
2888: x_line_out_tbl => x_Line_Tbl_Type,
2889: x_return_status => x_return_status,
2890: x_msg_count => l_msg_count,

Line 2956: l_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;

2952:
2953: l_sr_account_id NUMBER; -- swai: bug 6001057
2954:
2955: --taklam
2956: l_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;
2957: x_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;
2958: l_p_ship_from_org_id NUMBER;
2959: l_project_count NUMBER;
2960:

Line 2957: x_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;

2953: l_sr_account_id NUMBER; -- swai: bug 6001057
2954:
2955: --taklam
2956: l_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;
2957: x_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;
2958: l_p_ship_from_org_id NUMBER;
2959: l_project_count NUMBER;
2960:
2961: --taklam

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

3088: OR (p_product_txn_rec.action_type in ('RMA_THIRD_PTY', 'SHIP_THIRD_PTY')))
3089: and ((NVL(p_product_txn_rec.project_id,-1)) <> FND_API.G_MISS_NUM)) then --bug#6075825
3090:
3091: if (l_order_line_id) is not null then
3092: l_Line_Tbl_Type(1) := OE_Order_PUB.G_MISS_LINE_REC;
3093: l_Line_Tbl_Type(1).line_id := l_order_line_id;
3094: l_Line_Tbl_Type(1).operation := OE_GLOBALS.G_OPR_UPDATE;
3095:
3096: -- taklam: update projects fields

Line 3140: OE_ORDER_PUB.Process_Line(

3136: l_Line_Tbl_Type(1).end_customer_id := l_sr_account_id;
3137: end if;
3138: end if; -- end update 3rd party fields
3139:
3140: OE_ORDER_PUB.Process_Line(
3141: p_line_tbl => l_Line_Tbl_Type,
3142: x_line_out_tbl => x_Line_Tbl_Type,
3143: x_return_status => x_return_status,
3144: x_msg_count => l_msg_count,

Line 3963: l_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;

3959: WHERE header_id = p_header_id;
3960:
3961:
3962:
3963: l_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;
3964: x_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;
3965:
3966: BEGIN
3967:

Line 3964: x_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;

3960:
3961:
3962:
3963: l_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;
3964: x_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;
3965:
3966: BEGIN
3967:
3968: SAVEPOINT CANCEL_PRODTXN_PVT;

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

4006:
4007: Oe_Standard_Wf.SAVE_MESSAGES_OFF;
4008:
4009: --dbms_output.put_line('Calling OE_Order_GRP.Process_Order');
4010: l_Line_Tbl_Type(1) := OE_Order_PUB.G_MISS_LINE_REC;/*Fixed for bug#5968687*/
4011:
4012: OPEN C_cancel_reason;
4013: FETCH C_cancel_reason INTO l_Line_Tbl_Type(1).change_reason;
4014: CLOSE C_cancel_reason;

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

4016: /*Fixed for bug#5968687
4017: Initialization of line table type record is moved up.
4018: Initialization should be done before assigning any value to record.
4019: */
4020: /* l_Line_Tbl_Type(1) := OE_Order_PUB.G_MISS_LINE_REC; */
4021: l_Line_Tbl_Type(1).header_id := p_order_header_id;
4022: l_Line_Tbl_Type(1).line_id := p_order_line_id;
4023: l_Line_Tbl_Type(1).cancelled_flag := 'Y';
4024: l_Line_Tbl_Type(1).ordered_quantity := 0;

Line 4029: OE_ORDER_PUB.Process_Line(

4025:
4026:
4027: l_Line_Tbl_Type(1).operation := OE_GLOBALS.G_OPR_UPDATE;
4028: --bug#7551068
4029: OE_ORDER_PUB.Process_Line(
4030: p_line_tbl => l_Line_Tbl_Type,
4031: x_line_out_tbl => x_Line_Tbl_Type,
4032: x_return_status => x_return_status,
4033: x_msg_count => x_msg_count,