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 5328: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;

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

Line 5464: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;

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

Line 5590: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;

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

Line 6716: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;

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