APPS.OZF_SPECIAL_PRICING_PVT dependencies on OZF_RESALE_BATCHES

Line 71: FROM ozf_resale_batches

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

Line 453: UPDATE ozf_resale_batches

449: response_code = 'N'
450: WHERE resale_line_int_id = l_line_int_rec.resale_line_int_id;
451:
452: -- SET Batch as disputed
453: UPDATE ozf_resale_batches
454: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
455: WHERE resale_batch_id = l_line_int_rec.resale_batch_id;
456:
457: goto END_LOOP2;

Line 650: UPDATE ozf_resale_batches

646: WHERE resale_batch_id = p_resale_batch_id
647: AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED) ;
648:
649: -- UPDATE batch status to CLOSEd -- might change later.
650: UPDATE ozf_resale_batches
651: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED,
652: paid_amount = l_amount_claimed
653: WHERE resale_batch_id = p_resale_batch_id;
654: EXCEPTION

Line 1086: from ozf_resale_batches

1082: l_line_tolerance_operand number;
1083:
1084: CURSOR line_tolerance_csr(p_id in number) is
1085: select LINE_TOLERANCE_OPERAND, LINE_TOLERANCE_CALC_CODE
1086: from ozf_resale_batches
1087: where resale_batch_id = p_id;
1088:
1089: l_need_tolerance boolean;
1090: l_allowed_or_claimed varchar2(30);

Line 1895: FROM ozf_resale_batches

1891: CURSOR partner_id_csr (p_resale_batch_id NUMBER)IS
1892: SELECT partner_id
1893: , report_start_date
1894: , report_end_date
1895: FROM ozf_resale_batches
1896: where resale_batch_id = p_resale_batch_id;
1897: l_partner_id NUMBER;
1898:
1899: CURSOR order_num_csr IS