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_PRCPARAMS_PVT dependencies on OKL_SIF_PRICE_PARMS

Line 5: -- PROCEDURE get_rec for: OKL_SIF_PRICE_PARMS_V

1: PACKAGE BODY OKL_SETUP_PRCPARAMS_PVT AS
2: /* $Header: OKLRPPRB.pls 115.1 2004/07/02 02:56:28 sgorantl noship $ */
3:
4: ---------------------------------------------------------------------------
5: -- PROCEDURE get_rec for: OKL_SIF_PRICE_PARMS_V
6: -- modified by smahapat 01-16-2002
7: ---------------------------------------------------------------------------
8: PROCEDURE get_rec (
9: p_sppv_rec IN sppv_rec_type,

Line 47: -- start change smahapat 01/11/02 - replace OKL_SIF_PRICE_PARMS_V by OKL_SIF_PRICE_PARMS

43: LAST_UPDATED_BY,
44: CREATION_DATE,
45: LAST_UPDATE_DATE,
46: NVL(LAST_UPDATE_LOGIN,G_MISS_NUM) LAST_UPDATE_LOGIN
47: -- start change smahapat 01/11/02 - replace OKL_SIF_PRICE_PARMS_V by OKL_SIF_PRICE_PARMS
48: FROM OKL_SIF_PRICE_PARMS
49: WHERE OKL_SIF_PRICE_PARMS.id = p_id;
50: -- end change smahapat
51:

Line 48: FROM OKL_SIF_PRICE_PARMS

44: CREATION_DATE,
45: LAST_UPDATE_DATE,
46: NVL(LAST_UPDATE_LOGIN,G_MISS_NUM) LAST_UPDATE_LOGIN
47: -- start change smahapat 01/11/02 - replace OKL_SIF_PRICE_PARMS_V by OKL_SIF_PRICE_PARMS
48: FROM OKL_SIF_PRICE_PARMS
49: WHERE OKL_SIF_PRICE_PARMS.id = p_id;
50: -- end change smahapat
51:
52: l_okl_sppv_pk okl_sppv_pk_csr%ROWTYPE;

Line 49: WHERE OKL_SIF_PRICE_PARMS.id = p_id;

45: LAST_UPDATE_DATE,
46: NVL(LAST_UPDATE_LOGIN,G_MISS_NUM) LAST_UPDATE_LOGIN
47: -- start change smahapat 01/11/02 - replace OKL_SIF_PRICE_PARMS_V by OKL_SIF_PRICE_PARMS
48: FROM OKL_SIF_PRICE_PARMS
49: WHERE OKL_SIF_PRICE_PARMS.id = p_id;
50: -- end change smahapat
51:
52: l_okl_sppv_pk okl_sppv_pk_csr%ROWTYPE;
53: l_sppv_rec sppv_rec_type;

Line 119: -- PROCEDURE get_changes_only for: OKL_SIF_PRICE_PARMS_V

115: END get_rec;
116:
117:
118: ---------------------------------------------------------------------------
119: -- PROCEDURE get_changes_only for: OKL_SIF_PRICE_PARMS_V
120: -- To take care of the assumption that Everything except the Changed Fields
121: -- have G_MISS values in them
122: -- added by smahapat 01-16-2002
123: ---------------------------------------------------------------------------

Line 304: -- PROCEDURE determine_action for: OKL_SIF_PRICE_PARMS_V

300: x_sppv_rec := l_sppv_rec;
301: END get_changes_only;
302:
303: ---------------------------------------------------------------------------
304: -- PROCEDURE determine_action for: OKL_SIF_PRICE_PARMS_V
305: -- This function helps in determining the various checks to be performed
306: -- for the new/updated record and also helps in determining whether a new
307: -- version is required or not
308: ---------------------------------------------------------------------------

Line 382: p_view => 'OKL_SIF_PRICE_PARMS_V',

378: p_start_date_attribute_name => 'DATE_START',
379: p_start_date => l_sppv_rec.date_start,
380: p_end_date_attribute_name => 'DATE_END',
381: p_end_date => l_sppv_rec.date_end,
382: p_view => 'OKL_SIF_PRICE_PARMS_V',
383: x_return_status => l_return_status,
384: x_valid => l_valid);
385:
386: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 416: -- PROCEDURE create_price_parm for: OKL_SIF_PRICE_PARMS_V

412:
413: END check_updates;
414:
415: ---------------------------------------------------------------------------
416: -- PROCEDURE create_price_parm for: OKL_SIF_PRICE_PARMS_V
417: ---------------------------------------------------------------------------
418: PROCEDURE create_price_parm( p_api_version IN NUMBER,
419: p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE,
420: p_sppv_rec IN sppv_rec_type,

Line 454: okl_sif_price_parms_pub.insert_sif_price_parms(p_api_version => p_api_version,

450: END IF;
451: */
452:
453: /* public api to insert_sif_price_parms */
454: okl_sif_price_parms_pub.insert_sif_price_parms(p_api_version => p_api_version,
455: p_init_msg_list => p_init_msg_list,
456: x_return_status => l_return_status,
457: x_msg_count => x_msg_count,
458: x_msg_data => x_msg_data,

Line 488: -- PROCEDURE update_price_parm for: OKL_SIF_PRICE_PARMS_V

484: x_return_status := G_RET_STS_UNEXP_ERROR;
485: END create_price_parm;
486:
487: ---------------------------------------------------------------------------
488: -- PROCEDURE update_price_parm for: OKL_SIF_PRICE_PARMS_V
489: ---------------------------------------------------------------------------
490: PROCEDURE update_price_parm(p_api_version IN NUMBER,
491: p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE,
492: p_sppv_rec IN sppv_rec_type,

Line 504: FROM OKL_SIF_PRICE_PARMS

500: CURSOR l_okl_sppv_pk_csr (p_id IN NUMBER) IS
501: SELECT
502: DATE_START,
503: DATE_END
504: FROM OKL_SIF_PRICE_PARMS
505: WHERE OKL_SIF_PRICE_PARMS.id = p_id;
506:
507: l_api_version CONSTANT NUMBER := 1;
508: l_api_name CONSTANT VARCHAR2(30) := 'update_price_parm';

Line 505: WHERE OKL_SIF_PRICE_PARMS.id = p_id;

501: SELECT
502: DATE_START,
503: DATE_END
504: FROM OKL_SIF_PRICE_PARMS
505: WHERE OKL_SIF_PRICE_PARMS.id = p_id;
506:
507: l_api_version CONSTANT NUMBER := 1;
508: l_api_name CONSTANT VARCHAR2(30) := 'update_price_parm';
509: l_no_data_found BOOLEAN := TRUE;

Line 567: okl_sif_price_parms_pub.update_sif_price_parms(p_api_version => p_api_version,

563: END IF;
564:
565:
566: -- public api to update_price_parm
567: okl_sif_price_parms_pub.update_sif_price_parms(p_api_version => p_api_version,
568: p_init_msg_list => p_init_msg_list,
569: x_return_status => l_return_status,
570: x_msg_count => x_msg_count,
571: x_msg_data => x_msg_data,

Line 669: okl_sif_price_parms_pub.update_sif_price_parms(p_api_version => p_api_version,

665: p_date => l_sysdate);
666: -- Scenario 1: The Changed Field-Values can by-pass Validation *
667: IF l_action = '1' THEN
668: -- public api to update_price_parm *
669: okl_sif_price_parms_pub.update_sif_price_parms(p_api_version => p_api_version,
670: p_init_msg_list => p_init_msg_list,
671: x_return_status => l_return_status,
672: x_msg_count => x_msg_count,
673: x_msg_data => x_msg_data,

Line 698: okl_sif_price_parms_pub.update_sif_price_parms(p_api_version => p_api_version,

694: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
695: END IF;
696:
697: -- public api to update price parms
698: okl_sif_price_parms_pub.update_sif_price_parms(p_api_version => p_api_version,
699: p_init_msg_list => p_init_msg_list,
700: x_return_status => l_return_status,
701: x_msg_count => x_msg_count,
702: x_msg_data => x_msg_data,

Line 753: okl_sif_price_parms_pub.update_sif_price_parms(p_api_version => p_api_version,

749: END IF;
750: END IF;
751:
752: -- public api to update formulae
753: okl_sif_price_parms_pub.update_sif_price_parms(p_api_version => p_api_version,
754: p_init_msg_list => p_init_msg_list,
755: x_return_status => l_return_status,
756: x_msg_count => x_msg_count,
757: x_msg_data => x_msg_data,

Line 790: p_view => 'OKL_SIF_PRICE_PARMS_V',

786: p_attrib_tbl => l_attrib_tbl,
787: p_cur_version => l_sppv_rec.version,
788: p_end_date_attribute_name => 'DATE_END',
789: p_end_date => l_sppv_rec.date_end,
790: p_view => 'OKL_SIF_PRICE_PARMS_V',
791: x_return_status => l_return_status,
792: x_new_version => l_new_version);
793:
794: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 815: okl_sif_price_parms_pub.insert_sif_price_parms(p_api_version => p_api_version,

811: END IF;
812: END IF;
813:
814: -- public api to insert price parms
815: okl_sif_price_parms_pub.insert_sif_price_parms(p_api_version => p_api_version,
816: p_init_msg_list => p_init_msg_list,
817: x_return_status => l_return_status,
818: x_msg_count => x_msg_count,
819: x_msg_data => x_msg_data,