DBA Data[Home] [Help]

APPS.OKL_AM_QUOTES_WF dependencies on OKL_QTE_PVT

Line 4543: p_qtev_rec OKL_QTE_PVT.qtev_rec_type;

4539:
4540: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4541: x_msg_count NUMBER;
4542: x_msg_data VARCHAR2(2000);
4543: p_qtev_rec OKL_QTE_PVT.qtev_rec_type;
4544: x_qtev_rec OKL_QTE_PVT.qtev_rec_type;
4545: p_api_version NUMBER := 1;
4546: p_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
4547:

Line 4544: x_qtev_rec OKL_QTE_PVT.qtev_rec_type;

4540: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4541: x_msg_count NUMBER;
4542: x_msg_data VARCHAR2(2000);
4543: p_qtev_rec OKL_QTE_PVT.qtev_rec_type;
4544: x_qtev_rec OKL_QTE_PVT.qtev_rec_type;
4545: p_api_version NUMBER := 1;
4546: p_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
4547:
4548: API_ERROR EXCEPTION;

Line 4588: okl_qte_pvt.update_row( p_api_version => p_api_version,

4584: p_qtev_rec.ID := to_number(l_id);
4585:
4586: p_qtev_rec.APPROVED_YN := nvl(l_approved, 'Y');
4587:
4588: okl_qte_pvt.update_row( p_api_version => p_api_version,
4589: p_init_msg_list => p_init_msg_list,
4590: x_return_status => x_return_status,
4591: x_msg_count => x_msg_count,
4592: x_msg_data => x_msg_data,

Line 4598: 'after call to okl_qte_pvt.update_row :'||x_return_status);

4594: x_qtev_rec => x_qtev_rec);
4595:
4596: IF (is_debug_statement_on) THEN
4597: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
4598: 'after call to okl_qte_pvt.update_row :'||x_return_status);
4599: END IF;
4600:
4601: IF x_return_status = OKC_API.G_RET_STS_SUCCESS THEN
4602: IF nvl(l_approved, 'Y') = 'Y' THEN

Line 4842: p_qtev_rec OKL_QTE_PVT.qtev_rec_type;

4838:
4839: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4840: x_msg_count NUMBER;
4841: x_msg_data VARCHAR2(2000);
4842: p_qtev_rec OKL_QTE_PVT.qtev_rec_type;
4843: x_qtev_rec OKL_QTE_PVT.qtev_rec_type;
4844: p_api_version NUMBER := 1;
4845: p_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
4846:

Line 4843: x_qtev_rec OKL_QTE_PVT.qtev_rec_type;

4839: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4840: x_msg_count NUMBER;
4841: x_msg_data VARCHAR2(2000);
4842: p_qtev_rec OKL_QTE_PVT.qtev_rec_type;
4843: x_qtev_rec OKL_QTE_PVT.qtev_rec_type;
4844: p_api_version NUMBER := 1;
4845: p_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
4846:
4847: API_ERROR EXCEPTION;

Line 4911: -- 20-Mar-06 rmunjulu 5087501 call okl_qte_pvt.update_row( ) to update the

4907: l_quote_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
4908: itemkey => itemkey,
4909: aname => 'TRANSACTION_ID');
4910:
4911: -- 20-Mar-06 rmunjulu 5087501 call okl_qte_pvt.update_row( ) to update the
4912: -- LAST_UPDATED_BY column of the quote with the current logged in user_id so before
4913: -- raising the business event so that workflow can pick up the correct requestor.
4914:
4915: p_qtev_rec.ID := to_number(l_quote_id);

Line 4916: okl_qte_pvt.update_row( p_api_version => p_api_version,

4912: -- LAST_UPDATED_BY column of the quote with the current logged in user_id so before
4913: -- raising the business event so that workflow can pick up the correct requestor.
4914:
4915: p_qtev_rec.ID := to_number(l_quote_id);
4916: okl_qte_pvt.update_row( p_api_version => p_api_version,
4917: p_init_msg_list => p_init_msg_list,
4918: x_return_status => x_return_status,
4919: x_msg_count => x_msg_count,
4920: x_msg_data => x_msg_data,

Line 4925: 'after call to okl_qte_pvt.update_row :'||x_return_status);

4921: p_qtev_rec => p_qtev_rec,
4922: x_qtev_rec => x_qtev_rec);
4923: IF (is_debug_statement_on) THEN
4924: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
4925: 'after call to okl_qte_pvt.update_row :'||x_return_status);
4926: END IF;
4927:
4928: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
4929: RAISE API_ERROR;

Line 4989: okl_qte_pvt.update_row( p_api_version => p_api_version,

4985: -- is processing for approval
4986:
4987: p_qtev_rec.ID := to_number(l_quote_id);
4988: p_qtev_rec.QST_CODE := 'SUBMITTED';
4989: okl_qte_pvt.update_row( p_api_version => p_api_version,
4990: p_init_msg_list => p_init_msg_list,
4991: x_return_status => x_return_status,
4992: x_msg_count => x_msg_count,
4993: x_msg_data => x_msg_data,

Line 4999: 'after call to okl_qte_pvt.update_row :'||x_return_status);

4995: x_qtev_rec => x_qtev_rec);
4996:
4997: IF (is_debug_statement_on) THEN
4998: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
4999: 'after call to okl_qte_pvt.update_row :'||x_return_status);
5000: END IF;
5001:
5002: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
5003: RAISE API_ERROR;

Line 7306: p_qtev_rec OKL_QTE_PVT.qtev_rec_type;

7302:
7303: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7304: x_msg_count NUMBER;
7305: x_msg_data VARCHAR2(2000);
7306: p_qtev_rec OKL_QTE_PVT.qtev_rec_type;
7307: x_qtev_rec OKL_QTE_PVT.qtev_rec_type;
7308: p_api_version NUMBER := 1;
7309: p_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
7310:

Line 7307: x_qtev_rec OKL_QTE_PVT.qtev_rec_type;

7303: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7304: x_msg_count NUMBER;
7305: x_msg_data VARCHAR2(2000);
7306: p_qtev_rec OKL_QTE_PVT.qtev_rec_type;
7307: x_qtev_rec OKL_QTE_PVT.qtev_rec_type;
7308: p_api_version NUMBER := 1;
7309: p_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
7310:
7311: API_ERROR EXCEPTION;

Line 7348: okl_qte_pvt.update_row( p_api_version => p_api_version,

7344: p_qtev_rec.ID := to_number(l_id);
7345:
7346: p_qtev_rec.APPROVED_YN := nvl(l_approved, 'Y');
7347:
7348: okl_qte_pvt.update_row( p_api_version => p_api_version,
7349: p_init_msg_list => p_init_msg_list,
7350: x_return_status => x_return_status,
7351: x_msg_count => x_msg_count,
7352: x_msg_data => x_msg_data,

Line 7358: 'after call to okl_qte_pvt.update_row :'||x_return_status);

7354: x_qtev_rec => x_qtev_rec);
7355:
7356: IF (is_debug_statement_on) THEN
7357: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
7358: 'after call to okl_qte_pvt.update_row :'||x_return_status);
7359: END IF;
7360:
7361: IF x_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7362: IF nvl(l_approved, 'Y') = 'Y' THEN