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 4844: p_qtev_rec OKL_QTE_PVT.qtev_rec_type;

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

Line 4845: x_qtev_rec OKL_QTE_PVT.qtev_rec_type;

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

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

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

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

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

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

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

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

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

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

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

Line 7308: p_qtev_rec OKL_QTE_PVT.qtev_rec_type;

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

Line 7309: x_qtev_rec OKL_QTE_PVT.qtev_rec_type;

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

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

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

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

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