DBA Data[Home] [Help]

APPS.OKL_AM_QUOTES_WF dependencies on OKL_RULE_PUB

Line 2025: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;

2021: funcmode IN VARCHAR2,
2022: resultout OUT NOCOPY VARCHAR2) IS
2023:
2024:
2025: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
2026: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2027: l_rule_found VARCHAR2(1) := 'N';
2028: l_contract_id NUMBER;
2029: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

Line 2557: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;

2553: actid IN NUMBER,
2554: funcmode IN VARCHAR2,
2555: resultout OUT NOCOPY VARCHAR2) IS
2556:
2557: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
2558: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2559: l_rule_found VARCHAR2(1) := 'N';
2560: l_contract_id NUMBER;
2561: -- for debug logging

Line 2799: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;

2795: AND OLSV.lty_code = 'FREE_FORM1'
2796: ORDER BY OKLV.id ASC;
2797:
2798:
2799: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
2800: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2801: l_rule_found VARCHAR2(1) := 'N';
2802: l_contract_id NUMBER;
2803: l_current_rec_id NUMBER;

Line 5330: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;

5326: FROM OKL_TRX_QUOTES_B
5327: WHERE id = c_id;
5328:
5329: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5330: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
5331:
5332: API_ERROR EXCEPTION;
5333: -- for debug logging
5334: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'check_if_partial_quote';

Line 5466: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;

5462:
5463: l_quote_ctr c_quote_ctr%rowtype;
5464: l_quote_id NUMBER;
5465: l_rgd_code VARCHAR2(30);
5466: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
5467: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5468: l_message VARCHAR2(32000);
5469:
5470: l_tolerance_option VARCHAR2(150);

Line 5592: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;

5588: FROM OKL_TXL_QUOTE_LINES_B
5589: WHERE qte_id =c_id;
5590:
5591: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5592: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
5593:
5594: API_ERROR EXCEPTION;
5595:
5596: l_quote_total NUMBER := 0;

Line 6718: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;

6714:
6715: l_result VARCHAR2(50) := 'COMPLETE:NO';
6716:
6717: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6718: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
6719:
6720: -- rkuttiya 16-SEP-2003 Bug:2794685
6721: l_gain_loss_approval VARCHAR2(100);
6722: l_tolerance_amount NUMBER;