[Home] [Help]
73: FROM ozf_resale_lines_int
74: WHERE resale_line_int_id = p_id;
75:
76: CURSOR g_header_id_csr IS
77: SELECT ozf_resale_headers_all_s.nextval
78: FROM dual;
79:
80: CURSOR g_line_id_csr IS
81: SELECT ozf_resale_lines_all_s.nextval
152: WHERE resale_batch_id = cv_batch_id;
153:
154: CURSOR g_resale_header_org_id_csr(cv_header_id NUMBER) IS
155: SELECT org_id
156: FROM ozf_resale_headers_all
157: WHERE resale_header_id = cv_header_id;
158: -- End: bug # 5997978 fixed
159:
160:
599: ,p_validation_level IN NUMBER
600: ,p_caller_type IN VARCHAR2
601: ,p_line_index IN NUMBER
602: ,p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%ROWTYPE
603: ,p_resale_header_rec IN OZF_RESALE_HEADERS%ROWTYPE
604: ,p_resale_line_rec IN OZF_RESALE_LINES%ROWTYPE
605: ,x_return_status OUT NOCOPY VARCHAR2
606: ,x_msg_count OUT NOCOPY NUMBER
607: ,x_msg_data OUT NOCOPY VARCHAR2