DBA Data[Home] [Help]

APPS.OKL_LEASE_APP_PVT dependencies on WF_PARAMETER_LIST_T

Line 2133: l_parameter_list wf_parameter_list_t;

2129: p_transaction_id IN NUMBER,
2130: p_event_name IN VARCHAR2) IS
2131:
2132: -- Variables Declarations
2133: l_parameter_list wf_parameter_list_t;
2134: l_key VARCHAR2(240);
2135: l_seq NUMBER;
2136:
2137: -- Selects the nextval from sequence, used later for defining event key

Line 2479: l_parameter_list wf_parameter_list_t;

2475: l_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;
2476: x_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;
2477:
2478: -- Bug#4741121 - viselvar - Modified - Start
2479: l_parameter_list wf_parameter_list_t;
2480: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.checklist_associated';
2481: -- Bug#4741121 - viselvar - Modified - End
2482:
2483:

Line 2879: l_parameter_list wf_parameter_list_t;

2875: l_crr_rec crr_rec_type;
2876: x_crr_rec crr_rec_type;
2877:
2878: -- Bug#4741121 - viselvar - Modified - Start
2879: l_parameter_list wf_parameter_list_t;
2880: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.header_created';
2881: p_event_name1 VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.sales_quote_created';
2882: -- Bug#4741121 - viselvar - Modified - End
2883:

Line 3560: l_parameter_list wf_parameter_list_t;

3556: l_lapv_rec lapv_rec_type;
3557: l_lsqv_rec lsqv_rec_type;
3558:
3559: -- Bug#4741121 - viselvar - Modified - Start
3560: l_parameter_list wf_parameter_list_t;
3561: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.saved';
3562: -- Bug#4741121 - viselvar - Modified - Start
3563:
3564: --asawanka Bug 4865418 changes start

Line 4130: l_parameter_list wf_parameter_list_t;

4126: l_lapv_rec lapv_rec_type;
4127: l_lsqv_rec lsqv_rec_type;
4128:
4129: -- Bug#4741121 - viselvar - Modified - Start
4130: l_parameter_list wf_parameter_list_t;
4131: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.validated';
4132: -- Bug#4741121 - viselvar - Modified - End
4133:
4134: --Cursor for Lease Application Template details

Line 4681: l_parameter_list wf_parameter_list_t;

4677: l_lapv_rec lapv_rec_type;
4678: l_lsqv_rec lsqv_rec_type;
4679: x_lsqv_rec lsqv_rec_type;
4680: -- Bug#4741121 - viselvar - Modified - Start
4681: l_parameter_list wf_parameter_list_t;
4682: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.submitted_for_acceptance';
4683: p_event_name1 VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.quote_accepted';
4684: -- Bug#4741121 - viselvar - Modified - End
4685: BEGIN

Line 5029: l_parameter_list WF_PARAMETER_LIST_T;

5025: l_lsqv_rec lsqv_rec_type;
5026: x_lsqv_rec lsqv_rec_type;
5027:
5028: -- Bug#4741121 - smadhava - Added - Start
5029: l_parameter_list WF_PARAMETER_LIST_T;
5030: l_event_name wf_events.name%TYPE;
5031: -- Bug#4741121 - smadhava - Added - End
5032: BEGIN
5033: l_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 5388: l_parameter_list wf_parameter_list_t;

5384: l_crr_rec crr_rec_type;
5385: x_crr_rec crr_rec_type;
5386:
5387: -- Bug#4741121 - viselvar - Modified - Start
5388: l_parameter_list wf_parameter_list_t;
5389: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.duplicated';
5390: -- Bug#4741121 - viselvar - Modified - End
5391:
5392: --gboomina:bug 7110500 - Start

Line 6056: l_parameter_list wf_parameter_list_t;

6052: l_lapv_rec lapv_rec_type;
6053: l_lsqv_rec lsqv_rec_type;
6054: x_lsqv_rec lsqv_rec_type;
6055: -- Bug#4741121 - viselvar - Modified - Start
6056: l_parameter_list wf_parameter_list_t;
6057: p_event_name1 VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.sent_for_pricing_approval';
6058: p_event_name2 VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.pricing_approved';
6059: -- Bug#4741121 - viselvar - Modified - End
6060:

Line 6447: l_parameter_list wf_parameter_list_t;

6443: l_lsqv_rec lsqv_rec_type;
6444: x_lsqv_rec lsqv_rec_type;
6445: l_crd_req_rec OCM_CREDIT_REQUEST_UPDATE_PUB.credit_request_rec;
6446: -- Bug#4741121 - viselvar - Modified - Start
6447: l_parameter_list wf_parameter_list_t;
6448: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.submitted_for_credit_evaluation';
6449: -- Bug#4741121 - viselvar - Modified - End
6450: l_count NUMBER;
6451: l_exp_date DATE;

Line 7530: l_parameter_list wf_parameter_list_t;

7526: l_lapv_rec lapv_rec_type;
7527: l_lsqv_rec lsqv_rec_type;
7528:
7529: -- Bug#4741121 - viselvar - Modified - Start
7530: l_parameter_list wf_parameter_list_t;
7531: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.reco_alt_offers_acpt';
7532: -- Bug#4741121 - viselvar - Modified - End
7533:
7534: --Cursor to obtain the in play quote id

Line 8328: l_parameter_list wf_parameter_list_t;

8324: l_lapv_rec lapv_rec_type;
8325: l_lsqv_rec lsqv_rec_type;
8326: l_crr_rec crr_rec_type;
8327: x_crr_rec crr_rec_type;
8328: l_parameter_list wf_parameter_list_t;
8329: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.resubmitted';
8330:
8331: --Cursor to obtain Checklist Header Id
8332: CURSOR chk_hdr_dtls_csr(cp_lap_id NUMBER)

Line 8784: l_parameter_list wf_parameter_list_t;

8780: l_return_status VARCHAR2(1);
8781: l_meaning VARCHAR2(80);
8782:
8783: -- Bug#4741121 - viselvar - Modified - Start
8784: l_parameter_list wf_parameter_list_t;
8785: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.cancelled';
8786: -- Bug#4741121 - viselvar - Modified - End
8787:
8788: --Cursor to populate Lease Application details from database

Line 9136: l_parameter_list wf_parameter_list_t;

9132: l_lapv_rec lapv_rec_type;
9133: l_lsqv_rec lsqv_rec_type;
9134: l_crr_rec crr_rec_type;
9135: x_crr_rec crr_rec_type;
9136: l_parameter_list wf_parameter_list_t;
9137: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.appeal';
9138:
9139: --Cursor to obtain Checklist Header Id
9140: CURSOR chk_hdr_dtls_csr(cp_lap_id NUMBER)

Line 10135: l_parameter_list wf_parameter_list_t;

10131: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'LEASE_APP_PRICE';
10132: l_return_status VARCHAR2(1);
10133:
10134: -- Bug#4741121 - viselvar - Modified - Start
10135: l_parameter_list wf_parameter_list_t;
10136: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.priced';
10137: -- Bug#4741121 - viselvar - Modified - End
10138:
10139: --Cursor to obtain the details of lease quote line of Lease App