16987:
16988: -------------Cursor to get default status for line-------------------------
16989: CURSOR get_default_status IS
16990: select code
16991: from okc_statuses_b
16992: where ste_code = 'ENTERED'
16993: and default_yn = 'Y';
16994:
16995: l_Default_Sts_Code OKC_STATUSES_B.CODE%TYPE;
16991: from okc_statuses_b
16992: where ste_code = 'ENTERED'
16993: and default_yn = 'Y';
16994:
16995: l_Default_Sts_Code OKC_STATUSES_B.CODE%TYPE;
16996: ---------------------------------------------------------------------------
16997: ------------Cursor to get Contract Number of newly created contract--------
16998: CURSOR get_new_contract_number(P_To_Chr_ID IN NUMBER) IS
16999: select contract_number
20191:
20192: -------------Cursor to get default status for line-------------------------
20193: CURSOR get_default_status IS
20194: select code
20195: from okc_statuses_b
20196: where ste_code = 'ENTERED'
20197: and default_yn = 'Y';
20198:
20199: l_Default_Sts_Code OKC_STATUSES_B.CODE%TYPE;
20195: from okc_statuses_b
20196: where ste_code = 'ENTERED'
20197: and default_yn = 'Y';
20198:
20199: l_Default_Sts_Code OKC_STATUSES_B.CODE%TYPE;
20200: ---------------------------------------------------------------------------
20201: ------------Cursor to get Contract Number,Start Date and End Date of newly created contract--------
20202: CURSOR get_new_contract_num_and_Dates(P_To_Chr_ID IN NUMBER) IS
20203: select
26136: --Function StatusFitsQAHoldCriteria(p_current_status IN VARCHAR2)
26137: --Function to check to see if the current status of the contract fits the criteria to be changed to QA_HOLD
26138: --===================================================================
26139: Function SeedStatus(p_current_status IN VARCHAR2) RETURN VARCHAR2 IS
26140: l_result OKC_STATUSES_B.STE_CODE%TYPE;
26141: Begin
26142: select ste_code
26143: into l_result
26144: from okc_statuses_b
26140: l_result OKC_STATUSES_B.STE_CODE%TYPE;
26141: Begin
26142: select ste_code
26143: into l_result
26144: from okc_statuses_b
26145: where code = p_current_status;
26146:
26147: RETURN l_result;
26148: