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 552: l_quote_id OKL_LEASE_QUOTES_V.ID%TYPE;

548: resultout OUT NOCOPY VARCHAR2) AS
549:
550: l_api_name CONSTANT VARCHAR2(30) := 'populate_submit_attribs';
551:
552: l_quote_id OKL_LEASE_QUOTES_V.ID%TYPE;
553: l_quote_number OKL_LEASE_QUOTES_V.REFERENCE_NUMBER%TYPE;
554:
555: lx_return_status VARCHAR2(1);
556: lx_msg_count NUMBER;

Line 553: l_quote_number OKL_LEASE_QUOTES_V.REFERENCE_NUMBER%TYPE;

549:
550: l_api_name CONSTANT VARCHAR2(30) := 'populate_submit_attribs';
551:
552: l_quote_id OKL_LEASE_QUOTES_V.ID%TYPE;
553: l_quote_number OKL_LEASE_QUOTES_V.REFERENCE_NUMBER%TYPE;
554:
555: lx_return_status VARCHAR2(1);
556: lx_msg_count NUMBER;
557: lx_msg_data VARCHAR2(4000);

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

555: lx_return_status VARCHAR2(1);
556: lx_msg_count NUMBER;
557: lx_msg_data VARCHAR2(4000);
558:
559: CURSOR c_fetch_quote_number(p_quote_id OKL_LEASE_QUOTES_V.ID%TYPE)
560: IS
561: SELECT reference_number
562: FROM okl_lease_quotes_v
563: WHERE id = p_quote_id;

Line 562: FROM okl_lease_quotes_v

558:
559: CURSOR c_fetch_quote_number(p_quote_id OKL_LEASE_QUOTES_V.ID%TYPE)
560: IS
561: SELECT reference_number
562: FROM okl_lease_quotes_v
563: WHERE id = p_quote_id;
564:
565: BEGIN
566:

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

761: l_parent_code VARCHAR2(20);
762: l_parent_id NUMBER;
763: l_approver_role VARCHAR2(100); -- added for BUG16175322
764:
765: CURSOR c_fetch_quote_number(p_quote_id OKL_LEASE_QUOTES_V.ID%TYPE)
766: IS
767: SELECT reference_number, valid_from, valid_to, parent_object_code, parent_object_id
768: FROM okl_lease_quotes_b
769: WHERE id = p_quote_id;

Line 1014: l_quote_id OKL_LEASE_QUOTES_V.ID%TYPE;

1010: resultout OUT NOCOPY VARCHAR2) IS
1011:
1012: l_api_name CONSTANT VARCHAR2(30) := 'handle_approval';
1013:
1014: l_quote_id OKL_LEASE_QUOTES_V.ID%TYPE;
1015: l_result VARCHAR2(30);
1016: lv_approval_status_ame VARCHAR2(30);
1017: l_flag NUMBER;
1018: