eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SETUP_PRD_PRCTEMPL_PVT dependencies on OKL_PRD_PRICE_TMPLS

Line 22: -- PROCEDURE get_rec for: OKL_PRD_PRICE_TMPLS_V

18: RETURN l_boolean_char;
19: END BOOLEAN_TO_CHAR;
20:
21: ---------------------------------------------------------------------------
22: -- PROCEDURE get_rec for: OKL_PRD_PRICE_TMPLS_V
23: ---------------------------------------------------------------------------
24: PROCEDURE get_rec (
25: p_pitv_rec IN pitv_rec_type,
26: x_return_status OUT NOCOPY VARCHAR2,

Line 46: FROM OKL_PRD_PRICE_TMPLS

42: CREATION_DATE,
43: LAST_UPDATED_BY,
44: LAST_UPDATE_DATE,
45: LAST_UPDATE_LOGIN
46: FROM OKL_PRD_PRICE_TMPLS
47: WHERE OKL_PRD_PRICE_TMPLS.id = p_id;
48:
49: l_okl_pitv_pk okl_pit_pk_csr%ROWTYPE;
50: l_pitv_rec pitv_rec_type;

Line 47: WHERE OKL_PRD_PRICE_TMPLS.id = p_id;

43: LAST_UPDATED_BY,
44: LAST_UPDATE_DATE,
45: LAST_UPDATE_LOGIN
46: FROM OKL_PRD_PRICE_TMPLS
47: WHERE OKL_PRD_PRICE_TMPLS.id = p_id;
48:
49: l_okl_pitv_pk okl_pit_pk_csr%ROWTYPE;
50: l_pitv_rec pitv_rec_type;
51: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 168: -- PROCEDURE determine_action for: OKL_PRD_PRICE_TMPLS_V

164:
165: END get_changes_only;
166:
167: ---------------------------------------------------------------------------
168: -- PROCEDURE determine_action for: OKL_PRD_PRICE_TMPLS_V
169: -- This function helps in determining the various checks to be performed
170: -- for the new/updated record and also helps in determining whether a new
171: -- version is required or not
172: ---------------------------------------------------------------------------

Line 212: -- PROCEDURE check_constraints for: OKL_PRD_PRICE_TMPLS_V

208: RETURN(l_action);
209: END determine_action;
210:
211: ---------------------------------------------------------------------------
212: -- PROCEDURE check_constraints for: OKL_PRD_PRICE_TMPLS_V
213: -- To verify whether the dates are valid for both Pricing Template and Products
214: -- attached to it
215: ---------------------------------------------------------------------------
216: PROCEDURE check_constraints (

Line 332: p_view => 'OKL_PRD_PRICE_TMPLS_V',

328: p_start_date_attribute_name => 'START_DATE',
329: p_start_date => l_pitv_rec.start_date,
330: p_end_date_attribute_name => 'END_DATE',
331: p_end_date => l_pitv_rec.end_date,
332: p_view => 'OKL_PRD_PRICE_TMPLS_V',
333: x_return_status => l_return_status,
334: x_valid => l_valid);
335: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
336: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 382: -- PROCEDURE insert_prd_price_tmpls for: OKL_PRD_PRICE_TMPLS_V

378:
379: END check_updates;
380:
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,

Line 439: okl_prd_price_tmpls_pub.insert_prd_price_tmpls(p_api_version => p_api_version,

435: RAISE G_EXCEPTION_ERROR;
436: END IF;
437:
438: /* public api to insert pricing template*/
439: okl_prd_price_tmpls_pub.insert_prd_price_tmpls(p_api_version => p_api_version,
440: p_init_msg_list => p_init_msg_list,
441: x_return_status => l_return_status,
442: x_msg_count => x_msg_count,
443: x_msg_data => x_msg_data,

Line 472: -- PROCEDURE update_prd_price_tmpls for: OKL_PRD_PRICE_TMPLS_V

468: x_return_status := G_RET_STS_UNEXP_ERROR;
469: END insert_prd_price_tmpls;
470:
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,

Line 487: FROM OKL_PRD_PRICE_TMPLS

483: CURSOR l_okl_pitv_pk_csr (p_id IN NUMBER) IS
484: SELECT
485: START_DATE,
486: END_DATE
487: FROM OKL_PRD_PRICE_TMPLS
488: WHERE OKL_PRD_PRICE_TMPLS.id = p_id;
489:
490: l_api_version CONSTANT NUMBER := 1;
491: l_api_name CONSTANT VARCHAR2(30) := 'update_stream_type';

Line 488: WHERE OKL_PRD_PRICE_TMPLS.id = p_id;

484: SELECT
485: START_DATE,
486: END_DATE
487: FROM OKL_PRD_PRICE_TMPLS
488: WHERE OKL_PRD_PRICE_TMPLS.id = p_id;
489:
490: l_api_version CONSTANT NUMBER := 1;
491: l_api_name CONSTANT VARCHAR2(30) := 'update_stream_type';
492: l_no_data_found BOOLEAN := TRUE;

Line 583: okl_prd_price_tmpls_pub.update_prd_price_tmpls(p_api_version => p_api_version,

579: END IF;
580:
581:
582: -- public api to update_prd_price_tmpls
583: okl_prd_price_tmpls_pub.update_prd_price_tmpls(p_api_version => p_api_version,
584: p_init_msg_list => p_init_msg_list,
585: x_return_status => l_return_status,
586: x_msg_count => x_msg_count,
587: x_msg_data => x_msg_data,

Line 685: okl_prd_price_tmpls_pub.update_prd_price_tmpls(p_api_version => p_api_version,

681:
682: -- Scenario 1: The Changed Field-Values can by-pass Validation *
683: IF l_action = '1' THEN
684: -- public api to update_stream_type *
685: okl_prd_price_tmpls_pub.update_prd_price_tmpls(p_api_version => p_api_version,
686: p_init_msg_list => p_init_msg_list,
687: x_return_status => l_return_status,
688: x_msg_count => x_msg_count,
689: x_msg_data => x_msg_data,

Line 712: okl_prd_price_tmpls_pub.update_prd_price_tmpls(p_api_version => p_api_version,

708: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
709: END IF;
710:
711: -- public api to update Pricing Template *
712: okl_prd_price_tmpls_pub.update_prd_price_tmpls(p_api_version => p_api_version,
713: p_init_msg_list => p_init_msg_list,
714: x_return_status => l_return_status,
715: x_msg_count => x_msg_count,
716: x_msg_data => x_msg_data,

Line 769: okl_prd_price_tmpls_pub.update_prd_price_tmpls(p_api_version => p_api_version,

765: END IF;
766: END IF;
767:
768: -- public api to update formulae
769: okl_prd_price_tmpls_pub.update_prd_price_tmpls(p_api_version => p_api_version,
770: p_init_msg_list => p_init_msg_list,
771: x_return_status => l_return_status,
772: x_msg_count => x_msg_count,
773: x_msg_data => x_msg_data,

Line 802: p_view => 'OKL_PRD_PRICE_TMPLS_V',

798: p_attrib_tbl => l_attrib_tbl,
799: p_cur_version => l_pitv_rec.version,
800: p_end_date_attribute_name => 'END_DATE',
801: p_end_date => l_pitv_rec.end_date,
802: p_view => 'OKL_PRD_PRICE_TMPLS_V',
803: x_return_status => l_return_status,
804: x_new_version => l_new_version);
805:
806: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 828: okl_prd_price_tmpls_pub.insert_prd_price_tmpls(p_api_version => p_api_version,

824: END IF;
825: END IF;
826:
827: -- public api to insert stream type
828: okl_prd_price_tmpls_pub.insert_prd_price_tmpls(p_api_version => p_api_version,
829: p_init_msg_list => p_init_msg_list,
830: x_return_status => l_return_status,
831: x_msg_count => x_msg_count,
832: x_msg_data => x_msg_data,

Line 986: FROM OKL_PRD_PRICE_TMPLS

982: CREATION_DATE,
983: LAST_UPDATED_BY,
984: LAST_UPDATE_DATE,
985: NVL(LAST_UPDATE_LOGIN,G_MISS_NUM) LAST_UPDATE_LOGIN
986: FROM OKL_PRD_PRICE_TMPLS
987: WHERE OKL_PRD_PRICE_TMPLS.pdt_id = p_pdt_id;
988:
989: l_api_name CONSTANT VARCHAR2(30) := 'check_product_constraints';
990: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 987: WHERE OKL_PRD_PRICE_TMPLS.pdt_id = p_pdt_id;

983: LAST_UPDATED_BY,
984: LAST_UPDATE_DATE,
985: NVL(LAST_UPDATE_LOGIN,G_MISS_NUM) LAST_UPDATE_LOGIN
986: FROM OKL_PRD_PRICE_TMPLS
987: WHERE OKL_PRD_PRICE_TMPLS.pdt_id = p_pdt_id;
988:
989: l_api_name CONSTANT VARCHAR2(30) := 'check_product_constraints';
990: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
991: l_valid BOOLEAN := TRUE;