DBA Data[Home] [Help]

APPS.OKL_AM_UTIL_PVT dependencies on OKL_PROCESS_TMPLTS_V

Line 1967: l_default_subject okl_process_tmplts_v.email_subject_line%type;

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:
1971: OPEN c_content_csr(p_ptm_code);

Line 2185: l_default_subject okl_process_tmplts_v.email_subject_line%type;

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;
2189: i NUMBER := 0;