DBA Data[Home] [Help]

APPS.RLM_CUM_SV dependencies on OE_ORDER_PUB

Line 1552: l_oe_line_tbl_out oe_order_pub.line_tbl_type;

1548: oelines.source_document_id,
1549: oelines.source_document_line_id,
1550: oeLines.org_id;
1551: --
1552: l_oe_line_tbl_out oe_order_pub.line_tbl_type;
1553: --
1554: BEGIN
1555: --
1556: IF (l_debug <> -1) THEN

Line 1614: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;

1610: END IF;
1611: --
1612: --Reset counter
1613: counter := 0;
1614: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;
1615: --
1616: --Get the header_id for each loop iteration
1617: --
1618: v_oe_header_id := v_oe_header(v_loop_count).header_id;

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

2030: oe_order_lines table */
2031: --
2032: counter := counter + 1;
2033: -- Bug# 1466909
2034: g_oe_line_tbl(counter) := OE_Order_PUB.G_MISS_LINE_REC;
2035: g_oe_line_tbl(counter).header_id := v_header_id;
2036: g_oe_line_tbl(counter).line_id := v_line_id;
2037: g_oe_line_tbl(counter).operation := oe_globals.G_OPR_UPDATE;
2038: g_oe_line_tbl(counter).veh_cus_item_cum_key_id := v_cum_record.cum_key_id;

Line 3476: l_oe_line_tbl_out oe_order_pub.line_tbl_type;

3472: e_NoCum EXCEPTION;
3473: e_NoShipment EXCEPTION;
3474: v_visited BOOLEAN;
3475: --
3476: l_oe_line_tbl_out oe_order_pub.line_tbl_type;
3477: --
3478: BEGIN
3479: --
3480: IF (l_debug <> -1) THEN

Line 3738: g_oe_tmp_line_tbl := oe_order_pub.g_miss_line_tbl;

3734: rlm_core_sv.dlog(C_DEBUG,'v_old_cum_records.count',
3735: v_old_cum_records.count);
3736: END IF;
3737: --
3738: g_oe_tmp_line_tbl := oe_order_pub.g_miss_line_tbl;
3739: --
3740: FOR v_index IN 1..v_num LOOP --{
3741: --
3742: SAVEPOINT s_reset_counter;

Line 4042: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;

4038: IF (l_debug <> -1) THEN
4039: rlm_core_sv.dlog(C_DEBUG, 'v_header_id',v_header_id);
4040: END IF;
4041: --
4042: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;
4043: --
4044: --g_oe_tmp_line_tbl := oe_order_pub.g_miss_line_tbl;
4045: --
4046: BEGIN --{

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

4040: END IF;
4041: --
4042: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;
4043: --
4044: --g_oe_tmp_line_tbl := oe_order_pub.g_miss_line_tbl;
4045: --
4046: BEGIN --{
4047: --
4048: fnd_profile.get('ECE_OUT_FILE_PATH',v_om_dbg_dir);

Line 4238: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;

4234: END IF; --}
4235: --
4236: g_oe_line_tbl.DELETE;
4237: --
4238: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;
4239: --
4240: g_oe_line_tbl(v_index2) := g_oe_tmp_line_tbl(v_index3);
4241: --
4242: END IF; --} if the header_id has not changed

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

5591: rlm_core_sv.dlog(C_DEBUG,'cum qty',
5592: x_cum_records(x_index).cum_qty);
5593: END IF;
5594: --
5595: --g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;
5596: --
5597: g_oe_tmp_line_tbl(x_counter) := OE_Order_PUB.G_MISS_LINE_REC;
5598: --
5599: g_oe_tmp_line_tbl(x_counter).header_id := v_header_id;

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

5593: END IF;
5594: --
5595: --g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;
5596: --
5597: g_oe_tmp_line_tbl(x_counter) := OE_Order_PUB.G_MISS_LINE_REC;
5598: --
5599: g_oe_tmp_line_tbl(x_counter).header_id := v_header_id;
5600: --
5601: g_oe_tmp_line_tbl(x_counter).line_id := v_line_id;

Line 5764: T oe_order_pub.Line_Rec_Type ;

5760: j IN NUMBER,
5761: sortType IN NUMBER)
5762: IS
5763:
5764: T oe_order_pub.Line_Rec_Type ;
5765: T2 rlm_cum_sv.cum_oe_lines_type;
5766: v_Progress VARCHAR2(3) := '010';
5767:
5768: BEGIN

Line 5938: l_oe_line_tbl_out oe_order_pub.line_tbl_type;

5934: v_msg_data VARCHAR2(2000);
5935: e_noshipment EXCEPTION;
5936: e_SetSupplierCum EXCEPTION;
5937: --
5938: l_oe_line_tbl_out oe_order_pub.line_tbl_type;
5939: --
5940: BEGIN
5941: --
5942: IF (l_debug <> -1) THEN

Line 5947: g_oe_tmp_line_tbl := oe_order_pub.g_miss_line_tbl;

5943: rlm_core_sv.dpush(C_DEBUG, 'UpdateOldKey');
5944: END IF;
5945: --
5946: g_oe_tmp_line_tbl.DELETE;
5947: g_oe_tmp_line_tbl := oe_order_pub.g_miss_line_tbl;
5948: g_oe_line_tbl.DELETE;
5949: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;
5950: --
5951: x_return_status := TRUE;

Line 5949: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;

5945: --
5946: g_oe_tmp_line_tbl.DELETE;
5947: g_oe_tmp_line_tbl := oe_order_pub.g_miss_line_tbl;
5948: g_oe_line_tbl.DELETE;
5949: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;
5950: --
5951: x_return_status := TRUE;
5952: --
5953: FOR cum_records_counter in 1..x_old_cum_records.COUNT LOOP

Line 6108: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;

6104: IF (l_debug <> -1) THEN
6105: rlm_core_sv.dlog(C_DEBUG, 'v_header_id',v_header_id);
6106: END IF;
6107: --
6108: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;
6109: --
6110: BEGIN --{
6111: --
6112: fnd_profile.get('ECE_OUT_FILE_PATH',v_om_dbg_dir);

Line 6281: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;

6277: END IF; --}
6278: --
6279: g_oe_line_tbl.DELETE;
6280: --
6281: g_oe_line_tbl := oe_order_pub.g_miss_line_tbl;
6282: --
6283: g_oe_line_tbl(v_line_idx) := g_oe_tmp_line_tbl(v_tmp_line_idx);
6284: --
6285: END IF; --} if the header_id has not changed