APPS.OKL_IN_TPP_PVT dependencies on OKL_API

Line 35: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

31: prt.PARTY_ID = hps.PARTY_ID AND
32: --prt.THIRD_PARTY_FLAG ='Y' AND
33: prt.PARTY_ID = p_isu_id AND
34: hps.party_site_id = p_agency_site_id;
35: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
36: BEGIN
37: open agency_addrss;
38: fetch agency_addrss into x_agency_name,x_agency_addrss1,x_agency_addrss2,x_agency_addrss3,
39: x_agency_addrss4,x_agency_city,x_agency_county,x_agency_province,

Line 86: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

82: prt.PARTY_ID = hps.PARTY_ID AND
83: --prt.THIRD_PARTY_FLAG ='Y' AND
84: prt.PARTY_ID = p_int_id AND
85: hps.party_site_id = p_agent_site_id;
86: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
87: BEGIN
88: open agent_addrss;
89: fetch agent_addrss into x_agent_name,x_agent_addrss1,x_agent_addrss2,x_agent_addrss3,
90: x_agent_addrss4,x_agent_city,x_agent_county,x_agent_province,