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_ACTIVATE_IB_PVT dependencies on OKC_K_ITEMS

Line 72: -- FUNCTION get_rec for: OKC_K_ITEMS_V

68: begin
69: null;
70: end api_copy;
71: ---------------------------------------------------------------------------
72: -- FUNCTION get_rec for: OKC_K_ITEMS_V
73: ---------------------------------------------------------------------------
74: FUNCTION get_cimv_rec (p_cle_id IN NUMBER,
75: x_no_data_found OUT NOCOPY BOOLEAN
76: ) RETURN cimv_rec_type IS

Line 99: FROM Okc_K_Items_V cim

95: cim.CREATION_DATE,
96: cim.LAST_UPDATED_BY,
97: cim.LAST_UPDATE_DATE,
98: cim.LAST_UPDATE_LOGIN
99: FROM Okc_K_Items_V cim
100: where cle_id = p_cle_id;
101:
102: l_cimv_rec cimv_rec_type;
103: BEGIN

Line 841: FROM OKC_K_ITEMS CIM,

837: CURSOR get_qty_csr (p_inst_line_id IN NUMBER) is
838: SELECT cim.number_of_items,
839: cim.object1_id1,
840: cim.object1_id2
841: FROM OKC_K_ITEMS CIM,
842: OKC_K_LINES_B MDL,
843: OKC_LINE_STYLES_B MDL_LSE,
844: OKC_K_LINES_B INST
845: WHERE CIM.CLE_ID = MDL.ID

Line 1299: --update line source (okc_k_items)

1295: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1296: RAISE OKL_API.G_EXCEPTION_ERROR;
1297: END IF;
1298:
1299: --update line source (okc_k_items)
1300: If l_no_data_found_cimv then
1301: l_cimv_rec.cle_id := l_ib_cle_id;
1302: l_cimv_rec.dnz_chr_id := p_chrv_id;
1303: l_cimv_rec.object1_id1 := l_instance_rec.instance_id;

Line 1472: FROM OKC_K_ITEMS CIM,

1468: CURSOR get_qty_csr (p_inst_line_id IN NUMBER) is
1469: SELECT cim.number_of_items,
1470: cim.object1_id1,
1471: cim.object1_id2
1472: FROM OKC_K_ITEMS CIM,
1473: OKC_K_LINES_B MDL,
1474: OKC_K_LINES_B INST
1475: WHERE CIM.CLE_ID = MDL.ID
1476: AND MDL.CLE_ID = INST.CLE_ID

Line 1520: OKC_K_ITEMS CIM,

