DBA Data[Home] [Help]

APPS.OKC_CRQUOTE_ASMBLR_PVT dependencies on OKC_AQ_PVT

Line 50: l_rec okc_aq_pvt.corrid_rec_typ;

46: l_contract_number varchar2(120);
47: l_contract_number_modifier varchar2(120);
48: l_quote_number varchar2(120) := to_char(p_quote_number);
49: --
50: l_rec okc_aq_pvt.corrid_rec_typ;
51: l_tbl okc_aq_pvt.msg_tab_typ;
52: i NUMBER := 1;
53: --
54: BEGIN

Line 51: l_tbl okc_aq_pvt.msg_tab_typ;

47: l_contract_number_modifier varchar2(120);
48: l_quote_number varchar2(120) := to_char(p_quote_number);
49: --
50: l_rec okc_aq_pvt.corrid_rec_typ;
51: l_tbl okc_aq_pvt.msg_tab_typ;
52: i NUMBER := 1;
53: --
54: BEGIN
55: -- call start_activity to create savepoint, check comptability

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

68:
69: l_rec.corrid := 'KCRQUOTE';
70: -- check if action is enabled
71: IF OKC_K_SIGN_ASMBLR_PVT.isActionEnabled(l_rec.corrid) = 'Y' THEN
72: l_tbl := okc_aq_pvt.msg_tab_typ();
73:
74: FOR acn_rec IN acn_cur LOOP
75: OPEN k_cur;
76: FETCH k_cur INTO k_rec;

Line 110: okc_aq_pvt.send_message(p_api_version => l_api_version

106: i := i+1;
107: CLOSE k_cur;
108: END LOOP;
109:
110: okc_aq_pvt.send_message(p_api_version => l_api_version
111: ,x_msg_count => x_msg_count
112: ,x_msg_data => x_msg_data
113: ,x_return_status => x_return_status
114: ,p_corrid_rec => l_rec

Line 116: ,p_queue_name => okc_aq_pvt.g_event_queue_name

112: ,x_msg_data => x_msg_data
113: ,x_return_status => x_return_status
114: ,p_corrid_rec => l_rec
115: ,p_msg_tab => l_tbl
116: ,p_queue_name => okc_aq_pvt.g_event_queue_name
117: );
118: -- check if activity started successfully
119: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
120: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;