APPS.OKS_COPY_CONTRACT_PVT dependencies on OKC_STATUSES_B

Line 16924: from okc_statuses_b

16920:
16921: -------------Cursor to get default status for line-------------------------
16922: CURSOR get_default_status IS
16923: select code
16924: from okc_statuses_b
16925: where ste_code = 'ENTERED'
16926: and default_yn = 'Y';
16927:
16928: l_Default_Sts_Code OKC_STATUSES_B.CODE%TYPE;

Line 16928: l_Default_Sts_Code OKC_STATUSES_B.CODE%TYPE;

16924: from okc_statuses_b
16925: where ste_code = 'ENTERED'
16926: and default_yn = 'Y';
16927:
16928: l_Default_Sts_Code OKC_STATUSES_B.CODE%TYPE;
16929: ---------------------------------------------------------------------------
16930: ------------Cursor to get Contract Number of newly created contract--------
16931: CURSOR get_new_contract_number(P_To_Chr_ID IN NUMBER) IS
16932: select contract_number

Line 20048: from okc_statuses_b

20044:
20045: -------------Cursor to get default status for line-------------------------
20046: CURSOR get_default_status IS
20047: select code
20048: from okc_statuses_b
20049: where ste_code = 'ENTERED'
20050: and default_yn = 'Y';
20051:
20052: l_Default_Sts_Code OKC_STATUSES_B.CODE%TYPE;

Line 20052: l_Default_Sts_Code OKC_STATUSES_B.CODE%TYPE;

20048: from okc_statuses_b
20049: where ste_code = 'ENTERED'
20050: and default_yn = 'Y';
20051:
20052: l_Default_Sts_Code OKC_STATUSES_B.CODE%TYPE;
20053: ---------------------------------------------------------------------------
20054: ------------Cursor to get Contract Number,Start Date and End Date of newly created contract--------
20055: CURSOR get_new_contract_num_and_Dates(P_To_Chr_ID IN NUMBER) IS
20056: select

Line 25941: l_result OKC_STATUSES_B.STE_CODE%TYPE;

25937: --Function StatusFitsQAHoldCriteria(p_current_status IN VARCHAR2)
25938: --Function to check to see if the current status of the contract fits the criteria to be changed to QA_HOLD
25939: --===================================================================
25940: Function SeedStatus(p_current_status IN VARCHAR2) RETURN VARCHAR2 IS
25941: l_result OKC_STATUSES_B.STE_CODE%TYPE;
25942: Begin
25943: select ste_code
25944: into l_result
25945: from okc_statuses_b

Line 25945: from okc_statuses_b

25941: l_result OKC_STATUSES_B.STE_CODE%TYPE;
25942: Begin
25943: select ste_code
25944: into l_result
25945: from okc_statuses_b
25946: where code = p_current_status;
25947:
25948: RETURN l_result;
25949: