APPS.OKL_SETUP_PRD_PRCTEMPL_PVT dependencies on OKC_API

Line 249: OR l_pitv_rec.end_date = OKC_API.G_MISS_DATE

245:
246: --Check END_DATE
247: IF l_pdt_rec.TO_DATE IS NOT NULL THEN
248: IF l_pitv_rec.end_date IS NULL
249: OR l_pitv_rec.end_date = OKC_API.G_MISS_DATE
250: THEN
251: l_valid := FALSE;
252: ELSIF l_pitv_rec.end_date > l_pdt_rec.TO_DATE
253: THEN

Line 385: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

381: ---------------------------------------------------------------------------
382: -- PROCEDURE insert_prd_price_tmpls for: OKL_PRD_PRICE_TMPLS_V
383: ---------------------------------------------------------------------------
384: PROCEDURE insert_prd_price_tmpls( p_api_version IN NUMBER,
385: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
386: x_return_status OUT NOCOPY VARCHAR2,
387: x_msg_count OUT NOCOPY NUMBER,
388: x_msg_data OUT NOCOPY VARCHAR2,
389: p_pitv_rec IN pitv_rec_type,

Line 475: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

471: ---------------------------------------------------------------------------
472: -- PROCEDURE update_prd_price_tmpls for: OKL_PRD_PRICE_TMPLS_V
473: ---------------------------------------------------------------------------
474: PROCEDURE update_prd_price_tmpls(p_api_version IN NUMBER,
475: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
476: x_return_status OUT NOCOPY VARCHAR2,
477: x_msg_count OUT NOCOPY NUMBER,
478: x_msg_data OUT NOCOPY VARCHAR2,
479: p_pitv_rec IN pitv_rec_type,

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

523: THEN
524: /*
525: ** 25-Oct-2004 vthiruva -- Fix for Bug#3944026 end
526: */
527: OKC_API.SET_MESSAGE( p_app_name => OKC_API.G_APP_NAME,
528: p_msg_name => G_INVALID_VALUE,
529: p_token1 => G_COL_NAME_TOKEN,
530: p_token1_value => 'END_DATE' );
531: RAISE G_EXCEPTION_ERROR;

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

554: THEN
555: /*
556: ** 25-Oct-2004 vthiruva -- Fix for Bug#3944026 end
557: */
558: OKC_API.SET_MESSAGE( p_app_name => OKC_API.G_APP_NAME,
559: p_msg_name => G_INVALID_VALUE,
560: p_token1 => G_COL_NAME_TOKEN,
561: p_token1_value => 'START_DATE' );
562: RAISE G_EXCEPTION_ERROR;

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

603: IF l_pitv_rec.end_date IS NOT NULL
604: AND TO_DATE(l_pitv_rec.end_date, 'DD/MM/YYYY') <> TO_DATE(G_MISS_DATE, 'DD/MM/YYYY')
605: AND TO_DATE(l_pitv_rec.end_date, 'DD/MM/YYYY') < TO_DATE(l_pitv_rec.start_date, 'DD/MM/YYYY')
606: THEN
607: OKC_API.SET_MESSAGE( p_app_name => OKC_API.G_APP_NAME,
608: p_msg_name => G_INVALID_VALUE,
609: p_token1 => G_COL_NAME_TOKEN,
610: p_token1_value => 'END_DATE' );
611: END IF;

Line 869: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

865: END update_prd_price_tmpls;
866:
867: PROCEDURE insert_prd_price_tmpls(
868: p_api_version IN NUMBER,
869: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
870: x_return_status OUT NOCOPY VARCHAR2,
871: x_msg_count OUT NOCOPY NUMBER,
872: x_msg_data OUT NOCOPY VARCHAR2,
873: p_pitv_tbl IN pitv_tbl_type,

Line 917: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

913:
914:
915: PROCEDURE update_prd_price_tmpls(
916: p_api_version IN NUMBER,
917: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
918: x_return_status OUT NOCOPY VARCHAR2,
919: x_msg_count OUT NOCOPY NUMBER,
920: x_msg_data OUT NOCOPY VARCHAR2,
921: p_pitv_tbl IN pitv_tbl_type,

Line 963: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

959: END update_prd_price_tmpls;
960:
961: PROCEDURE check_product_constraints(
962: p_api_version IN NUMBER,
963: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
964: x_return_status OUT NOCOPY VARCHAR2,
965: x_msg_count OUT NOCOPY NUMBER,
966: x_msg_data OUT NOCOPY VARCHAR2,
967: p_pdtv_rec IN pdtv_rec_type,

Line 1050: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1046: END check_product_constraints;
1047:
1048: PROCEDURE check_product_constraints(
1049: p_api_version IN NUMBER,
1050: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1051: x_return_status OUT NOCOPY VARCHAR2,
1052: x_msg_count OUT NOCOPY NUMBER,
1053: x_msg_data OUT NOCOPY VARCHAR2,
1054: p_pdtv_tbl IN pdtv_tbl_type,