APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_LINES

Line 72: FROM ozf_resale_lines

68: WHERE resale_batch_id = p_id;
69:
70: CURSOR gc_line_org_id(p_id NUMBER) IS
71: SELECT org_id
72: FROM ozf_resale_lines
73: WHERE resale_line_id = p_id;
74:
75: CURSOR gc_iface_org_id(p_id NUMBER) IS
76: SELECT org_id

Line 77: FROM ozf_resale_lines_int

73: WHERE resale_line_id = p_id;
74:
75: CURSOR gc_iface_org_id(p_id NUMBER) IS
76: SELECT org_id
77: FROM ozf_resale_lines_int
78: WHERE resale_line_int_id = p_id;
79:
80: -- Added by vanitha
81: TYPE party_rec_type IS RECORD

Line 98: FROM ozf_resale_lines_int

94: );
95: --
96: CURSOR g_interface_rec_csr(p_id in NUMBER) IS
97: SELECT *
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

Line 106: SELECT ozf_resale_lines_all_s.nextval

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
107: FROM dual;
108:
109: CURSOR g_map_id_csr IS
110: SELECT ozf_resale_batch_line_map_s.nextval

Line 156: FROM ozf_resale_lines_int

152: --, NVL(sum(total_claimed_amount - total_allowed_amount), 0) -- disputed amount
153: , NVL(sum(NVL(total_claimed_amount, 0) - NVL(total_allowed_amount, 0)), 0) -- disputed amount
154: -- BUG 4731894 (-)
155: -- [END OF BUG 4376520 FIXING]
156: FROM ozf_resale_lines_int
157: WHERE resale_batch_id = p_id
158: -- [BEGIN OF BUG 4376520 FIXING]
159: AND NVL(tracing_flag, 'F') <> 'T'
160: -- [END OF BUG 4376520 FIXING]

Line 165: FROM ozf_resale_lines_int

161: AND status_code <> 'DUPLICATED'; -- BUG 4930718
162:
163: CURSOR g_disputed_line_count_csr (p_id NUMBER)IS
164: SELECT count(1)
165: FROM ozf_resale_lines_int
166: WHERE status_code = G_BATCH_ADJ_DISPUTED
167: AND resale_batch_id = p_id;
168:
169: CURSOR g_exchange_rate_type_csr IS

Line 188: FROM ozf_resale_lines_int_all

184:
185: --Bug# 8414563 fixed by ateotia(+)
186: CURSOR g_duplicated_line_count_csr (p_resale_batch_id IN NUMBER) IS
187: SELECT count(1)
188: FROM ozf_resale_lines_int_all
189: WHERE status_code = G_BATCH_ADJ_DUPLICATED
190: AND resale_batch_id = p_resale_batch_id;
191:
192: CURSOR g_tracing_flag_csr (p_resale_line_int_id IN NUMBER) IS

Line 194: FROM ozf_resale_lines_int_all

190: AND resale_batch_id = p_resale_batch_id;
191:
192: CURSOR g_tracing_flag_csr (p_resale_line_int_id IN NUMBER) IS
193: SELECT tracing_flag
194: FROM ozf_resale_lines_int_all
195: WHERE resale_line_int_id = p_resale_line_int_id;
196: --Bug# 8414563 fixed by ateotia(-)
197:
198: ---------------------------------------------------------------------

Line 715: -- p_resale_line_rec IN OZF_RESALE_LINES%ROWTYPE

711: --
712: -- PARAMETERS
713: -- p_caller_type IN VARCHAR2
714: -- p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%ROWTYPE
715: -- p_resale_line_rec IN OZF_RESALE_LINES%ROWTYPE
716: --
717: -- NOTES
718: --
719: ---------------------------------------------------------------------

Line 729: ,p_resale_line_rec IN OZF_RESALE_LINES%ROWTYPE

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