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