DBA Data[Home] [Help]

APPS.IEX_CO_WF dependencies on IEX_OPI_PVT

Line 39: p_action => IEX_OPI_PVT.ACTION_NOTIFY_CUST,

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,

Line 40: p_status => IEX_OPI_PVT.STATUS_PENDING_AUTO,

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,

Line 119: p_action => IEX_OPI_PVT.ACTION_REPORT_CB,

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,

Line 120: p_status => IEX_OPI_PVT.STATUS_PENDING_AUTO,

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,

Line 199: p_action => IEX_OPI_PVT.ACTION_TRANSFER_EXT_AGNCY,

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,

Line 200: p_status => IEX_OPI_PVT.STATUS_PENDING_AUTO,

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,

Line 282: AND (IOH.ACTION = IEX_OPI_PVT.ACTION_TRANSFER_EXT_AGNCY)

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;

Line 283: AND (IOH.STATUS = IEX_OPI_PVT.STATUS_PROCESSED);

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;

Line 386: AND (IOH.ACTION = IEX_OPI_PVT.ACTION_TRANSFER_EXT_AGNCY)

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;

Line 387: AND (IOH.STATUS = IEX_OPI_PVT.STATUS_NOTIFIED OR IOH.STATUS = IEX_OPI_PVT.STATUS_PROCESSED);

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;