DBA Data[Home] [Help]

APPS.OKC_SAM_PVT dependencies on OKC_UTIL

Line 210: -- OKC_UTIL.check_comp_unique call is replaced with

206: AND (p_samv_rec.sat_code <> OKC_API.G_MISS_CHAR) )
207: THEN
208: -- ---------------------------------------------------------------------
209: -- Bug 1636056 related changes - Shyam
210: -- OKC_UTIL.check_comp_unique call is replaced with
211: -- the explicit cursors above, for identical function to
212: -- check uniqueness for SAE_ID + SAT_CODE in OKC_STD_ART_SET_MEMS_V
213: -- ---------------------------------------------------------------------
214: OPEN cur_sam;

Line 396: x_return_status:=OKC_UTIL.check_lookup_code('OKC_ARTICLE_SET',p_samv_rec.sat_code);

392: End If;
393:
394:
395: -- Check if the value is valid code from lookup table for OKC_ARTICLE_SET
396: x_return_status:=OKC_UTIL.check_lookup_code('OKC_ARTICLE_SET',p_samv_rec.sat_code);
397: If (x_return_status=OKC_API.G_RET_STS_ERROR) Then
398: --set error message in message stack
399: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
400: p_msg_name => G_INVALID_VALUE,

Line 811: l_unq OKC_UTIL.unq_tbl_type;

807: l_def_samv_rec samv_rec_type;
808: l_sam_rec sam_rec_type;
809: lx_sam_rec sam_rec_type;
810: /****************ADDED AFTER TAPI**************/
811: l_unq OKC_UTIL.unq_tbl_type;
812: /****************END ADDED AFTER TAPI**************/
813:
814: -------------------------------
815: -- FUNCTION fill_who_columns --