DBA Data[Home] [Help]

APPS.RLM_CUM_SV dependencies on OE_ORDER_PUB

Line 1543: l_oe_line_tbl_out oe_order_pub.line_tbl_type;

1539: oelines.source_document_id,
1540: oelines.source_document_line_id,
1541: oeLines.org_id;
1542: --
1543: l_oe_line_tbl_out oe_order_pub.line_tbl_type;
1544: --
1545: BEGIN
1546: --
1547: IF (l_debug <> -1) THEN

Line 1605: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;

1601: END IF;
1602: --
1603: --Reset counter
1604: counter := 0;
1605: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;
1606: --
1607: --Get the header_id for each loop iteration
1608: --
1609: v_oe_header_id := v_oe_header(v_loop_count).header_id;

Line 2024: g_oe_line_tbl(counter) := OE_Order_PUB.G_MISS_LINE_REC;

2020: oe_order_lines table */
2021: --
2022: counter := counter + 1;
2023: -- Bug# 1466909
2024: g_oe_line_tbl(counter) := OE_Order_PUB.G_MISS_LINE_REC;
2025: g_oe_line_tbl(counter).header_id := v_header_id;
2026: g_oe_line_tbl(counter).line_id := v_line_id;
2027: g_oe_line_tbl(counter).operation := oe_globals.G_OPR_UPDATE;
2028: g_oe_line_tbl(counter).veh_cus_item_cum_key_id := v_cum_record.cum_key_id;

Line 3466: l_oe_line_tbl_out oe_order_pub.line_tbl_type;

3462: e_NoCum EXCEPTION;
3463: e_NoShipment EXCEPTION;
3464: v_visited BOOLEAN;
3465: --
3466: l_oe_line_tbl_out oe_order_pub.line_tbl_type;
3467: --
3468: BEGIN
3469: --
3470: IF (l_debug <> -1) THEN

Line 3728: g_oe_tmp_line_tbl := oe_order_pub.g_miss_line_tbl;

3724: rlm_core_sv.dlog(C_DEBUG,'v_old_cum_records.count',
3725: v_old_cum_records.count);
3726: END IF;
3727: --
3728: g_oe_tmp_line_tbl := oe_order_pub.g_miss_line_tbl;
3729: --
3730: FOR v_index IN 1..v_num LOOP --{
3731: --
3732: SAVEPOINT s_reset_counter;

Line 4032: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;

4028: IF (l_debug <> -1) THEN
4029: rlm_core_sv.dlog(C_DEBUG, 'v_header_id',v_header_id);
4030: END IF;
4031: --
4032: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;
4033: --
4034: --g_oe_tmp_line_tbl := oe_order_pub.g_miss_line_tbl;
4035: --
4036: BEGIN --{

Line 4034: --g_oe_tmp_line_tbl := oe_order_pub.g_miss_line_tbl;

4030: END IF;
4031: --
4032: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;
4033: --
4034: --g_oe_tmp_line_tbl := oe_order_pub.g_miss_line_tbl;
4035: --
4036: BEGIN --{
4037: --
4038: fnd_profile.get('ECE_OUT_FILE_PATH',v_om_dbg_dir);

Line 4228: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;

4224: END IF; --}
4225: --
4226: g_oe_line_tbl.DELETE;
4227: --
4228: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;
4229: --
4230: g_oe_line_tbl(v_index2) := g_oe_tmp_line_tbl(v_index3);
4231: --
4232: END IF; --} if the header_id has not changed

Line 5585: --g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;

5581: rlm_core_sv.dlog(C_DEBUG,'cum qty',
5582: x_cum_records(x_index).cum_qty);
5583: END IF;
5584: --
5585: --g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;
5586: --
5587: g_oe_tmp_line_tbl(x_counter) := OE_Order_PUB.G_MISS_LINE_REC;
5588: --
5589: g_oe_tmp_line_tbl(x_counter).header_id := v_header_id;

Line 5587: g_oe_tmp_line_tbl(x_counter) := OE_Order_PUB.G_MISS_LINE_REC;

5583: END IF;
5584: --
5585: --g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;
5586: --
5587: g_oe_tmp_line_tbl(x_counter) := OE_Order_PUB.G_MISS_LINE_REC;
5588: --
5589: g_oe_tmp_line_tbl(x_counter).header_id := v_header_id;
5590: --
5591: g_oe_tmp_line_tbl(x_counter).line_id := v_line_id;

Line 5754: T oe_order_pub.Line_Rec_Type ;

5750: j IN NUMBER,
5751: sortType IN NUMBER)
5752: IS
5753:
5754: T oe_order_pub.Line_Rec_Type ;
5755: T2 rlm_cum_sv.cum_oe_lines_type;
5756: v_Progress VARCHAR2(3) := '010';
5757:
5758: BEGIN

Line 5928: l_oe_line_tbl_out oe_order_pub.line_tbl_type;

5924: v_msg_data VARCHAR2(2000);
5925: e_noshipment EXCEPTION;
5926: e_SetSupplierCum EXCEPTION;
5927: --
5928: l_oe_line_tbl_out oe_order_pub.line_tbl_type;
5929: --
5930: BEGIN
5931: --
5932: IF (l_debug <> -1) THEN

Line 5937: g_oe_tmp_line_tbl := oe_order_pub.g_miss_line_tbl;

5933: rlm_core_sv.dpush(C_DEBUG, 'UpdateOldKey');
5934: END IF;
5935: --
5936: g_oe_tmp_line_tbl.DELETE;
5937: g_oe_tmp_line_tbl := oe_order_pub.g_miss_line_tbl;
5938: g_oe_line_tbl.DELETE;
5939: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;
5940: --
5941: x_return_status := TRUE;

Line 5939: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;

5935: --
5936: g_oe_tmp_line_tbl.DELETE;
5937: g_oe_tmp_line_tbl := oe_order_pub.g_miss_line_tbl;
5938: g_oe_line_tbl.DELETE;
5939: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;
5940: --
5941: x_return_status := TRUE;
5942: --
5943: FOR cum_records_counter in 1..x_old_cum_records.COUNT LOOP

Line 6098: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;

6094: IF (l_debug <> -1) THEN
6095: rlm_core_sv.dlog(C_DEBUG, 'v_header_id',v_header_id);
6096: END IF;
6097: --
6098: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;
6099: --
6100: BEGIN --{
6101: --
6102: fnd_profile.get('ECE_OUT_FILE_PATH',v_om_dbg_dir);

Line 6271: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;

6267: END IF; --}
6268: --
6269: g_oe_line_tbl.DELETE;
6270: --
6271: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;
6272: --
6273: g_oe_line_tbl(v_line_idx) := g_oe_tmp_line_tbl(v_tmp_line_idx);
6274: --
6275: END IF; --} if the header_id has not changed