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 1528: SELECT OKLSSC_WFITEMKEY_S.nextval from dual;

1524: l_params wf_parameter_list_t;
1525: l_event_key NUMBER;
1526:
1527: CURSOR event_number IS
1528: SELECT OKLSSC_WFITEMKEY_S.nextval from dual;
1529:
1530:
1531: begin
1532:

Line 2519: SELECT OKLSSC_WFITEMKEY_S.nextval key from dual;

2515: invoice_format_id in varchar2)
2516:
2517: IS
2518: CURSOR item_key_seq IS
2519: SELECT OKLSSC_WFITEMKEY_S.nextval key from dual;
2520:
2521: item_key_rec item_key_seq%rowtype;
2522:
2523: item_key varchar2(100) ;

Line 2548: SELECT OKLSSC_WFITEMKEY_S.nextval key from dual;

2544: bill_site_id in varchar2)
2545:
2546: IS
2547: CURSOR item_key_seq IS
2548: SELECT OKLSSC_WFITEMKEY_S.nextval key from dual;
2549:
2550: CURSOR c_get_khr_org(p_contract_id IN NUMBER) IS
2551: select authoring_org_id
2552: from okc_k_headers_all_b

Line 2743: FROM dual;

2739: WHERE id = p_polid;
2740:
2741: CURSOR wf_seq IS
2742: SELECT OKLSSC_WFITEMKEY_S.nextval
2743: FROM dual;
2744:
2745:
2746: api_exception EXCEPTION;
2747: begin

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

2965: l_yn := exist_subscription(l_event_name);
2966: IF l_yn = 'Y' THEN
2967:
2968: --Get the item key
2969: select OKLSSC_WFITEMKEY_S.nextval INTO l_seq FROM DUAL ;
2970: l_key := l_event_name ||l_seq ;
2971:
2972: --Set Parameters
2973: wf_event.AddParameterToList('CLAIM_ID',TO_CHAR(p_claim_id),l_parameter_list);

Line 3645: FROM dual;

3641: api_exception EXCEPTION;
3642: begin
3643: l_yn := exist_subscription(l_event_name);
3644: SELECT OKLSSC_WFITEMKEY_S.nextval into l_seq
3645: FROM dual;
3646:
3647: IF l_yn = 'N' THEN
3648: FND_MESSAGE.SET_NAME('OKL', 'OKL_NO_EVENT');
3649: FND_MSG_PUB.ADD;

Line 3875: SELECT OKLSSC_WFITEMKEY_S.nextval key from dual;

3871: x_msg_data VARCHAR2(4000);
3872: l_parameter_list wf_parameter_list_t;
3873:
3874: CURSOR assets_key_seq IS
3875: SELECT OKLSSC_WFITEMKEY_S.nextval key from dual;
3876:
3877: assets_key_rec assets_key_seq%rowtype;
3878: assets_key varchar2(100) ;
3879: