[Home] [Help]
147: select ct.object1_id1 id
148: from okc_contacts ct,
149: okc_contact_sources csrc,
150: okc_k_party_roles_b pty,
151: okc_k_headers_b chr
152: where ct.cpl_id = pty.id
153: and ct.cro_code = csrc.cro_code
154: and ct.jtot_object1_code = csrc.jtot_object_code
155: and ct.dnz_chr_id = chr.id
899:
900: CURSOR c (p_contract_number VARCHAR2)
901: IS
902: SELECT 'X'
903: FROM okc_k_headers_b k
904: WHERE k.contract_number = p_contract_number
905: ;
906:
907: CURSOR c2 (p_contract_number VARCHAR2, p_id NUMBER)
906:
907: CURSOR c2 (p_contract_number VARCHAR2, p_id NUMBER)
908: IS
909: SELECT 'X'
910: FROM okc_k_headers_b k
911: WHERE k.contract_number = p_contract_number
912: AND k.id <> p_id -- except itself
913: ;
914:
2029: -- mvasudev, 11/04/2003
2030: /*
2031: -- Replacing this by writing two cursors with top line first
2032: -- and sub lines next
2033: CURSOR c_agr_lns(p_khr_id okc_k_headers_b.id%TYPE) IS
2034: SELECT cle.id
2035: FROM apps.okc_k_lines_b cle
2036: WHERE cle.dnz_chr_id = p_khr_id
2037: ;
2487: ,p_init_msg_list IN VARCHAR2
2488: ,x_return_status OUT NOCOPY VARCHAR2
2489: ,x_msg_count OUT NOCOPY NUMBER
2490: ,x_msg_data OUT NOCOPY VARCHAR2
2491: ,p_khr_id IN OKC_K_HEADERS_B.ID%TYPE)
2492: IS
2493: l_api_name CONSTANT VARCHAR2(30) := 'activate_sec_agreement_pvt';
2494: l_api_version CONSTANT NUMBER := 1.0;
2495: i NUMBER;
2497: l_pol_id OKL_POOLS.ID%TYPE;
2498: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;
2499: l_org_id OKL_POOLS.ORG_ID%TYPE;
2500: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
2501: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
2502:
2503: l_pox_id OKL_POOL_CONTENTS.POX_ID%TYPE;
2504: l_poc_id OKL_POOL_CONTENTS.ID%TYPE;
2505: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3114: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
3115: ,x_return_status OUT NOCOPY VARCHAR2
3116: ,x_msg_count OUT NOCOPY NUMBER
3117: ,x_msg_data OUT NOCOPY VARCHAR2
3118: ,p_sec_agreement_status IN okc_k_headers_b.sts_code%TYPE
3119: ,p_sec_agreement_id IN okc_k_headers_b.id%TYPE)
3120: IS
3121: l_api_name CONSTANT VARCHAR2(30) := 'update_sec_agreement_sts';
3122: l_api_version CONSTANT NUMBER := 1.0;
3115: ,x_return_status OUT NOCOPY VARCHAR2
3116: ,x_msg_count OUT NOCOPY NUMBER
3117: ,x_msg_data OUT NOCOPY VARCHAR2
3118: ,p_sec_agreement_status IN okc_k_headers_b.sts_code%TYPE
3119: ,p_sec_agreement_id IN okc_k_headers_b.id%TYPE)
3120: IS
3121: l_api_name CONSTANT VARCHAR2(30) := 'update_sec_agreement_sts';
3122: l_api_version CONSTANT NUMBER := 1.0;
3123: i NUMBER;
3121: l_api_name CONSTANT VARCHAR2(30) := 'update_sec_agreement_sts';
3122: l_api_version CONSTANT NUMBER := 1.0;
3123: i NUMBER;
3124: l_kle_id OKC_K_LINES_B.ID%TYPE;
3125: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
3126:
3127: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3128:
3129: lp_secagreement_rec secagreement_rec_type;
3424: ,p_init_msg_list IN VARCHAR2
3425: ,x_return_status OUT NOCOPY VARCHAR2
3426: ,x_msg_count OUT NOCOPY NUMBER
3427: ,x_msg_data OUT NOCOPY VARCHAR2
3428: ,p_khr_id IN OKC_K_HEADERS_B.ID%TYPE)
3429: IS
3430:
3431: l_api_name CONSTANT VARCHAR2(30) := 'activate_add_request';
3432: l_api_version CONSTANT NUMBER := 1.0;
3435: l_pol_id OKL_POOLS.ID%TYPE;
3436: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;
3437: l_org_id OKL_POOLS.ORG_ID%TYPE;
3438: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
3439: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
3440:
3441: l_pox_id OKL_POOL_CONTENTS.POX_ID%TYPE;
3442: l_poc_id OKL_POOL_CONTENTS.ID%TYPE;
3443: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4261: p_init_msg_list IN VARCHAR2,
4262: x_return_status OUT NOCOPY VARCHAR2,
4263: x_msg_count OUT NOCOPY NUMBER,
4264: x_msg_data OUT NOCOPY VARCHAR2,
4265: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE)
4266: IS
4267: --Declaring local variables
4268: l_api_name CONSTANT VARCHAR2(30) := 'cancel_add_request';
4269: l_api_version CONSTANT NUMBER := 1.0;