DBA Data[Home] [Help]

APPS.OKL_CO_WF dependencies on IEX_OPI_PVT

Line 550: p_action => IEX_OPI_PVT.ACTION_NOTIFY_CUST,

546: p_init_msg_list => l_init_msg_list,
547: p_object1_id1 => cur.object_id,
548: p_object1_id2 => '#',
549: p_jtot_object1_code => 'OKX_LEASE',
550: p_action => IEX_OPI_PVT.ACTION_NOTIFY_CUST,
551: p_status => IEX_OPI_PVT.STATUS_PENDING_AUTO,
552: p_comments => OKC_API.G_MISS_CHAR,
553: p_ext_agncy_id => NULL,
554: p_review_date => NULL,

Line 551: p_status => IEX_OPI_PVT.STATUS_PENDING_AUTO,

547: p_object1_id1 => cur.object_id,
548: p_object1_id2 => '#',
549: p_jtot_object1_code => 'OKX_LEASE',
550: p_action => IEX_OPI_PVT.ACTION_NOTIFY_CUST,
551: p_status => IEX_OPI_PVT.STATUS_PENDING_AUTO,
552: p_comments => OKC_API.G_MISS_CHAR,
553: p_ext_agncy_id => NULL,
554: p_review_date => NULL,
555: p_recall_date => NULL,

Line 664: p_action => IEX_OPI_PVT.ACTION_REPORT_CB,

660: p_init_msg_list => l_init_msg_list,
661: p_object1_id1 => cur.object_id,
662: p_object1_id2 => '#',
663: p_jtot_object1_code => 'OKX_LEASE',
664: p_action => IEX_OPI_PVT.ACTION_REPORT_CB,
665: p_status => IEX_OPI_PVT.STATUS_PENDING_AUTO,
666: p_comments => OKC_API.G_MISS_CHAR,
667: p_ext_agncy_id => NULL,
668: p_review_date => NULL,

Line 665: p_status => IEX_OPI_PVT.STATUS_PENDING_AUTO,

661: p_object1_id1 => cur.object_id,
662: p_object1_id2 => '#',
663: p_jtot_object1_code => 'OKX_LEASE',
664: p_action => IEX_OPI_PVT.ACTION_REPORT_CB,
665: p_status => IEX_OPI_PVT.STATUS_PENDING_AUTO,
666: p_comments => OKC_API.G_MISS_CHAR,
667: p_ext_agncy_id => NULL,
668: p_review_date => NULL,
669: p_recall_date => NULL,

Line 857: p_action => IEX_OPI_PVT.ACTION_TRANSFER_EXT_AGNCY,

853: p_init_msg_list => l_init_msg_list,
854: p_object1_id1 => cur.object_id,
855: p_object1_id2 => '#',
856: p_jtot_object1_code => 'OKX_LEASE',
857: p_action => IEX_OPI_PVT.ACTION_TRANSFER_EXT_AGNCY,
858: p_status => IEX_OPI_PVT.STATUS_PENDING_AUTO,
859: p_comments => OKC_API.G_MISS_CHAR,
860: p_ext_agncy_id => NULL,
861: p_review_date => NULL,

Line 858: p_status => IEX_OPI_PVT.STATUS_PENDING_AUTO,

854: p_object1_id1 => cur.object_id,
855: p_object1_id2 => '#',
856: p_jtot_object1_code => 'OKX_LEASE',
857: p_action => IEX_OPI_PVT.ACTION_TRANSFER_EXT_AGNCY,
858: p_status => IEX_OPI_PVT.STATUS_PENDING_AUTO,
859: p_comments => OKC_API.G_MISS_CHAR,
860: p_ext_agncy_id => NULL,
861: p_review_date => NULL,
862: p_recall_date => NULL,

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

936: AND ida.case_id = ico.cas_id
937: AND ico.object_id = oin.khr_id
938: AND OIN.khr_id = TO_NUMBER(IOH.object1_id1)
939: AND IOH.jtot_object1_code = 'OKX_LEASE'
940: AND (IOH.ACTION = IEX_OPI_PVT.ACTION_TRANSFER_EXT_AGNCY)
941: AND (IOH.STATUS = IEX_OPI_PVT.STATUS_PROCESSED);
942:
943: l_oinv_rec iex_open_interface_pub.oinv_rec_type;
944: lx_oinv_rec iex_open_interface_pub.oinv_rec_type;

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

937: AND ico.object_id = oin.khr_id
938: AND OIN.khr_id = TO_NUMBER(IOH.object1_id1)
939: AND IOH.jtot_object1_code = 'OKX_LEASE'
940: AND (IOH.ACTION = IEX_OPI_PVT.ACTION_TRANSFER_EXT_AGNCY)
941: AND (IOH.STATUS = IEX_OPI_PVT.STATUS_PROCESSED);
942:
943: l_oinv_rec iex_open_interface_pub.oinv_rec_type;
944: lx_oinv_rec iex_open_interface_pub.oinv_rec_type;
945: l_iohv_rec iex_open_interface_pub.iohv_rec_type;

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

1040: AND ida.case_id = ico.cas_id
1041: AND ico.object_id = oin.khr_id
1042: AND OIN.khr_id = TO_NUMBER(IOH.object1_id1)
1043: AND IOH.jtot_object1_code = 'OKX_LEASE'
1044: AND (IOH.ACTION = IEX_OPI_PVT.ACTION_TRANSFER_EXT_AGNCY)
1045: AND (IOH.STATUS = IEX_OPI_PVT.STATUS_NOTIFIED OR IOH.STATUS = IEX_OPI_PVT.STATUS_PROCESSED);
1046:
1047: l_oinv_rec iex_open_interface_pub.oinv_rec_type;
1048: lx_oinv_rec iex_open_interface_pub.oinv_rec_type;

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

1041: AND ico.object_id = oin.khr_id
1042: AND OIN.khr_id = TO_NUMBER(IOH.object1_id1)
1043: AND IOH.jtot_object1_code = 'OKX_LEASE'
1044: AND (IOH.ACTION = IEX_OPI_PVT.ACTION_TRANSFER_EXT_AGNCY)
1045: AND (IOH.STATUS = IEX_OPI_PVT.STATUS_NOTIFIED OR IOH.STATUS = IEX_OPI_PVT.STATUS_PROCESSED);
1046:
1047: l_oinv_rec iex_open_interface_pub.oinv_rec_type;
1048: lx_oinv_rec iex_open_interface_pub.oinv_rec_type;
1049: l_iohv_rec iex_open_interface_pub.iohv_rec_type;