APPS.OZF_TRACING_ORDER_PVT dependencies on OZF_RESALE_BATCHES

Line 56: FROM ozf_resale_batches

52: report_start_date,
53: report_end_date,
54: batch_number,
55: last_updated_by
56: FROM ozf_resale_batches
57: WHERE resale_batch_id = p_id;
58: l_batch_status VARCHAR2(30);
59: l_batch_type VARCHAR2(30);
60: l_partner_cust_account_id NUMBER;

Line 512: UPDATE ozf_resale_batches

508: response_code = 'N'
509: WHERE resale_line_int_id = l_line_int_rec.resale_line_int_id;
510:
511: -- SET Batch as DISPUTED
512: UPDATE ozf_resale_batches
513: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
514: WHERE resale_batch_id = l_line_int_rec.resale_batch_id;
515:
516: GOTO END_ORDER_LINE;

Line 676: UPDATE ozf_resale_batches

672: AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED);
673: --AND duplicated_adjustment_id <> -1;
674:
675: -- UPDATE batch status to CLOSEd -- might change later.
676: UPDATE ozf_resale_batches
677: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED
678: WHERE resale_batch_id = p_resale_batch_id;
679: EXCEPTION
680: WHEN OTHERS THEN

Line 976: FROM ozf_resale_batches

972: CURSOR Batch_info_csr (p_id in NUMBER) IS
973: SELECT partner_party_id,
974: report_start_date,
975: report_end_date
976: FROM ozf_resale_batches
977: WHERE resale_batch_id = p_id;
978: l_partner_party_id NUMBER;
979: l_report_start_date date;
980: l_report_end_date date;

Line 1156: UPDATE ozf_resale_batches

1152: response_code = 'N'
1153: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id;
1154:
1155: -- SET Batch as DISPUTED
1156: UPDATE ozf_resale_batches
1157: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
1158: WHERE resale_batch_id = p_resale_batch_id;
1159:
1160: GOTO END_ORDER_LINE;

Line 1207: UPDATE ozf_resale_batches

1203: END IF;
1204:
1205: -- Lastly, I will UPDATE the batch
1206: BEGIN
1207: UPDATE ozf_resale_batches
1208: SET status_code = l_status_code,
1209: lines_disputed = l_lines_disputed,
1210: lines_invalid = l_lines_invalid
1211: WHERE resale_batch_id = p_resale_batch_id;