APPS.OKL_SETUP_STREAMTYPES_PVT dependencies on OKC_API

Line 665: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

661: ---------------------------------------------------------------------------
662: -- PROCEDURE create_stream_type for: OKL_STRM_TYPE_V
663: ---------------------------------------------------------------------------
664: PROCEDURE create_stream_type( p_api_version IN NUMBER,
665: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
666: x_return_status OUT NOCOPY VARCHAR2,
667: x_msg_count OUT NOCOPY NUMBER,
668: x_msg_data OUT NOCOPY VARCHAR2,
669: p_styv_rec IN styv_rec_type,

Line 745: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

741: ---------------------------------------------------------------------------
742: -- PROCEDURE update_stream_type for: OKL_STRM_TYPE_V
743: ---------------------------------------------------------------------------
744: PROCEDURE update_stream_type(p_api_version IN NUMBER,
745: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
746: x_return_status OUT NOCOPY VARCHAR2,
747: x_msg_count OUT NOCOPY NUMBER,
748: x_msg_data OUT NOCOPY VARCHAR2,
749: p_styv_rec IN styv_rec_type,

Line 804: OKC_API.SET_MESSAGE( p_app_name => OKC_API.G_APP_NAME,

800: THEN
801: /*
802: ** 25-Oct-2004 vthiruva -- Fix for Bug#3731453 end
803: */
804: OKC_API.SET_MESSAGE( p_app_name => OKC_API.G_APP_NAME,
805: p_msg_name => G_INVALID_VALUE,
806: p_token1 => G_COL_NAME_TOKEN,
807: p_token1_value => 'END_DATE' );
808: RAISE G_EXCEPTION_ERROR;

Line 833: OKC_API.SET_MESSAGE( p_app_name => OKC_API.G_APP_NAME,

829: ( to_date(to_char(l_db_styv_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') <= l_sysdate
830: OR to_date(to_char(l_styv_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate
831: )
832: THEN
833: OKC_API.SET_MESSAGE( p_app_name => OKC_API.G_APP_NAME,
834: p_msg_name => G_INVALID_VALUE,
835: p_token1 => G_COL_NAME_TOKEN,
836: p_token1_value => 'START_DATE' );
837: RAISE G_EXCEPTION_ERROR;

Line 852: OKC_API.SET_MESSAGE( p_app_name => OKC_API.G_APP_NAME,

848: THEN
849: /*
850: ** 25-Oct-2004 vthiruva -- Fix for Bug#3731453 end
851: */
852: OKC_API.SET_MESSAGE( p_app_name => OKC_API.G_APP_NAME,
853: p_msg_name => G_INVALID_VALUE,
854: p_token1 => G_COL_NAME_TOKEN,
855: p_token1_value => 'START_DATE' );
856: RAISE G_EXCEPTION_ERROR;

Line 884: OKC_API.SET_MESSAGE( p_app_name => OKC_API.G_APP_NAME,

880: IF l_styv_rec.end_date IS NOT NULL
881: AND to_date(to_char(l_styv_rec.end_date,'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(G_MISS_DATE,'DD/MM/YYYY'), 'DD/MM/YYYY')
882: AND to_date(to_char(l_styv_rec.end_date,'DD/MM/YYYY'), 'DD/MM/YYYY') < to_date(to_char(l_styv_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY')
883: THEN
884: OKC_API.SET_MESSAGE( p_app_name => OKC_API.G_APP_NAME,
885: p_msg_name => G_INVALID_VALUE,
886: p_token1 => G_COL_NAME_TOKEN,
887: p_token1_value => 'END_DATE' );
888: END IF;

Line 1151: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1147: END update_stream_type;
1148:
1149: PROCEDURE create_stream_type(
1150: p_api_version IN NUMBER,
1151: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1152: x_return_status OUT NOCOPY VARCHAR2,
1153: x_msg_count OUT NOCOPY NUMBER,
1154: x_msg_data OUT NOCOPY VARCHAR2,
1155: p_styv_tbl IN styv_tbl_type,

Line 1202: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1198:
1199:
1200: PROCEDURE update_stream_type(
1201: p_api_version IN NUMBER,
1202: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1203: x_return_status OUT NOCOPY VARCHAR2,
1204: x_msg_count OUT NOCOPY NUMBER,
1205: x_msg_data OUT NOCOPY VARCHAR2,
1206: p_styv_tbl IN styv_tbl_type,