APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_LINES

Line 47: FROM ozf_resale_lines

43: WHERE resale_batch_id = p_id;
44:
45: CURSOR gc_line_org_id(p_id NUMBER) IS
46: SELECT org_id
47: FROM ozf_resale_lines
48: WHERE resale_line_id = p_id;
49:
50: CURSOR gc_iface_org_id(p_id NUMBER) IS
51: SELECT org_id

Line 52: FROM ozf_resale_lines_int

48: WHERE resale_line_id = p_id;
49:
50: CURSOR gc_iface_org_id(p_id NUMBER) IS
51: SELECT org_id
52: FROM ozf_resale_lines_int
53: WHERE resale_line_int_id = p_id;
54:
55: -- Added by vanitha
56: TYPE party_rec_type IS RECORD

Line 73: FROM ozf_resale_lines_int

69: );
70: --
71: CURSOR g_interface_rec_csr(p_id in NUMBER) IS
72: SELECT *
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

Line 81: SELECT ozf_resale_lines_all_s.nextval

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
82: FROM dual;
83:
84: CURSOR g_map_id_csr IS
85: SELECT ozf_resale_batch_line_map_s.nextval

Line 131: FROM ozf_resale_lines_int

127: --, NVL(sum(total_claimed_amount - total_allowed_amount), 0) -- disputed amount
128: , NVL(sum(NVL(total_claimed_amount, 0) - NVL(total_allowed_amount, 0)), 0) -- disputed amount
129: -- BUG 4731894 (-)
130: -- [END OF BUG 4376520 FIXING]
131: FROM ozf_resale_lines_int
132: WHERE resale_batch_id = p_id
133: -- [BEGIN OF BUG 4376520 FIXING]
134: AND NVL(tracing_flag, 'F') <> 'T'
135: -- [END OF BUG 4376520 FIXING]

Line 140: FROM ozf_resale_lines_int

136: AND status_code <> 'DUPLICATED'; -- BUG 4930718
137:
138: CURSOR g_disputed_line_count_csr (p_id NUMBER)IS
139: SELECT count(1)
140: FROM ozf_resale_lines_int
141: WHERE status_code = G_BATCH_ADJ_DISPUTED
142: AND resale_batch_id = p_id;
143:
144: CURSOR g_exchange_rate_type_csr IS

Line 590: -- p_resale_line_rec IN OZF_RESALE_LINES%ROWTYPE

586: --
587: -- PARAMETERS
588: -- p_caller_type IN VARCHAR2
589: -- p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%ROWTYPE
590: -- p_resale_line_rec IN OZF_RESALE_LINES%ROWTYPE
591: --
592: -- NOTES
593: --
594: ---------------------------------------------------------------------

Line 604: ,p_resale_line_rec IN OZF_RESALE_LINES%ROWTYPE

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
608: );