APPS.OKS_MASSCHANGE_PVT dependencies on OKC_STATUSES_B

Line 7265: l_sts_code OKC_STATUSES_B.CODE%Type;

7261: l_test varchar2(100);
7262: x_test_chr_id NUMBER ;
7263:
7264: l_warranty_flag Varchar2(3);
7265: l_sts_code OKC_STATUSES_B.CODE%Type;
7266:
7267: l_empty_string1 Varchar2(500);
7268: l_dash_string1 Varchar2(500);
7269: l_process_type_msg_seed Varchar2(100);

Line 7697: From OKC_STATUSES_B

7693: FUNCTION Get_Status_Code(p_ste_code IN Varchar2)
7694: RETURN Varchar2 IS
7695: Cursor get_sts_code (p_ste_code in Varchar2) IS
7696: Select code
7697: From OKC_STATUSES_B
7698: Where ste_code = p_ste_code
7699: And default_yn = 'Y';
7700:
7701: l_sts_code OKC_STATUSES_B.CODE%type;

Line 7701: l_sts_code OKC_STATUSES_B.CODE%type;

7697: From OKC_STATUSES_B
7698: Where ste_code = p_ste_code
7699: And default_yn = 'Y';
7700:
7701: l_sts_code OKC_STATUSES_B.CODE%type;
7702:
7703: Begin
7704: Open get_sts_code(p_ste_code );
7705: Fetch get_sts_code into l_sts_code;