2613:
2614: l_seq Number;
2615: l_seq_len Number;
2616: l_doc_sequence_id Number;
2617: l_contract_number okc_k_headers_b.contract_number%TYPE;
2618: l_dummy Varchar2(1);
2619: l_row_found Boolean := False;
2620: l_row_notfound Boolean := False;
2621: l_return_status Varchar2(30);
2657: WHERE ORGANIZATION_ID = V_ORG_ID;
2658: --END NPALEPU
2659:
2660: Function Contract_Is_Unique(p_contract_number IN
2661: okc_k_headers_b.contract_number%TYPE)
2662: Return Boolean Is
2663:
2664: cursor c2 is
2665: select 'x'
2663:
2664: cursor c2 is
2665: select 'x'
2666: --npalepu modified on 24-AUG-2006 for bug # 5487532
2667: /* from okc_k_headers_b */
2668: from okc_k_headers_all_b
2669: --end npalepu
2670: where contract_number = p_contract_number
2671: and contract_number_modifier is null;
2672:
2673: cursor c3 is
2674: select 'x'
2675: --npalepu modified on 24-AUG-2006 for bug # 5487532
2676: /* from okc_k_headers_b */
2677: from okc_k_headers_all_b
2678: --end npalepu
2679: where contract_number = p_contract_number
2680: and contract_number_modifier = p_contract_number_modifier;