DBA Data[Home] [Help]

APPS.OE_MASS_CHANGE_PVT dependencies on OE_ORDER_PUB

Line 278: l_header_rec OE_Order_PUB.Header_Rec_Type;

274: , p_cascade_header_changes IN VARCHAR2 -- Added for Cascade Header changes in Mass Change ER 7509356
275:
276:
277: ) IS
278: l_header_rec OE_Order_PUB.Header_Rec_Type;
279: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
280: l_control_rec OE_GLOBALS.Control_Rec_Type;
281: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
282: l_mc_err_handling_flag NUMBER := p_mc_err_handling_flag ;

Line 279: l_old_header_rec OE_Order_PUB.Header_Rec_Type;

275:
276:
277: ) IS
278: l_header_rec OE_Order_PUB.Header_Rec_Type;
279: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
280: l_control_rec OE_GLOBALS.Control_Rec_Type;
281: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
282: l_mc_err_handling_flag NUMBER := p_mc_err_handling_flag ;
283: l_init_msg_list VARCHAR2(1) := 'F';

Line 281: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

277: ) IS
278: l_header_rec OE_Order_PUB.Header_Rec_Type;
279: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
280: l_control_rec OE_GLOBALS.Control_Rec_Type;
281: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
282: l_mc_err_handling_flag NUMBER := p_mc_err_handling_flag ;
283: l_init_msg_list VARCHAR2(1) := 'F';
284: l_return_status VARCHAR2(30);
285: l_api_name CONSTANT VARCHAR2(30) := 'Process_Order_Scalar';

Line 291: l_line_tbl oe_order_pub.line_tbl_type;

287: l_header_id Number;
288: l_sold_to_org_id NUMBER := p_sold_to_org_id;
289: l_ship_to_org_id NUMBER := p_ship_to_org_id;
290: l_error_count NUMBER :=0;
291: l_line_tbl oe_order_pub.line_tbl_type;
292:
293: j Integer;
294: initial Integer;
295: nextpos Integer;

Line 323: l_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;

319: End If;
320: --MOAC PI
321: G_COUNTER:=G_COUNTER+1;
322: --dbms_output.put_line('ini='||to_char(initial)||'next='||to_char(nextpos));
323: l_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
324: l_old_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
325: -- l_header_id := to_number(substr(p_record_ids,initial, nextpos-initial));
326: --dbms_output.put_line('id='||to_char(l_header_id));
327: -- initial := nextpos + 1;

Line 324: l_old_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;

320: --MOAC PI
321: G_COUNTER:=G_COUNTER+1;
322: --dbms_output.put_line('ini='||to_char(initial)||'next='||to_char(nextpos));
323: l_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
324: l_old_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
325: -- l_header_id := to_number(substr(p_record_ids,initial, nextpos-initial));
326: --dbms_output.put_line('id='||to_char(l_header_id));
327: -- initial := nextpos + 1;
328: /* j := j + 1;

Line 1527: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

1523: l_error_count NUMBER := 0;
1524: l_header_id Number;
1525: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1526: l_line_id Number;
1527: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1528: l_mc_err_handling_flag NUMBER := p_mc_err_handling_flag;
1529: l_num_of_records NUMBER;
1530: l_old_arrival_set_id number;
1531: l_old_header_id number;

Line 1532: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

1528: l_mc_err_handling_flag NUMBER := p_mc_err_handling_flag;
1529: l_num_of_records NUMBER;
1530: l_old_arrival_set_id number;
1531: l_old_header_id number;
1532: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1533: l_old_org_id number;
1534: l_old_ship_set_id number;
1535: l_old_top_model_line_id number;
1536: l_rec number;

Line 1540: l_x_line_rec OE_ORDER_PUB.Line_Rec_Type;

1536: l_rec number;
1537: l_return_status VARCHAR2(30);
1538: l_ship_set_id number;
1539: l_top_model_line_id number;
1540: l_x_line_rec OE_ORDER_PUB.Line_Rec_Type;
1541: nextpos Integer;
1542:
1543: CURSOR c1 IS SELECT x.id1, x.org_id, l.header_id, l.arrival_set_id,
1544: l.ship_set_id, l.top_model_line_id

Line 1620: l_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;

1616: SAVEPOINT Process_Line_Scalar;
1617:
1618: l_rec := 0;
1619:
1620: l_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;
1621: l_old_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;
1622: l_return_status := NULL;
1623:
1624: LOOP -- Inner loop

Line 1621: l_old_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;

1617:
1618: l_rec := 0;
1619:
1620: l_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;
1621: l_old_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;
1622: l_return_status := NULL;
1623:
1624: LOOP -- Inner loop
1625:

Line 1644: l_line_tbl(l_rec) := OE_ORDER_PUB.G_MISS_LINE_REC;

1640: l_old_top_model_line_id := l_top_model_line_id;
1641: l_old_org_id := l_current_org_id;
1642:
1643: l_rec := l_rec + 1;
1644: l_line_tbl(l_rec) := OE_ORDER_PUB.G_MISS_LINE_REC;
1645: l_line_tbl(l_rec).line_id := l_line_id;
1646: l_line_tbl(l_rec).header_id := l_header_id;
1647:
1648: OE_Line_Util.Lock_Row ( x_return_status => l_return_status,