APPS.OKL_IPT_PVT dependencies on OKX_SYSTEM_ITEMS_V

Line 151: , OKX_SYSTEM_ITEMS_V OSI

147: --Fixed Bug #6436237 ssdeshpa MOAC Issues Changing Cursor start
148: CURSOR l_iptv_lease_csr IS
149: SELECT 'x'
150: FROM OKL_INS_PRODUCTS_B IPTB
151: , OKX_SYSTEM_ITEMS_V OSI
152: , OKL_SYSTEM_PARAMS SYSOP
153: WHERE ( p_iptv_rec.factor_min BETWEEN IPTB.factor_min and IPTB.factor_max
154: or p_iptv_rec.factor_max BETWEEN IPTB.factor_min and IPTB.factor_max
155: )

Line 202: FROM okx_system_items_v

198: l_status VARCHAR2(1);
199:
200: CURSOR l_sit_csr IS
201: SELECT Status,START_DATE_ACTIVE,end_date_active
202: FROM okx_system_items_v
203: WHERE ID1 = p_iptv_rec.ipd_id;
204:
205:
206: CURSOR l_sit_csr2 IS

Line 208: FROM okx_system_items_v

204:
205:
206: CURSOR l_sit_csr2 IS
207: SELECT 'X'
208: FROM okx_system_items_v
209: WHERE ID1 = p_iptv_rec.ipd_id
210: and NVL(Status,'I') = 'A';
211:
212: BEGIN

Line 683: -- WARNING : Cannot implement until OKX View OKX_SYSTEM_ITEMS_V defined

679: -- End of Comments
680: ---------------------------------------------------------------------------
681: procedure validate_ipt_ipd_id(x_return_status OUT NOCOPY VARCHAR2,p_iptv_rec IN iptv_rec_type ) IS
682: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
683: -- WARNING : Cannot implement until OKX View OKX_SYSTEM_ITEMS_V defined
684: l_dummy_var VARCHAR2(1) := '?';
685: -- select the ID of the parent record from the parent table
686: CURSOR l_iptv_csr IS
687: SELECT 'x'

Line 688: FROM okx_system_items_v

684: l_dummy_var VARCHAR2(1) := '?';
685: -- select the ID of the parent record from the parent table
686: CURSOR l_iptv_csr IS
687: SELECT 'x'
688: FROM okx_system_items_v
689: WHERE id1 = p_iptv_rec.ipd_id;
690: begin
691: --data is required
692: IF p_iptv_rec.ipd_id = OKC_API.G_MISS_NUM OR p_iptv_rec.ipd_id IS NULL

Line 702: -- WARNING : Cannot implement until OKX View OKX_SYSTEM_ITEMS_V defined

698: -- Notify caller of an error
699: l_return_status := Okc_Api.G_RET_STS_ERROR;
700: END IF;
701: x_return_status := l_return_status;
702: -- WARNING : Cannot implement until OKX View OKX_SYSTEM_ITEMS_V defined
703: -- enforce foreign key
704: OPEN l_iptv_csr;
705: FETCH l_iptv_csr into l_dummy_var;
706: CLOSE l_iptv_csr;

Line 716: p_token3_value => 'OKX_SYSTEM_ITEMS_V');

712: p_token1_value => 'ipd_id',
713: p_token2 => g_child_table_token,
714: p_token2_value => 'OKL_INS_PRODUCTS_V',
715: p_token3 => g_parent_table_token,
716: p_token3_value => 'OKX_SYSTEM_ITEMS_V');
717: -- notify caller of an error
718: x_return_status := OKC_API.G_RET_STS_ERROR;
719: END IF;
720: EXCEPTION