35: p_init_msg_list => l_init_msg_list,
36: p_object1_id1 => cur.object_id,
37: p_object1_id2 => '#',
38: p_jtot_object1_code => 'OKX_LEASE',
39: p_action => IEX_OPI_PVT.ACTION_NOTIFY_CUST,
40: p_status => IEX_OPI_PVT.STATUS_PENDING_AUTO,
41: p_comments => OKC_API.G_MISS_CHAR,
42: p_ext_agncy_id => NULL,
43: p_review_date => NULL,
36: p_object1_id1 => cur.object_id,
37: p_object1_id2 => '#',
38: p_jtot_object1_code => 'OKX_LEASE',
39: p_action => IEX_OPI_PVT.ACTION_NOTIFY_CUST,
40: p_status => IEX_OPI_PVT.STATUS_PENDING_AUTO,
41: p_comments => OKC_API.G_MISS_CHAR,
42: p_ext_agncy_id => NULL,
43: p_review_date => NULL,
44: p_recall_date => NULL,
115: p_init_msg_list => l_init_msg_list,
116: p_object1_id1 => cur.object_id,
117: p_object1_id2 => '#',
118: p_jtot_object1_code => 'OKX_LEASE',
119: p_action => IEX_OPI_PVT.ACTION_REPORT_CB,
120: p_status => IEX_OPI_PVT.STATUS_PENDING_AUTO,
121: p_comments => OKC_API.G_MISS_CHAR,
122: p_ext_agncy_id => NULL,
123: p_review_date => NULL,
116: p_object1_id1 => cur.object_id,
117: p_object1_id2 => '#',
118: p_jtot_object1_code => 'OKX_LEASE',
119: p_action => IEX_OPI_PVT.ACTION_REPORT_CB,
120: p_status => IEX_OPI_PVT.STATUS_PENDING_AUTO,
121: p_comments => OKC_API.G_MISS_CHAR,
122: p_ext_agncy_id => NULL,
123: p_review_date => NULL,
124: p_recall_date => NULL,
195: p_init_msg_list => l_init_msg_list,
196: p_object1_id1 => cur.object_id,
197: p_object1_id2 => '#',
198: p_jtot_object1_code => 'OKX_LEASE',
199: p_action => IEX_OPI_PVT.ACTION_TRANSFER_EXT_AGNCY,
200: p_status => IEX_OPI_PVT.STATUS_PENDING_AUTO,
201: p_comments => OKC_API.G_MISS_CHAR,
202: p_ext_agncy_id => NULL,
203: p_review_date => NULL,
196: p_object1_id1 => cur.object_id,
197: p_object1_id2 => '#',
198: p_jtot_object1_code => 'OKX_LEASE',
199: p_action => IEX_OPI_PVT.ACTION_TRANSFER_EXT_AGNCY,
200: p_status => IEX_OPI_PVT.STATUS_PENDING_AUTO,
201: p_comments => OKC_API.G_MISS_CHAR,
202: p_ext_agncy_id => NULL,
203: p_review_date => NULL,
204: p_recall_date => NULL,
278: AND ida.case_id = ico.cas_id
279: AND ico.object_id = oin.khr_id
280: AND OIN.khr_id = TO_NUMBER(IOH.object1_id1)
281: AND IOH.jtot_object1_code = 'OKX_LEASE'
282: AND (IOH.ACTION = IEX_OPI_PVT.ACTION_TRANSFER_EXT_AGNCY)
283: AND (IOH.STATUS = IEX_OPI_PVT.STATUS_PROCESSED);
284:
285: l_oinv_rec iex_open_interface_pub.oinv_rec_type;
286: lx_oinv_rec iex_open_interface_pub.oinv_rec_type;
279: AND ico.object_id = oin.khr_id
280: AND OIN.khr_id = TO_NUMBER(IOH.object1_id1)
281: AND IOH.jtot_object1_code = 'OKX_LEASE'
282: AND (IOH.ACTION = IEX_OPI_PVT.ACTION_TRANSFER_EXT_AGNCY)
283: AND (IOH.STATUS = IEX_OPI_PVT.STATUS_PROCESSED);
284:
285: l_oinv_rec iex_open_interface_pub.oinv_rec_type;
286: lx_oinv_rec iex_open_interface_pub.oinv_rec_type;
287: l_iohv_rec iex_open_interface_pub.iohv_rec_type;
382: AND ida.case_id = ico.cas_id
383: AND ico.object_id = oin.khr_id
384: AND OIN.khr_id = TO_NUMBER(IOH.object1_id1)
385: AND IOH.jtot_object1_code = 'OKX_LEASE'
386: AND (IOH.ACTION = IEX_OPI_PVT.ACTION_TRANSFER_EXT_AGNCY)
387: AND (IOH.STATUS = IEX_OPI_PVT.STATUS_NOTIFIED OR IOH.STATUS = IEX_OPI_PVT.STATUS_PROCESSED);
388:
389: l_oinv_rec iex_open_interface_pub.oinv_rec_type;
390: lx_oinv_rec iex_open_interface_pub.oinv_rec_type;
383: AND ico.object_id = oin.khr_id
384: AND OIN.khr_id = TO_NUMBER(IOH.object1_id1)
385: AND IOH.jtot_object1_code = 'OKX_LEASE'
386: AND (IOH.ACTION = IEX_OPI_PVT.ACTION_TRANSFER_EXT_AGNCY)
387: AND (IOH.STATUS = IEX_OPI_PVT.STATUS_NOTIFIED OR IOH.STATUS = IEX_OPI_PVT.STATUS_PROCESSED);
388:
389: l_oinv_rec iex_open_interface_pub.oinv_rec_type;
390: lx_oinv_rec iex_open_interface_pub.oinv_rec_type;
391: l_iohv_rec iex_open_interface_pub.iohv_rec_type;