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.OKS_MASS_UPD_PVT dependencies on OKS_MASS_UPD_PVT

Line 1: PACKAGE BODY OKS_MASS_UPD_PVT AS

1: PACKAGE BODY OKS_MASS_UPD_PVT AS
2: /* $Header: OKSRMUSB.pls 120.0.12020000.2 2013/02/06 09:19:24 spingali noship $ */
3:
4: --========================================================================
5: -- PROCEDURE : DELETE_CONTRACT_DATA

Line 41: l_mass_update_status_tbl oks_mass_upd_pvt.mass_update_status_tbl;

37: PROCEDURE vld_massupd_status_prc(p_contract_id IN VARCHAR2,
38: x_return_status out nocopy varchar2) IS
39: -- PRAGMA autonomous_transaction;
40:
41: l_mass_update_status_tbl oks_mass_upd_pvt.mass_update_status_tbl;
42:
43: CURSOR get_stecode(p_sts_code VARCHAR2) IS
44: select ste_code from okc_statuses_b where code = p_sts_code;
45:

Line 50: l_api_name VARCHAR2(100) := 'oks_mass_upd_pvt.vld_massupd_status_prc';

46: l_return_status VARCHAR2(10);
47: l_old_ste_code VARCHAR2(100);
48: l_new_ste_code VARCHAR2(100);
49: l_valid_status VARCHAR2(100);
50: l_api_name VARCHAR2(100) := 'oks_mass_upd_pvt.vld_massupd_status_prc';
51:
52: FUNCTION check_ste_code(p_old_ste_code IN VARCHAR2,
53: p_new_ste_code IN VARCHAR) RETURN VARCHAR2 IS
54:

Line 244: l_mass_update_eff_tbl oks_mass_upd_pvt.mass_update_effectivity_tbl;

240: /*validate the effectivity change related data*/
241: PROCEDURE vld_massupd_eff_prc(p_contract_id IN VARCHAR2,
242: x_return_status out nocopy varchar2) IS
243: --PRAGMA autonomous_transaction;
244: l_mass_update_eff_tbl oks_mass_upd_pvt.mass_update_effectivity_tbl;
245: l_k_start_date DATE;
246: l_k_end_date DATE;
247: l_kl_start_date DATE;
248: l_kl_end_date DATE;

Line 563: l_mu_price_tbl OKS_MASS_UPD_PVT.mass_update_price_tbl;

559: l_api_version CONSTANT NUMBER := 1.0;
560: l_init_msg_list CONSTANT VARCHAR2(1) := 'T';
561: l_msg_index_out NUMBER;
562:
563: l_mu_price_tbl OKS_MASS_UPD_PVT.mass_update_price_tbl;
564: l_authoring_org_id NUMBER;
565: l_inv_org_id NUMBER;
566: l_input_details OKS_QP_PKG.INPUT_DETAILS;
567: l_output_details OKS_QP_PKG.PRICE_DETAILS;

Line 958: l_mass_update_price_tbl oks_mass_upd_pvt.mass_update_price_tbl;

954: x_return_status out nocopy varchar2) IS
955:
956: --x_return_status VARCHAR2(1);
957:
958: l_mass_update_price_tbl oks_mass_upd_pvt.mass_update_price_tbl;
959: x_msg_data VARCHAR2(1000);
960: x_msg_count NUMBER;
961:
962: begin

Line 1014: l_mass_update_status_tbl oks_mass_upd_pvt.mass_update_status_tbl;

1010: procedure mass_update_status_wrapper(p_contract_id IN VARCHAR2,
1011: x_return_status out nocopy varchar2) IS
1012: --x_return_status VARCHAR2(1);
1013:
1014: l_mass_update_status_tbl oks_mass_upd_pvt.mass_update_status_tbl;
1015: x_msg_data VARCHAR2(1000);
1016: x_msg_count NUMBER;
1017: l_count NUMBER := 0;
1018:

Line 1133: l_mass_update_eff_tbl oks_mass_upd_pvt.mass_update_effectivity_tbl;

1129: procedure mass_update_eff_wrapper(p_contract_id IN VARCHAR2,
1130: x_return_status out nocopy varchar2) IS
1131: --x_return_status VARCHAR2(1);
1132:
1133: l_mass_update_eff_tbl oks_mass_upd_pvt.mass_update_effectivity_tbl;
1134: --l_mass_update_eff_tbl_err oks_mass_upd_pvt.mass_update_effectivity_tbl;
1135: l_count NUMBER := 0;
1136: BEGIN
1137:

Line 1134: --l_mass_update_eff_tbl_err oks_mass_upd_pvt.mass_update_effectivity_tbl;

1130: x_return_status out nocopy varchar2) IS
1131: --x_return_status VARCHAR2(1);
1132:
1133: l_mass_update_eff_tbl oks_mass_upd_pvt.mass_update_effectivity_tbl;
1134: --l_mass_update_eff_tbl_err oks_mass_upd_pvt.mass_update_effectivity_tbl;
1135: l_count NUMBER := 0;
1136: BEGIN
1137:
1138: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

Line 1297: p_lines_tbl OKS_MASS_UPD_PVT.mass_update_status_tbl;

1293: l_new_ste_code varchar2(100);
1294: l_old_ste_code varchar2(100);
1295: l_api_name Varchar2(100) := 'Mass_Update_Status_prc';
1296: i NUMBER;
1297: p_lines_tbl OKS_MASS_UPD_PVT.mass_update_status_tbl;
1298: x_overall_status VARCHAR2(1);
1299: l_error_count NUMBER := 0;
1300: l_EXC_ERROR EXCEPTION;
1301:

Line 1694: l_api_name VARCHAR2(150) := 'oks_mass_upd_pvt.check_new_line_effectivity';

1690: p_end_date IN DATE,
1691: exception_yn OUT NOCOPY VARCHAR2) IS
1692: l_k_start_date DATE;
1693: l_k_end_date DATE;
1694: l_api_name VARCHAR2(150) := 'oks_mass_upd_pvt.check_new_line_effectivity';
1695: --l_err_mu_eff_tbl err_mu_eff_tbl;
1696: BEGIN
1697: exception_yn := 'N'; -- Defaulting value
1698: fnd_file.put_line (fnd_file.log, l_api_name || ', Checking Contract Line Effectivity for line number: ' || p_line_number);

Line 1766: l_api_name VARCHAR2(150) := 'oks_mass_upd_pvt.check_new_subline_effectivity';

1762: l_k_end_date DATE;
1763: l_kl_start_date DATE;
1764: l_kl_end_date DATE;
1765: l_chr_id NUMBER;
1766: l_api_name VARCHAR2(150) := 'oks_mass_upd_pvt.check_new_subline_effectivity';
1767: --l_err_mu_eff_tbl err_mu_eff_tbl;
1768:
1769: BEGIN
1770: exception_yn := 'N'; -- Defaulting value

Line 1857: l_api_name VARCHAR2(100) := 'oks_mass_upd_pvt.mass_update_effectivity_prc';

1853:
1854: procedure mass_update_effectivity_prc(p_mass_update_effectivity_tbl in mass_update_effectivity_tbl,
1855: x_return_status out nocopy varchar2) IS
1856: l_api_version CONSTANT NUMBER := 1.0;
1857: l_api_name VARCHAR2(100) := 'oks_mass_upd_pvt.mass_update_effectivity_prc';
1858: l_init_msg_list CONSTANT VARCHAR2(1) := 'T';
1859: l_return_status VARCHAR2(1);
1860: l_msg_count NUMBER;
1861: l_msg_data VARCHAR2(2000);

Line 3740: END OKS_MASS_UPD_PVT;

3736: COMMIT;
3737:
3738: END delete_changes;
3739:
3740: END OKS_MASS_UPD_PVT;