APPS.OKL_SSC_WF dependencies on DUAL

Line 296: from dual;

292: BEGIN
293: l_mask_string := '*';
294: select decode(fnd_profile.value('AR_MASK_BANK_ACCOUNT_NUMBERS'),'F',rpad(substr(cc_number,1,4),length(cc_number),l_mask_string),'L',lpad(substr(cc_number,length(cc_number)-3),length(cc_number),l_mask_string),'N','N')
295: into l_result
296: from dual;
297: if l_result='N' then
298: masked_cc := cc_number;
299: else
300: masked_cc := l_result;

Line 1442: SELECT OKLSSC_WFITEMKEY_S.nextval from dual;

1438: l_params wf_parameter_list_t;
1439: l_event_key NUMBER;
1440:
1441: CURSOR event_number IS
1442: SELECT OKLSSC_WFITEMKEY_S.nextval from dual;
1443:
1444:
1445: begin
1446:

Line 2433: SELECT OKLSSC_WFITEMKEY_S.nextval key from dual;

2429: invoice_format_id in varchar2)
2430:
2431: IS
2432: CURSOR item_key_seq IS
2433: SELECT OKLSSC_WFITEMKEY_S.nextval key from dual;
2434:
2435: item_key_rec item_key_seq%rowtype;
2436:
2437: item_key varchar2(100) ;

Line 2462: SELECT OKLSSC_WFITEMKEY_S.nextval key from dual;

2458: bill_site_id in varchar2)
2459:
2460: IS
2461: CURSOR item_key_seq IS
2462: SELECT OKLSSC_WFITEMKEY_S.nextval key from dual;
2463:
2464: CURSOR c_get_khr_org(p_contract_id IN NUMBER) IS
2465: select authoring_org_id
2466: from okc_k_headers_all_b

Line 2657: FROM dual;

2653: WHERE id = p_polid;
2654:
2655: CURSOR wf_seq IS
2656: SELECT OKLSSC_WFITEMKEY_S.nextval
2657: FROM dual;
2658:
2659:
2660: api_exception EXCEPTION;
2661: begin

Line 2883: select OKLSSC_WFITEMKEY_S.nextval INTO l_seq FROM DUAL ;

2879: l_yn := exist_subscription(l_event_name);
2880: IF l_yn = 'Y' THEN
2881:
2882: --Get the item key
2883: select OKLSSC_WFITEMKEY_S.nextval INTO l_seq FROM DUAL ;
2884: l_key := l_event_name ||l_seq ;
2885:
2886: --Set Parameters
2887: wf_event.AddParameterToList('CLAIM_ID',TO_CHAR(p_claim_id),l_parameter_list);

Line 3559: FROM dual;

3555: api_exception EXCEPTION;
3556: begin
3557: l_yn := exist_subscription(l_event_name);
3558: SELECT OKLSSC_WFITEMKEY_S.nextval into l_seq
3559: FROM dual;
3560:
3561: IF l_yn = 'N' THEN
3562: FND_MESSAGE.SET_NAME('OKL', 'OKL_NO_EVENT');
3563: FND_MSG_PUB.ADD;