DBA Data[Home] [Help]

APPS.OKL_AM_UTIL_PVT dependencies on JTF_AMV_ITEMS_VL

Line 1966: l_content_id jtf_amv_items_vl.item_id%type;

1962: AND opt.start_date < sysdate
1963: AND nvl(opt.end_date, sysdate+1) > sysdate;
1964:
1965: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1966: l_content_id jtf_amv_items_vl.item_id%type;
1967: l_default_subject okl_process_tmplts_v.email_subject_line%type;
1968:
1969: BEGIN
1970:

Line 2184: l_content_id jtf_amv_items_vl.item_id%type;

2180: x_msg_count OUT NOCOPY NUMBER,
2181: x_msg_data OUT NOCOPY VARCHAR2 ) IS
2182:
2183: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2184: l_content_id jtf_amv_items_vl.item_id%type;
2185: l_default_subject okl_process_tmplts_v.email_subject_line%type;
2186:
2187: l_email_tbl recipient_tbl;
2188: l_party_object_tbl okl_am_parties_pvt.party_object_tbl_type;