APPS.OZF_TRACING_ORDER_PVT dependencies on OZF_RESALE_LINES

Line 81: From ozf_resale_lines_int

77:
78:
79: CURSOR OPEN_line_count_csr (p_id in NUMBER) IS
80: SELECT count(1)
81: From ozf_resale_lines_int
82: WHERE resale_batch_id = p_id
83: AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN;
84: l_count NUMBER;
85:

Line 100: FROM ozf_resale_lines_int

96: p_cust_id in NUMBER,
97: p_date in DATE)
98: IS
99: SELECT resale_line_int_id
100: FROM ozf_resale_lines_int
101: WHERE resale_batch_id = p_id
102: AND order_number = p_order_number
103: AND sold_from_cust_account_id = p_cust_id
104: AND date_ordered = p_date

Line 123: , ozf_resale_lines_int b

119: , p_date IN DATE
120: ) IS
121: SELECT a.resale_header_id
122: FROM ozf_resale_headers a
123: , ozf_resale_lines_int b
124: , ozf_resale_lines c
125: WHERE b.resale_batch_id = p_id
126: AND b.order_number = p_order_number
127: AND b.sold_from_cust_account_id = p_cust_id

Line 124: , ozf_resale_lines c

120: ) IS
121: SELECT a.resale_header_id
122: FROM ozf_resale_headers a
123: , ozf_resale_lines_int b
124: , ozf_resale_lines c
125: WHERE b.resale_batch_id = p_id
126: AND b.order_number = p_order_number
127: AND b.sold_from_cust_account_id = p_cust_id
128: AND b.date_ordered = p_date

Line 142: FROM ozf_resale_lines_int

138: CURSOR batch_order_num_csr(p_id in NUMBER)is
139: SELECT DISTINCT order_number,
140: sold_from_cust_account_id,
141: date_ordered
142: FROM ozf_resale_lines_int
143: WHERE resale_batch_id = p_id
144: AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED)
145: --AND duplicated_adjustment_id <> -1
146: ORDER BY date_ordered;

Line 178: FROM ozf_resale_lines_int_all

174: , bill_to_city
175: , bill_to_state
176: , bill_to_postal_code
177: , bill_to_country
178: FROM ozf_resale_lines_int_all
179: WHERE resale_batch_id = cv_resale_batch_id
180: AND status_code = 'PROCESSED'
181: AND ( duplicated_line_id IS NULL
182: OR ( duplicated_line_id IS NOT NULL AND duplicated_adjustment_id = -1))

Line 199: FROM ozf_resale_lines_int_all

195: , end_cust_state
196: , end_cust_postal_code
197: , end_cust_country
198: , end_cust_site_use_code
199: FROM ozf_resale_lines_int_all
200: WHERE resale_batch_id = cv_resale_batch_id
201: AND status_code = 'PROCESSED'
202: AND ( duplicated_line_id IS NULL
203: OR ( duplicated_line_id IS NOT NULL AND duplicated_adjustment_id = -1))

Line 354: UPDATE ozf_resale_lines_int_all

350: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352: END IF;
353:
354: UPDATE ozf_resale_lines_int_all
355: SET bill_to_party_id = l_new_party_rec.party_id
356: , bill_to_party_site_id = l_new_party_rec.party_site_id
357: WHERE resale_batch_id = p_resale_batch_id
358: AND bill_to_party_id IS NULL

Line 409: UPDATE ozf_resale_lines_int_all

405: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
407: END IF;
408:
409: UPDATE ozf_resale_lines_int_all
410: SET end_cust_party_id = l_new_party_rec.party_id
411: , end_cust_party_site_id = l_new_party_rec.party_site_id
412: WHERE resale_batch_id = p_resale_batch_id
413: AND end_cust_party_id IS NULL

Line 471: UPDATE ozf_resale_lines_int_all

467:
468: -- There is something wrong with this order. dispute all the orders
469: -- and move to the next one.
470: -- JXWU move update to common pvt
471: UPDATE ozf_resale_lines_int_all
472: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
473: dispute_code = 'OZF_RESALE_MULTI_HEADER',
474: followup_action_code = NVL2(followup_action_code,followup_action_code,'C'),
475: response_type = 'CA',

Line 552: UPDATE ozf_resale_lines_int

548: IF OZF_DEBUG_LOW_ON THEN
549: OZF_UTILITY_PVT.debug_message('Did NOT pass inventory checking');
550: END IF;
551: -- Here turn thIS line to DISPUTED AND create a dISput code FOR it.
552: UPDATE ozf_resale_lines_int
553: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
554: dispute_code = 'OZF_LT_INVT',
555: followup_action_code = NVL2(followup_action_code,followup_action_code,'C'),
556: response_type = 'CA',

