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 1535: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

1531: l_error_count NUMBER := 0;
1532: l_header_id Number;
1533: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1534: l_line_id Number;
1535: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1536: l_mc_err_handling_flag NUMBER := p_mc_err_handling_flag;
1537: l_num_of_records NUMBER;
1538: l_old_arrival_set_id number;
1539: l_old_header_id number;

Line 1540: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

1536: l_mc_err_handling_flag NUMBER := p_mc_err_handling_flag;
1537: l_num_of_records NUMBER;
1538: l_old_arrival_set_id number;
1539: l_old_header_id number;
1540: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1541: l_old_org_id number;
1542: l_old_ship_set_id number;
1543: l_old_top_model_line_id number;
1544: l_rec number;

Line 1548: l_x_line_rec OE_ORDER_PUB.Line_Rec_Type;

1544: l_rec number;
1545: l_return_status VARCHAR2(30);
1546: l_ship_set_id number;
1547: l_top_model_line_id number;
1548: l_x_line_rec OE_ORDER_PUB.Line_Rec_Type;
1549: nextpos Integer;
1550:
1551: CURSOR c1 IS SELECT x.id1, x.org_id, l.header_id, l.arrival_set_id,
1552: l.ship_set_id, l.top_model_line_id

Line 1628: l_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;

1624: SAVEPOINT Process_Line_Scalar;
1625:
1626: l_rec := 0;
1627:
1628: l_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;
1629: l_old_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;
1630: l_return_status := NULL;
1631:
1632: LOOP -- Inner loop

Line 1629: l_old_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;

1625:
1626: l_rec := 0;
1627:
1628: l_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;
1629: l_old_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;
1630: l_return_status := NULL;
1631:
1632: LOOP -- Inner loop
1633:

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

1648: l_old_top_model_line_id := l_top_model_line_id;
1649: l_old_org_id := l_current_org_id;
1650:
1651: l_rec := l_rec + 1;
1652: l_line_tbl(l_rec) := OE_ORDER_PUB.G_MISS_LINE_REC;
1653: l_line_tbl(l_rec).line_id := l_line_id;
1654: l_line_tbl(l_rec).header_id := l_header_id;
1655:
1656: OE_Line_Util.Lock_Row ( x_return_status => l_return_status,

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

1699: l_old_ship_set_id := l_ship_set_id;
1700: l_old_top_model_line_id := l_top_model_line_id;
1701:
1702: l_rec := l_rec + 1;
1703: l_line_tbl(l_rec) := OE_ORDER_PUB.G_MISS_LINE_REC;
1704: l_line_tbl(l_rec).line_id := l_line_id;
1705: G_COUNTER := G_COUNTER + 1;
1706: end loop; --bug# 13067303
1707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1743: l_old_ship_set_id := l_ship_set_id;
1744: l_old_top_model_line_id := l_top_model_line_id;
1745:
1746: l_rec := l_rec + 1;
1747: l_line_tbl(l_rec) := OE_ORDER_PUB.G_MISS_LINE_REC;
1748: l_line_tbl(l_rec).line_id := l_line_id;
1749: G_COUNTER := G_COUNTER + 1;
1750: end loop; --End of bug# 13067303
1751: RAISE FND_API.G_EXC_ERROR;