DBA Data[Home] [Help]

APPS.OKC_K_SIGN_ASMBLR_PVT dependencies on OKC_AQ_PVT

Line 82: l_rec okc_aq_pvt.corrid_rec_typ;

78: l_contract_number varchar2(120);
79: l_contract_number_modifier varchar2(120);
80: l_date_signed varchar2(22);
81: --
82: l_rec okc_aq_pvt.corrid_rec_typ;
83: l_tbl okc_aq_pvt.msg_tab_typ;
84: i NUMBER := 1;
85: --
86: BEGIN

Line 83: l_tbl okc_aq_pvt.msg_tab_typ;

79: l_contract_number_modifier varchar2(120);
80: l_date_signed varchar2(22);
81: --
82: l_rec okc_aq_pvt.corrid_rec_typ;
83: l_tbl okc_aq_pvt.msg_tab_typ;
84: i NUMBER := 1;
85: --
86: BEGIN
87: -- call start_activity to create savepoint, check comptability

Line 104: l_tbl := okc_aq_pvt.msg_tab_typ();

100:
101: l_rec.corrid := 'KSIGN';
102: -- check if action is enabled
103: IF isActionEnabled(l_rec.corrid) = 'Y' THEN
104: l_tbl := okc_aq_pvt.msg_tab_typ();
105:
106: FOR acn_rec IN acn_cur LOOP
107: OPEN k_cur;
108: FETCH k_cur INTO k_rec;

Line 150: OKC_aq_pvt.send_message(p_api_version => l_api_version

146: END IF;
147: i := i+1;
148: CLOSE k_cur;
149: END LOOP;
150: OKC_aq_pvt.send_message(p_api_version => l_api_version
151: ,x_msg_count => x_msg_count
152: ,x_msg_data => x_msg_data
153: ,x_return_status => x_return_status
154: ,p_corrid_rec => l_rec

Line 156: ,p_queue_name => okc_aq_pvt.g_event_queue_name

152: ,x_msg_data => x_msg_data
153: ,x_return_status => x_return_status
154: ,p_corrid_rec => l_rec
155: ,p_msg_tab => l_tbl
156: ,p_queue_name => okc_aq_pvt.g_event_queue_name
157: );
158: -- check if activity started successfully
159: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
160: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;