DBA Data[Home] [Help]

APPS.OKL_LEASE_APP_PVT dependencies on WF_PARAMETER_LIST_T

Line 2175: l_parameter_list wf_parameter_list_t;

2171: p_transaction_id IN NUMBER,
2172: p_event_name IN VARCHAR2) IS
2173:
2174: -- Variables Declarations
2175: l_parameter_list wf_parameter_list_t;
2176: l_key VARCHAR2(240);
2177: l_seq NUMBER;
2178:
2179: -- Selects the nextval from sequence, used later for defining event key

Line 2521: l_parameter_list wf_parameter_list_t;

2517: l_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;
2518: x_cldv_tbl OKL_CLD_PVT.CLDV_TBL_TYPE;
2519:
2520: -- Bug#4741121 - viselvar - Modified - Start
2521: l_parameter_list wf_parameter_list_t;
2522: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.checklist_associated';
2523: -- Bug#4741121 - viselvar - Modified - End
2524:
2525:

Line 2921: l_parameter_list wf_parameter_list_t;

2917: l_crr_rec crr_rec_type;
2918: x_crr_rec crr_rec_type;
2919:
2920: -- Bug#4741121 - viselvar - Modified - Start
2921: l_parameter_list wf_parameter_list_t;
2922: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.header_created';
2923: p_event_name1 VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.sales_quote_created';
2924: -- Bug#4741121 - viselvar - Modified - End
2925:

Line 3648: l_parameter_list wf_parameter_list_t;

3644: l_lapv_rec lapv_rec_type;
3645: l_lsqv_rec lsqv_rec_type;
3646:
3647: -- Bug#4741121 - viselvar - Modified - Start
3648: l_parameter_list wf_parameter_list_t;
3649: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.saved';
3650: -- Bug#4741121 - viselvar - Modified - Start
3651:
3652: --asawanka Bug 4865418 changes start

Line 4218: l_parameter_list wf_parameter_list_t;

4214: l_lapv_rec lapv_rec_type;
4215: l_lsqv_rec lsqv_rec_type;
4216:
4217: -- Bug#4741121 - viselvar - Modified - Start
4218: l_parameter_list wf_parameter_list_t;
4219: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.validated';
4220: -- Bug#4741121 - viselvar - Modified - End
4221:
4222: --Cursor for Lease Application Template details

Line 4769: l_parameter_list wf_parameter_list_t;

4765: l_lapv_rec lapv_rec_type;
4766: l_lsqv_rec lsqv_rec_type;
4767: x_lsqv_rec lsqv_rec_type;
4768: -- Bug#4741121 - viselvar - Modified - Start
4769: l_parameter_list wf_parameter_list_t;
4770: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.submitted_for_acceptance';
4771: p_event_name1 VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.quote_accepted';
4772: -- Bug#4741121 - viselvar - Modified - End
4773: BEGIN

Line 5117: l_parameter_list WF_PARAMETER_LIST_T;

5113: l_lsqv_rec lsqv_rec_type;
5114: x_lsqv_rec lsqv_rec_type;
5115:
5116: -- Bug#4741121 - smadhava - Added - Start
5117: l_parameter_list WF_PARAMETER_LIST_T;
5118: l_event_name wf_events.name%TYPE;
5119: -- Bug#4741121 - smadhava - Added - End
5120: BEGIN
5121: l_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 5476: l_parameter_list wf_parameter_list_t;

5472: l_crr_rec crr_rec_type;
5473: x_crr_rec crr_rec_type;
5474:
5475: -- Bug#4741121 - viselvar - Modified - Start
5476: l_parameter_list wf_parameter_list_t;
5477: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.duplicated';
5478: -- Bug#4741121 - viselvar - Modified - End
5479:
5480: --gboomina:bug 7110500 - Start

Line 6187: l_parameter_list wf_parameter_list_t;

6183: l_lapv_rec lapv_rec_type;
6184: l_lsqv_rec lsqv_rec_type;
6185: x_lsqv_rec lsqv_rec_type;
6186: -- Bug#4741121 - viselvar - Modified - Start
6187: l_parameter_list wf_parameter_list_t;
6188: p_event_name1 VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.sent_for_pricing_approval';
6189: p_event_name2 VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.pricing_approved';
6190: -- Bug#4741121 - viselvar - Modified - End
6191:

Line 6578: l_parameter_list wf_parameter_list_t;

6574: l_lsqv_rec lsqv_rec_type;
6575: x_lsqv_rec lsqv_rec_type;
6576: l_crd_req_rec OCM_CREDIT_REQUEST_UPDATE_PUB.credit_request_rec;
6577: -- Bug#4741121 - viselvar - Modified - Start
6578: l_parameter_list wf_parameter_list_t;
6579: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.submitted_for_credit_evaluation';
6580: -- Bug#4741121 - viselvar - Modified - End
6581: l_count NUMBER;
6582: l_exp_date DATE;

Line 7661: l_parameter_list wf_parameter_list_t;

7657: l_lapv_rec lapv_rec_type;
7658: l_lsqv_rec lsqv_rec_type;
7659:
7660: -- Bug#4741121 - viselvar - Modified - Start
7661: l_parameter_list wf_parameter_list_t;
7662: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.reco_alt_offers_acpt';
7663: -- Bug#4741121 - viselvar - Modified - End
7664:
7665: --Cursor to obtain the in play quote id

Line 8459: l_parameter_list wf_parameter_list_t;

8455: l_lapv_rec lapv_rec_type;
8456: l_lsqv_rec lsqv_rec_type;
8457: l_crr_rec crr_rec_type;
8458: x_crr_rec crr_rec_type;
8459: l_parameter_list wf_parameter_list_t;
8460: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.resubmitted';
8461:
8462: --Cursor to obtain Checklist Header Id
8463: CURSOR chk_hdr_dtls_csr(cp_lap_id NUMBER)

Line 8915: l_parameter_list wf_parameter_list_t;

8911: l_return_status VARCHAR2(1);
8912: l_meaning VARCHAR2(80);
8913:
8914: -- Bug#4741121 - viselvar - Modified - Start
8915: l_parameter_list wf_parameter_list_t;
8916: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.cancelled';
8917: -- Bug#4741121 - viselvar - Modified - End
8918:
8919: --Cursor to populate Lease Application details from database

Line 9267: l_parameter_list wf_parameter_list_t;

9263: l_lapv_rec lapv_rec_type;
9264: l_lsqv_rec lsqv_rec_type;
9265: l_crr_rec crr_rec_type;
9266: x_crr_rec crr_rec_type;
9267: l_parameter_list wf_parameter_list_t;
9268: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.appeal';
9269:
9270: --Cursor to obtain Checklist Header Id
9271: CURSOR chk_hdr_dtls_csr(cp_lap_id NUMBER)

Line 10287: l_parameter_list wf_parameter_list_t;

10283: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'LEASE_APP_PRICE';
10284: l_return_status VARCHAR2(1);
10285:
10286: -- Bug#4741121 - viselvar - Modified - Start
10287: l_parameter_list wf_parameter_list_t;
10288: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.priced';
10289: -- Bug#4741121 - viselvar - Modified - End
10290:
10291: --Cursor to obtain the details of lease quote line of Lease App