[Home] [Help]
3632:
3633: -- Cursor created to get the PDF_ID for Class 'SERVICE' - Bug 1917514
3634: CURSOR c_pdf IS
3635: SELECT pdf_id
3636: FROM okc_class_operations
3637: WHERE opn_code = 'COPY'
3638: AND cls_code = 'SERVICE';
3639:
3640: l_pdf_id NUMBER;
4116: p_msg_name => 'OKC_NOT_FOUND',
4117: p_token1 => 'VALUE1',
4118: p_token1_value => 'Status Code',
4119: p_token2 => 'VALUE2',
4120: p_token2_value => 'OKC_CLASS_OPERATIONS_V');
4121: when OTHERS then
4122: -- store SQL error message on message stack
4123: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
4124: p_msg_name => g_unexpected_error,
5140: IS
5141: -- Cursor to get class operation id
5142: Cursor cop_csr Is
5143: SELECT id
5144: FROM okc_class_operations
5145: WHERE cls_code = ( SELECT cls_code
5146: FROM okc_subclasses_b
5147: WHERE code = p_chrv_rec.scs_code )
5148: AND opn_code = 'RENEWAL';
5205: p_msg_name => 'OKC_NOT_FOUND',
5206: p_token1 => 'VALUE1',
5207: p_token1_value => 'Status Code',
5208: p_token2 => 'VALUE2',
5209: p_token2_value => 'OKC_CLASS_OPERATIONS_V');
5210: when OTHERS then
5211: -- store SQL error message on message stack
5212: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
5213: p_msg_name => g_unexpected_error,
6036:
6037: -- Cursor created to get the PDF_ID for Class 'SERVICE' - Bug 2151523(1917514)
6038: CURSOR c_pdf IS
6039: SELECT pdf_id
6040: FROM okc_class_operations
6041: WHERE opn_code = 'COPY'
6042: AND cls_code = 'SERVICE';
6043:
6044: l_pdf_id NUMBER;
10445:
10446: -- Cursor created to get the PDF_ID for Class 'SERVICE' - Bug 1917514
10447: CURSOR c_pdf IS
10448: SELECT pdf_id
10449: FROM okc_class_operations
10450: WHERE opn_code = 'COPY'
10451: AND cls_code = 'SERVICE';
10452:
10453: l_pdf_id NUMBER;