DBA Data[Home] [Help]

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 800: OKC_API.SET_MESSAGE( p_app_name => OKC_API.G_APP_NAME,

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

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

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

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

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

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

876: IF l_styv_rec.end_date IS NOT NULL
877: 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')
878: 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')
879: THEN
880: OKC_API.SET_MESSAGE( p_app_name => OKC_API.G_APP_NAME,
881: p_msg_name => G_INVALID_VALUE,
882: p_token1 => G_COL_NAME_TOKEN,
883: p_token1_value => 'END_DATE' );
884: END IF;

Line 1147: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1143: END update_stream_type;
1144:
1145: PROCEDURE create_stream_type(
1146: p_api_version IN NUMBER,
1147: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1148: x_return_status OUT NOCOPY VARCHAR2,
1149: x_msg_count OUT NOCOPY NUMBER,
1150: x_msg_data OUT NOCOPY VARCHAR2,
1151: p_styv_tbl IN styv_tbl_type,

Line 1198: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1194:
1195:
1196: PROCEDURE update_stream_type(
1197: p_api_version IN NUMBER,
1198: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1199: x_return_status OUT NOCOPY VARCHAR2,
1200: x_msg_count OUT NOCOPY NUMBER,
1201: x_msg_data OUT NOCOPY VARCHAR2,
1202: p_styv_tbl IN styv_tbl_type,