Line 723: UPDATE ozf_resale_lines_int_all

719:
720: -- UPDATE batch line status to CLOSEd for each OPEN and duplicated lines.
721:
722: BEGIN
723: UPDATE ozf_resale_lines_int_all
724: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_CLOSED
725: WHERE resale_batch_id = p_resale_batch_id
726: --Bug# 8414563 fixed by ateotia(+)
727: --AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED);

Line 823: FROM ozf_resale_lines_int

819: l_msg_count NUMBER;
820:
821: CURSOR non_tracing_count_csr(p_id IN NUMBER) IS
822: SELECT COUNT(1)
823: FROM ozf_resale_lines_int
824: WHERE resale_batch_id = p_id
825: AND tracing_flag = 'F';
826:
827: l_non_tracing_count NUMBER;

Line 878: FROM ozf_resale_lines_int_all b

874: FND_MESSAGE.get_string('OZF','OZF_RESALE_NON_TRC'),
875: 'TRACING_FLAG',
876: tracing_flag,
877: org_id
878: FROM ozf_resale_lines_int_all b
879: WHERE b.status_code = 'OPEN'
880: AND b.tracing_flag = 'F'
881: AND b.resale_batch_id = p_resale_batch_id
882: AND NOT EXISTS(SELECT 1

Line 897: UPDATE ozf_resale_lines_int_all

893: p_token_value => l_full_name||': END');
894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
895: END;
896:
897: UPDATE ozf_resale_lines_int_all
898: SET status_code = 'DISPUTED',
899: dispute_code = 'OZF_RESALE_NON_TRC',
900: followup_action_code = NVL2(followup_action_code,followup_action_code,'C'),
901: response_type = 'CA',

Line 982: FROM ozf_resale_lines_int

978: CURSOR order_num_csr IS
979: SELECT DISTINCT order_number,
980: sold_from_cust_account_id,
981: date_ordered
982: FROM ozf_resale_lines_int
983: WHERE status_code = 'OPEN'
984: -- status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED)
985: AND duplicated_adjustment_id IS NULL
986: AND resale_batch_id = p_resale_batch_id

Line 997: FROM ozf_resale_lines_int

993: CURSOR order_set_csr(p_order_NUMBER in VARCHAR2,
994: p_cust_account_id in NUMBER,
995: p_date in date) IS
996: SELECT *
997: FROM ozf_resale_lines_int
998: WHERE order_NUMBER = p_order_NUMBER
999: AND date_ordered = p_date
1000: AND sold_from_cust_account_id = p_cust_account_id
1001: AND status_code = 'OPEN'

Line 1011: FROM ozf_resale_lines_int

1007: l_order_set_tbl resale_lines_tbl_type;
1008:
1009: CURSOR invalid_line_count_csr (p_id NUMBER) IS
1010: SELECT COUNT(1)
1011: FROM ozf_resale_lines_int
1012: WHERE status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED
1013: AND dispute_code = OZF_RESALE_COMMON_PVT.G_INVALD_DISPUTE_CODE
1014: AND resale_batch_id = p_id;
1015:

Line 1213: UPDATE ozf_resale_lines_int

1209: IF OZF_DEBUG_LOW_ON THEN
1210: ozf_utility_PVT.debug_message('Did not pass inventory checking');
1211: END IF;
1212: -- Here turn this line to disputed and create a disput code for it.
1213: UPDATE ozf_resale_lines_int
1214: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1215: dispute_code = 'OZF_LT_INVT',
1216: followup_action_code = NVL2(followup_action_code,followup_action_code,'C'),
1217: response_type = 'CA',

Line 1229: UPDATE ozf_resale_lines_int

1225:
1226: GOTO END_ORDER_LINE;
1227: ELSE
1228: -- This is a valid tracing line
1229: UPDATE ozf_resale_lines_int
1230: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED
1231: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id;
1232: END IF;
1233: ELSE

Line 1235: UPDATE ozf_resale_lines_int

1231: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id;
1232: END IF;
1233: ELSE
1234: -- Set line status to Processed if not tracking inventory
1235: UPDATE ozf_resale_lines_int
1236: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED
1237: WHERE resale_line_int_Id = l_order_set_tbl(j).resale_line_int_id;
1238: END IF;
1239: << END_ORDER_LINE >>