eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OKL_LEASE_QUOTE_WORKFLOW_PVT dependencies on OKL_LEASE_QUOTES_V

Line 354: l_quote_number OKL_LEASE_QUOTES_V.REFERENCE_NUMBER%TYPE;

350: resultout OUT NOCOPY VARCHAR2) IS
351:
352: l_api_name CONSTANT VARCHAR2(30) := 'populate_accept_attribs';
353:
354: l_quote_number OKL_LEASE_QUOTES_V.REFERENCE_NUMBER%TYPE;
355: l_quote_id OKL_LEASE_QUOTES_V.ID%TYPE;
356:
357: CURSOR c_fetch_quote_number(p_quote_id OKL_LEASE_QUOTES_V.ID%TYPE)
358: IS

Line 355: l_quote_id OKL_LEASE_QUOTES_V.ID%TYPE;

351:
352: l_api_name CONSTANT VARCHAR2(30) := 'populate_accept_attribs';
353:
354: l_quote_number OKL_LEASE_QUOTES_V.REFERENCE_NUMBER%TYPE;
355: l_quote_id OKL_LEASE_QUOTES_V.ID%TYPE;
356:
357: CURSOR c_fetch_quote_number(p_quote_id OKL_LEASE_QUOTES_V.ID%TYPE)
358: IS
359: SELECT reference_number

Line 357: CURSOR c_fetch_quote_number(p_quote_id OKL_LEASE_QUOTES_V.ID%TYPE)

353:
354: l_quote_number OKL_LEASE_QUOTES_V.REFERENCE_NUMBER%TYPE;
355: l_quote_id OKL_LEASE_QUOTES_V.ID%TYPE;
356:
357: CURSOR c_fetch_quote_number(p_quote_id OKL_LEASE_QUOTES_V.ID%TYPE)
358: IS
359: SELECT reference_number
360: FROM okl_lease_quotes_v
361: WHERE id = p_quote_id;

Line 360: FROM okl_lease_quotes_v

356:
357: CURSOR c_fetch_quote_number(p_quote_id OKL_LEASE_QUOTES_V.ID%TYPE)
358: IS
359: SELECT reference_number
360: FROM okl_lease_quotes_v
361: WHERE id = p_quote_id;
362:
363: lx_return_status VARCHAR2(1);
364:

Line 546: l_quote_id OKL_LEASE_QUOTES_V.ID%TYPE;

542: resultout OUT NOCOPY VARCHAR2) AS
543:
544: l_api_name CONSTANT VARCHAR2(30) := 'populate_submit_attribs';
545:
546: l_quote_id OKL_LEASE_QUOTES_V.ID%TYPE;
547: l_quote_number OKL_LEASE_QUOTES_V.REFERENCE_NUMBER%TYPE;
548:
549: lx_return_status VARCHAR2(1);
550: lx_msg_count NUMBER;

Line 547: l_quote_number OKL_LEASE_QUOTES_V.REFERENCE_NUMBER%TYPE;

543:
544: l_api_name CONSTANT VARCHAR2(30) := 'populate_submit_attribs';
545:
546: l_quote_id OKL_LEASE_QUOTES_V.ID%TYPE;
547: l_quote_number OKL_LEASE_QUOTES_V.REFERENCE_NUMBER%TYPE;
548:
549: lx_return_status VARCHAR2(1);
550: lx_msg_count NUMBER;
551: lx_msg_data VARCHAR2(4000);

Line 553: CURSOR c_fetch_quote_number(p_quote_id OKL_LEASE_QUOTES_V.ID%TYPE)

549: lx_return_status VARCHAR2(1);
550: lx_msg_count NUMBER;
551: lx_msg_data VARCHAR2(4000);
552:
553: CURSOR c_fetch_quote_number(p_quote_id OKL_LEASE_QUOTES_V.ID%TYPE)
554: IS
555: SELECT reference_number
556: FROM okl_lease_quotes_v
557: WHERE id = p_quote_id;

Line 556: FROM okl_lease_quotes_v

552:
553: CURSOR c_fetch_quote_number(p_quote_id OKL_LEASE_QUOTES_V.ID%TYPE)
554: IS
555: SELECT reference_number
556: FROM okl_lease_quotes_v
557: WHERE id = p_quote_id;
558:
559: BEGIN
560:

Line 728: CURSOR c_fetch_quote_number(p_quote_id OKL_LEASE_QUOTES_V.ID%TYPE)

724: l_application_id fnd_application.application_id%TYPE;
725: l_parent_code VARCHAR2(20);
726: l_parent_id NUMBER;
727:
728: CURSOR c_fetch_quote_number(p_quote_id OKL_LEASE_QUOTES_V.ID%TYPE)
729: IS
730: SELECT reference_number, valid_from, valid_to, parent_object_code, parent_object_id
731: FROM okl_lease_quotes_b
732: WHERE id = p_quote_id;

Line 942: l_quote_id OKL_LEASE_QUOTES_V.ID%TYPE;

938: resultout OUT NOCOPY VARCHAR2) IS
939:
940: l_api_name CONSTANT VARCHAR2(30) := 'handle_approval';
941:
942: l_quote_id OKL_LEASE_QUOTES_V.ID%TYPE;
943: l_result VARCHAR2(30);
944: lv_approval_status_ame VARCHAR2(30);
945: l_flag NUMBER;
946: