DBA Data[Home] [Help]

APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_HEADERS

Line 102: SELECT ozf_resale_headers_all_s.nextval

98: FROM ozf_resale_lines_int
99: WHERE resale_line_int_id = p_id;
100:
101: CURSOR g_header_id_csr IS
102: SELECT ozf_resale_headers_all_s.nextval
103: FROM dual;
104:
105: CURSOR g_line_id_csr IS
106: SELECT ozf_resale_lines_all_s.nextval

Line 181: FROM ozf_resale_headers_all

177: WHERE resale_batch_id = cv_batch_id;
178:
179: CURSOR g_resale_header_org_id_csr(cv_header_id NUMBER) IS
180: SELECT org_id
181: FROM ozf_resale_headers_all
182: WHERE resale_header_id = cv_header_id;
183: -- End: bug # 5997978 fixed
184:
185: --Bug# 8414563 fixed by ateotia(+)

Line 728: ,p_resale_header_rec IN OZF_RESALE_HEADERS%ROWTYPE

724: ,p_validation_level IN NUMBER
725: ,p_caller_type IN VARCHAR2
726: ,p_line_index IN NUMBER
727: ,p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%ROWTYPE
728: ,p_resale_header_rec IN OZF_RESALE_HEADERS%ROWTYPE
729: ,p_resale_line_rec IN OZF_RESALE_LINES%ROWTYPE
730: ,x_return_status OUT NOCOPY VARCHAR2
731: ,x_msg_count OUT NOCOPY NUMBER
732: ,x_msg_data OUT NOCOPY VARCHAR2