1516: AND NOT EXISTS
1517: (SELECT CLE.DNZ_CHR_ID
1518: FROM OKC_K_LINES_B CLE,
1519: OKC_LINE_STYLES_B CLS,
1520: OKC_K_ITEMS CIM,
1521: OKX_INSTALL_ITEMS_V CIX,
1522: OKL_K_HEADERS KHR
1523: WHERE CLE.LSE_ID = CLS.ID
1524: AND CLE.DNZ_CHR_ID = KHR.ID

Line 1814: --update line source (okc_k_items)

1810: RAISE OKL_API.G_EXCEPTION_ERROR;
1811: END IF;
1812: END IF;--check for existing serial no instance
1813:
1814: --update line source (okc_k_items)
1815: If l_no_data_found_cimv then
1816: l_cimv_rec.cle_id := l_ib_cle_id;
1817: l_cimv_rec.dnz_chr_id := p_chrv_id;
1818: l_cimv_rec.object1_id1 := l_instance_rec.instance_id;

Line 2446: From okc_k_items cim_ib,

2442: Select cim_ib.object1_id1,
2443: iti.object_id1_new,
2444: trx.id tas_id,
2445: cleb_ib.id cleb_ib_id
2446: From okc_k_items cim_ib,
2447: okc_k_lines_b cleb_ib,
2448: okc_line_styles_b lseb_ib,
2449: okc_statuses_b stsb,
2450: okl_txl_itm_insts iti,

Line 2937: -- cursor to get instance_id from okc_k_items

2933: AND ib_cle.cle_id = inst_cle.id
2934: and inst_cle.dnz_chr_id = p_chrv_id
2935: and inst_cle.cle_id = p_fin_ast_cle_id;
2936:
2937: -- cursor to get instance_id from okc_k_items
2938: Cursor get_instance_id_csr(p_cle_id IN Number) is
2939: SELECT cim.object1_id1
2940: from okc_k_items cim
2941: where cim.cle_id = p_cle_id;

Line 2940: from okc_k_items cim

2936:
2937: -- cursor to get instance_id from okc_k_items
2938: Cursor get_instance_id_csr(p_cle_id IN Number) is
2939: SELECT cim.object1_id1
2940: from okc_k_items cim
2941: where cim.cle_id = p_cle_id;
2942:
2943: -- cursor to get original contract id
2944: cursor get_orig_k_id (p_chr_id in number,

Line 2990: FROM okc_k_items orig_ib_cim,

2986: p_rbk_chr_id IN NUMBER) IS
2987: SELECT orig_ib_cle.id ib_cle_id,
2988: orig_ib_cle.cle_id inst_cle_id,
2989: orig_ib_cim.object1_id1 instance_id
2990: FROM okc_k_items orig_ib_cim,
2991: okc_k_lines_b orig_ib_cle,
2992: okc_k_lines_b orig_inst_cle,
2993: okc_statuses_b inst_sts
2994: WHERE orig_inst_cle.dnz_chr_id = p_orig_chr_id

Line 3032: okc_k_items ib_cim

3028: okc_k_lines_b orig_inst_cle,
3029: okc_k_lines_b rbk_inst_cle,
3030: okc_k_lines_b rbk_ib_cle,
3031: okc_statuses_b inst_sts,
3032: okc_k_items ib_cim
3033: WHERE orig_inst_cle.dnz_chr_id = p_orig_chr_id
3034: AND orig_inst_cle.cle_id = p_orig_fin_ast_cle_id
3035: AND orig_inst_cle.lse_id = G_INST_LINE_LTY_ID
3036: AND orig_ib_cle.cle_id = orig_inst_cle.id

Line 3079: okc_k_items ib_cim,

3075: CURSOR orig_instance_dtls_csr (p_fin_ast_cle_id IN NUMBER,
3076: p_chr_id IN NUMBER) is
3077: SELECT csi_item.inventory_item_id
3078: FROM csi_item_instances csi_item,
3079: okc_k_items ib_cim,
3080: okc_k_lines_b ib_cle,
3081: okc_k_lines_b inst_cle,
3082: okc_statuses_b inst_sts
3083: WHERE ib_cim.cle_id = ib_cle.id

Line 3100: FROM OKC_K_ITEMS CIM,

3096: CURSOR get_qty_csr (p_fin_ast_cle_id IN NUMBER) is
3097: SELECT cim.number_of_items,
3098: cim.object1_id1,
3099: cim.object1_id2
3100: FROM OKC_K_ITEMS CIM,
3101: OKC_K_LINES_B MDL,
3102: OKC_LINE_STYLES_B MDL_LSE
3103: WHERE CIM.CLE_ID = MDL.ID
3104: AND MDL.CLE_ID = p_fin_ast_cle_id

Line 3114: l_orig_inv_org_id okc_k_items.object1_id1%TYPE;

3110: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
3111: l_api_name CONSTANT varchar2(30) := 'RBK_SRL_NUM_IB_INSTANCE';
3112: l_api_version CONSTANT NUMBER := 1.0;
3113:
3114: l_orig_inv_org_id okc_k_items.object1_id1%TYPE;
3115: l_orig_inv_item_id okc_k_items.object1_id2%TYPE;
3116:
3117: -- gboomina Bug 5362977 - Start
3118: l_orig_serialized VARCHAR2(1) DEFAULT OKL_API.G_FALSE;

Line 3115: l_orig_inv_item_id okc_k_items.object1_id2%TYPE;

3111: l_api_name CONSTANT varchar2(30) := 'RBK_SRL_NUM_IB_INSTANCE';
3112: l_api_version CONSTANT NUMBER := 1.0;
3113:
3114: l_orig_inv_org_id okc_k_items.object1_id1%TYPE;
3115: l_orig_inv_item_id okc_k_items.object1_id2%TYPE;
3116:
3117: -- gboomina Bug 5362977 - Start
3118: l_orig_serialized VARCHAR2(1) DEFAULT OKL_API.G_FALSE;
3119: l_rbk_serialized VARCHAR2(1) DEFAULT OKL_API.G_FALSE;

Line 3124: l_instance_id okc_k_items.id%type;

3120: -- gboomina Bug 5362977 - End
3121:
3122: l_orig_k_id okc_k_headers_b.id%type;
3123: l_orig_fin_ast_cle_id okc_k_lines_b.id%type;
3124: l_instance_id okc_k_items.id%type;
3125: l_instance_cle_id okc_k_items.cle_id%type;
3126:
3127: l_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
3128: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;

Line 3125: l_instance_cle_id okc_k_items.cle_id%type;

3121:
3122: l_orig_k_id okc_k_headers_b.id%type;
3123: l_orig_fin_ast_cle_id okc_k_lines_b.id%type;
3124: l_instance_id okc_k_items.id%type;
3125: l_instance_cle_id okc_k_items.cle_id%type;
3126:
3127: l_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
3128: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
3129:

Line 3142: l_rbk_model_line_qty okc_k_items.number_of_items%TYPE;

3138: l_upd_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
3139: l_account_tbl party_account_tbl_type;
3140:
3141: -- gboomina Bug 5362977 - Start
3142: l_rbk_model_line_qty okc_k_items.number_of_items%TYPE;
3143: l_rbk_inv_item_id okc_k_items.object1_id1%TYPE;
3144: l_rbk_inv_org_id okc_k_items.object1_id2%TYPE;
3145: l_instance_query_temp_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
3146: l_instance_header_temp_rec CSI_DATASTRUCTURES_PUB.instance_header_rec;

Line 3143: l_rbk_inv_item_id okc_k_items.object1_id1%TYPE;

3139: l_account_tbl party_account_tbl_type;
3140:
3141: -- gboomina Bug 5362977 - Start
3142: l_rbk_model_line_qty okc_k_items.number_of_items%TYPE;
3143: l_rbk_inv_item_id okc_k_items.object1_id1%TYPE;
3144: l_rbk_inv_org_id okc_k_items.object1_id2%TYPE;
3145: l_instance_query_temp_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
3146: l_instance_header_temp_rec CSI_DATASTRUCTURES_PUB.instance_header_rec;
3147: l_instance_temp_rec CSI_DATASTRUCTURES_PUB.instance_rec;

Line 3144: l_rbk_inv_org_id okc_k_items.object1_id2%TYPE;

3140:
3141: -- gboomina Bug 5362977 - Start
3142: l_rbk_model_line_qty okc_k_items.number_of_items%TYPE;
3143: l_rbk_inv_item_id okc_k_items.object1_id1%TYPE;
3144: l_rbk_inv_org_id okc_k_items.object1_id2%TYPE;
3145: l_instance_query_temp_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
3146: l_instance_header_temp_rec CSI_DATASTRUCTURES_PUB.instance_header_rec;
3147: l_instance_temp_rec CSI_DATASTRUCTURES_PUB.instance_rec;
3148: l_model_line_qty okc_k_items.number_of_items%TYPE;

Line 3148: l_model_line_qty okc_k_items.number_of_items%TYPE;

3144: l_rbk_inv_org_id okc_k_items.object1_id2%TYPE;
3145: l_instance_query_temp_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
3146: l_instance_header_temp_rec CSI_DATASTRUCTURES_PUB.instance_header_rec;
3147: l_instance_temp_rec CSI_DATASTRUCTURES_PUB.instance_rec;
3148: l_model_line_qty okc_k_items.number_of_items%TYPE;
3149: l_cim_rec okl_okc_migration_pvt.cimv_rec_type;
3150: x_cim_rec okl_okc_migration_pvt.cimv_rec_type;
3151: -- gboomina Bug 5362977 - End
3152: