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_TXL_ITM_INSTS_PVT dependencies on OKL_TXL_ITM_INSTS

Line 1: package body OKL_TXL_ITM_INSTS_PVT as

1: package body OKL_TXL_ITM_INSTS_PVT as
2: /* $Header: OKLCITIB.pls 120.6 2005/10/30 04:03:39 appldev noship $ */
3:
4: /*
5: * sjalasut: aug 18, 04 added constants used in raising business event. BEGIN

Line 40: p_ser_num IN okl_txl_itm_insts.serial_number%TYPE,

36: PROCEDURE raise_business_event(p_api_version IN NUMBER,
37: p_init_msg_list IN VARCHAR2,
38: p_chr_id IN okc_k_headers_b.id%TYPE,
39: p_asset_id IN okc_k_lines_b.id%TYPE,
40: p_ser_num IN okl_txl_itm_insts.serial_number%TYPE,
41: p_event_name IN VARCHAR2,
42: x_return_status OUT NOCOPY VARCHAR2,
43: x_msg_count OUT NOCOPY NUMBER,
44: x_msg_data OUT NOCOPY VARCHAR2

Line 385: CURSOR get_serial_num(p_id okl_txl_itm_insts.id%TYPE) IS

381: FROM okc_k_lines_b cle
382: WHERE cle.id = p_kle_id;
383: --vthiruva..09-Dec-2004..Added code to enable Business Events..START
384: --cursor to fetch the serial number of the item instance record being updated
385: CURSOR get_serial_num(p_id okl_txl_itm_insts.id%TYPE) IS
386: SELECT serial_number, dnz_cle_id
387: FROM okl_txl_itm_insts
388: WHERE id = p_id;
389:

Line 387: FROM okl_txl_itm_insts

383: --vthiruva..09-Dec-2004..Added code to enable Business Events..START
384: --cursor to fetch the serial number of the item instance record being updated
385: CURSOR get_serial_num(p_id okl_txl_itm_insts.id%TYPE) IS
386: SELECT serial_number, dnz_cle_id
387: FROM okl_txl_itm_insts
388: WHERE id = p_id;
389:
390: l_old_serial_num okl_txl_itm_insts.serial_number%TYPE;
391: l_asset_id okl_txl_itm_insts.dnz_cle_id%TYPE;

Line 390: l_old_serial_num okl_txl_itm_insts.serial_number%TYPE;

386: SELECT serial_number, dnz_cle_id
387: FROM okl_txl_itm_insts
388: WHERE id = p_id;
389:
390: l_old_serial_num okl_txl_itm_insts.serial_number%TYPE;
391: l_asset_id okl_txl_itm_insts.dnz_cle_id%TYPE;
392: --vthiruva..09-Dec-2004..Added code to enable Business Events..END
393: BEGIN
394: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 391: l_asset_id okl_txl_itm_insts.dnz_cle_id%TYPE;

387: FROM okl_txl_itm_insts
388: WHERE id = p_id;
389:
390: l_old_serial_num okl_txl_itm_insts.serial_number%TYPE;
391: l_asset_id okl_txl_itm_insts.dnz_cle_id%TYPE;
392: --vthiruva..09-Dec-2004..Added code to enable Business Events..END
393: BEGIN
394: x_return_status := OKC_API.G_RET_STS_SUCCESS;
395: -- Call start_activity to create savepoint, check compatibility

Line 606: CURSOR get_chr_cle_id(p_inst_id okl_txl_itm_insts.id%TYPE) IS

602: /*
603: * sjalasut aug 18, 04: added cursor to derive the dnz_chr_id and dnz_cle_id
604: * from the item instance to pass the parameters to the business event. BEGIN
605: */
606: CURSOR get_chr_cle_id(p_inst_id okl_txl_itm_insts.id%TYPE) IS
607: SELECT lines.dnz_chr_id, items.dnz_cle_id, items.serial_number
608: FROM okc_k_lines_b lines, okl_txl_itm_insts items
609: WHERE items.id = p_inst_id
610: AND lines.id = items.dnz_cle_id;

Line 608: FROM okc_k_lines_b lines, okl_txl_itm_insts items

604: * from the item instance to pass the parameters to the business event. BEGIN
605: */
606: CURSOR get_chr_cle_id(p_inst_id okl_txl_itm_insts.id%TYPE) IS
607: SELECT lines.dnz_chr_id, items.dnz_cle_id, items.serial_number
608: FROM okc_k_lines_b lines, okl_txl_itm_insts items
609: WHERE items.id = p_inst_id
610: AND lines.id = items.dnz_cle_id;
611:
612: l_chr_id okc_k_headers_b.id%TYPE;

Line 614: l_ser_num okl_txl_itm_insts.serial_number%TYPE;

