APPS.OKE_TERMS_PUB dependencies on OKE_K_TERMS

Line 701: p_trm_cd IN OKE_K_TERMS.TERM_CODE%TYPE,

697: x_msg_count OUT NOCOPY NUMBER,
698: x_msg_data OUT NOCOPY VARCHAR2,
699: p_chr_id IN NUMBER,
700: p_cle_id IN NUMBER,
701: p_trm_cd IN OKE_K_TERMS.TERM_CODE%TYPE,
702: p_trm_val_pk1 IN OKE_K_TERMS.TERM_VALUE_PK1%TYPE,
703: p_trm_val_pk2 IN OKE_K_TERMS.TERM_VALUE_PK2%TYPE) IS
704:
705: l_term_rec oke_term_pvt.term_rec_type;

Line 702: p_trm_val_pk1 IN OKE_K_TERMS.TERM_VALUE_PK1%TYPE,

698: x_msg_data OUT NOCOPY VARCHAR2,
699: p_chr_id IN NUMBER,
700: p_cle_id IN NUMBER,
701: p_trm_cd IN OKE_K_TERMS.TERM_CODE%TYPE,
702: p_trm_val_pk1 IN OKE_K_TERMS.TERM_VALUE_PK1%TYPE,
703: p_trm_val_pk2 IN OKE_K_TERMS.TERM_VALUE_PK2%TYPE) IS
704:
705: l_term_rec oke_term_pvt.term_rec_type;
706: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TERM';

Line 703: p_trm_val_pk2 IN OKE_K_TERMS.TERM_VALUE_PK2%TYPE) IS

699: p_chr_id IN NUMBER,
700: p_cle_id IN NUMBER,
701: p_trm_cd IN OKE_K_TERMS.TERM_CODE%TYPE,
702: p_trm_val_pk1 IN OKE_K_TERMS.TERM_VALUE_PK1%TYPE,
703: p_trm_val_pk2 IN OKE_K_TERMS.TERM_VALUE_PK2%TYPE) IS
704:
705: l_term_rec oke_term_pvt.term_rec_type;
706: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TERM';
707: l_api_version CONSTANT NUMBER := 1.0;

Line 853: FROM OKE_K_TERMS b

849: b.ATTRIBUTE12 ,
850: b.ATTRIBUTE13 ,
851: b.ATTRIBUTE14 ,
852: b.ATTRIBUTE15
853: FROM OKE_K_TERMS b
854: WHERE b.K_LINE_ID = p_id;
855:
856: CURSOR term_chr_csr (p_id IN NUMBER) IS
857: SELECT

Line 884: FROM OKE_K_TERMS b

880: b.ATTRIBUTE12 ,
881: b.ATTRIBUTE13 ,
882: b.ATTRIBUTE14 ,
883: b.ATTRIBUTE15
884: FROM OKE_K_TERMS b
885: WHERE (b.K_HEADER_ID = p_id) AND (b.K_LINE_ID IS NULL);
886:
887:
888: BEGIN