APPS.OZF_SPECIAL_PRICING_PVT dependencies on OZF_RESALE_BATCHES

Line 73: FROM ozf_resale_batches

69: report_start_date,
70: report_end_date,
71: batch_number,
72: last_updated_by
73: FROM ozf_resale_batches
74: WHERE resale_batch_id = p_id;
75: l_batch_status VARCHAR2(30);
76: l_batch_type VARCHAR2(30);
77: l_partner_cust_account_id NUMBER;

Line 478: UPDATE ozf_resale_batches

474: response_code = 'N'
475: WHERE resale_line_int_id = l_line_int_rec.resale_line_int_id;
476:
477: -- SET Batch as disputed
478: UPDATE ozf_resale_batches
479: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
480: WHERE resale_batch_id = l_line_int_rec.resale_batch_id;
481:
482: goto END_LOOP2;

Line 684: UPDATE ozf_resale_batches

680: WHERE resale_batch_id = p_resale_batch_id
681: AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED) ;
682:
683: -- UPDATE batch status to CLOSEd -- might change later.
684: UPDATE ozf_resale_batches
685: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED,
686: paid_amount = l_amount_claimed
687: WHERE resale_batch_id = p_resale_batch_id;
688: EXCEPTION

Line 705: UPDATE ozf_resale_batches

701: AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED) ;
702:
703:
704: -- UPDATE batch status to CLOSED
705: UPDATE ozf_resale_batches
706: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED
707: WHERE resale_batch_id = p_resale_batch_id;
708: EXCEPTION
709: WHEN OTHERS THEN

Line 1162: from ozf_resale_batches

1158: l_line_tolerance_operand number;
1159:
1160: CURSOR line_tolerance_csr(p_id in number) is
1161: select LINE_TOLERANCE_OPERAND, LINE_TOLERANCE_CALC_CODE
1162: from ozf_resale_batches
1163: where resale_batch_id = p_id;
1164:
1165: l_need_tolerance boolean;
1166: l_allowed_or_claimed varchar2(30);

Line 1999: FROM ozf_resale_batches

1995: CURSOR partner_id_csr (p_resale_batch_id NUMBER)IS
1996: SELECT partner_id
1997: , report_start_date
1998: , report_end_date
1999: FROM ozf_resale_batches
2000: where resale_batch_id = p_resale_batch_id;
2001: l_partner_id NUMBER;
2002:
2003: CURSOR order_num_csr IS