610: AND lines.id = items.dnz_cle_id;
611:
612: l_chr_id okc_k_headers_b.id%TYPE;
613: l_cle_id okc_k_lines_b.id%TYPE;
614: l_ser_num okl_txl_itm_insts.serial_number%TYPE;
615:
616: /*
617: * sjalasut aug 18, 04: added cursor to derive the dnz_chr_id and dnz_cle_id
618: * from the item instance to pass the parameters to the business event. EMD

Line 998: okl_txl_itm_insts txl

994: FROM okc_k_lines_b ff2,
995: okc_k_lines_b inst,
996: okc_line_styles_b ff2style,
997: okc_line_styles_b inststyle,
998: okl_txl_itm_insts txl
999: WHERE ff2.lse_id = ff2style.id
1000: AND ff2style.lty_code = 'FREE_FORM2'
1001: AND ff2.id = inst.cle_id
1002: AND inst.lse_id = inststyle.id

Line 1007: l_iivv_tbl okl_txl_itm_insts_pvt.iivv_tbl_type;

1003: AND inststyle.lty_code = 'INST_ITEM'
1004: AND txl.kle_id = inst.id
1005: AND ff2.cle_id = p_asset_id;
1006:
1007: l_iivv_tbl okl_txl_itm_insts_pvt.iivv_tbl_type;
1008: x_iivv_tbl okl_txl_itm_insts_pvt.iivv_tbl_type;
1009:
1010: l_iti_rec okl_iti_pvt.iti_rec_type;
1011: l_iivv_rec okl_txl_itm_insts_pvt.iivv_rec_type;

Line 1008: x_iivv_tbl okl_txl_itm_insts_pvt.iivv_tbl_type;

1004: AND txl.kle_id = inst.id
1005: AND ff2.cle_id = p_asset_id;
1006:
1007: l_iivv_tbl okl_txl_itm_insts_pvt.iivv_tbl_type;
1008: x_iivv_tbl okl_txl_itm_insts_pvt.iivv_tbl_type;
1009:
1010: l_iti_rec okl_iti_pvt.iti_rec_type;
1011: l_iivv_rec okl_txl_itm_insts_pvt.iivv_rec_type;
1012: x_iivv_rec okl_txl_itm_insts_pvt.iivv_rec_type;

Line 1011: l_iivv_rec okl_txl_itm_insts_pvt.iivv_rec_type;

1007: l_iivv_tbl okl_txl_itm_insts_pvt.iivv_tbl_type;
1008: x_iivv_tbl okl_txl_itm_insts_pvt.iivv_tbl_type;
1009:
1010: l_iti_rec okl_iti_pvt.iti_rec_type;
1011: l_iivv_rec okl_txl_itm_insts_pvt.iivv_rec_type;
1012: x_iivv_rec okl_txl_itm_insts_pvt.iivv_rec_type;
1013:
1014: l_itiv_rec okl_iti_pvt.itiv_rec_type;
1015:

Line 1012: x_iivv_rec okl_txl_itm_insts_pvt.iivv_rec_type;

1008: x_iivv_tbl okl_txl_itm_insts_pvt.iivv_tbl_type;
1009:
1010: l_iti_rec okl_iti_pvt.iti_rec_type;
1011: l_iivv_rec okl_txl_itm_insts_pvt.iivv_rec_type;
1012: x_iivv_rec okl_txl_itm_insts_pvt.iivv_rec_type;
1013:
1014: l_itiv_rec okl_iti_pvt.itiv_rec_type;
1015:
1016: x_no_data_found BOOLEAN;

Line 1074: FROM OKL_TXL_ITM_INSTS_V iti

1070: DNZ_CLE_ID,
1071: instance_id,
1072: selected_for_split_flag,
1073: asd_id
1074: FROM OKL_TXL_ITM_INSTS_V iti
1075: WHERE iti.kle_id = p_id;
1076: l_okl_itiv_pk okl_itiv_pk_csr%ROWTYPE;
1077: l_itiv_rec okl_iti_pvt.itiv_rec_type;
1078: BEGIN

Line 1230: okl_txl_itm_insts_pvt.update_txl_itm_insts(

1226:
1227: --dbms_output.put_line('ID: '||l_iivv_rec.id);
1228: --dbms_output.put_line('SRL No: '||l_iivv_rec.serial_number);
1229:
1230: okl_txl_itm_insts_pvt.update_txl_itm_insts(
1231: p_api_version => 1.0,
1232: p_init_msg_list => p_init_msg_list,
1233: x_return_status => x_return_status,
1234: x_msg_count => x_msg_count,

Line 1284: END OKL_TXL_ITM_INSTS_PVT;

1280: x_msg_data,
1281: '_PVT');
1282: END reset_item_srl_number;
1283:
1284: END OKL_TXL_ITM_INSTS_PVT;