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 2473: From okc_k_items cim_ib,

2469: Select cim_ib.object1_id1,
2470: iti.object_id1_new,
2471: trx.id tas_id,
2472: cleb_ib.id cleb_ib_id
2473: From okc_k_items cim_ib,
2474: okc_k_lines_b cleb_ib,
2475: okc_line_styles_b lseb_ib,
2476: okc_statuses_b stsb,
2477: okl_txl_itm_insts iti,

Line 2964: -- cursor to get instance_id from okc_k_items

2960: AND ib_cle.cle_id = inst_cle.id
2961: and inst_cle.dnz_chr_id = p_chrv_id
2962: and inst_cle.cle_id = p_fin_ast_cle_id;
2963:
2964: -- cursor to get instance_id from okc_k_items
2965: Cursor get_instance_id_csr(p_cle_id IN Number) is
2966: SELECT cim.object1_id1
2967: from okc_k_items cim
2968: where cim.cle_id = p_cle_id;

Line 2967: from okc_k_items cim

2963:
2964: -- cursor to get instance_id from okc_k_items
2965: Cursor get_instance_id_csr(p_cle_id IN Number) is
2966: SELECT cim.object1_id1
2967: from okc_k_items cim
2968: where cim.cle_id = p_cle_id;
2969:
2970: -- cursor to get original contract id
2971: cursor get_orig_k_id (p_chr_id in number,

Line 3022: FROM okc_k_items orig_ib_cim,

3018: p_rbk_chr_id IN NUMBER) IS
3019: SELECT orig_ib_cle.id ib_cle_id,
3020: orig_ib_cle.cle_id inst_cle_id,
3021: orig_ib_cim.object1_id1 instance_id
3022: FROM okc_k_items orig_ib_cim,
3023: okc_k_lines_b orig_ib_cle,
3024: okc_k_lines_b orig_inst_cle,
3025: okc_statuses_b inst_sts
3026: WHERE orig_inst_cle.dnz_chr_id = p_orig_chr_id

Line 3064: okc_k_items ib_cim,

3060: okc_k_lines_b orig_inst_cle,
3061: okc_k_lines_b rbk_inst_cle,
3062: okc_k_lines_b rbk_ib_cle,
3063: okc_statuses_b inst_sts,
3064: okc_k_items ib_cim,
3065: --Bug# 8766336
3066: okc_statuses_b rbk_inst_sts
3067: WHERE orig_inst_cle.dnz_chr_id = p_orig_chr_id
3068: AND orig_inst_cle.cle_id = p_orig_fin_ast_cle_id

Line 3116: okc_k_items ib_cim,

3112: CURSOR orig_instance_dtls_csr (p_fin_ast_cle_id IN NUMBER,
3113: p_chr_id IN NUMBER) is
3114: SELECT csi_item.inventory_item_id
3115: FROM csi_item_instances csi_item,
3116: okc_k_items ib_cim,
3117: okc_k_lines_b ib_cle,
3118: okc_k_lines_b inst_cle,
3119: okc_statuses_b inst_sts
3120: WHERE ib_cim.cle_id = ib_cle.id

Line 3137: FROM OKC_K_ITEMS CIM,

3133: CURSOR get_qty_csr (p_fin_ast_cle_id IN NUMBER) is
3134: SELECT cim.number_of_items,
3135: cim.object1_id1,
3136: cim.object1_id2
3137: FROM OKC_K_ITEMS CIM,
3138: OKC_K_LINES_B MDL,
3139: OKC_LINE_STYLES_B MDL_LSE
3140: WHERE CIM.CLE_ID = MDL.ID
3141: AND MDL.CLE_ID = p_fin_ast_cle_id

Line 3151: l_orig_inv_org_id okc_k_items.object1_id1%TYPE;

3147: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
3148: l_api_name CONSTANT varchar2(30) := 'RBK_SRL_NUM_IB_INSTANCE';
3149: l_api_version CONSTANT NUMBER := 1.0;
3150:
3151: l_orig_inv_org_id okc_k_items.object1_id1%TYPE;
3152: l_orig_inv_item_id okc_k_items.object1_id2%TYPE;
3153:
3154: -- gboomina Bug 5362977 - Start
3155: l_orig_serialized VARCHAR2(1) DEFAULT OKL_API.G_FALSE;

Line 3152: l_orig_inv_item_id okc_k_items.object1_id2%TYPE;

3148: l_api_name CONSTANT varchar2(30) := 'RBK_SRL_NUM_IB_INSTANCE';
3149: l_api_version CONSTANT NUMBER := 1.0;
3150:
3151: l_orig_inv_org_id okc_k_items.object1_id1%TYPE;
3152: l_orig_inv_item_id okc_k_items.object1_id2%TYPE;
3153:
3154: -- gboomina Bug 5362977 - Start
3155: l_orig_serialized VARCHAR2(1) DEFAULT OKL_API.G_FALSE;
3156: l_rbk_serialized VARCHAR2(1) DEFAULT OKL_API.G_FALSE;

Line 3161: l_instance_id okc_k_items.id%type;

3157: -- gboomina Bug 5362977 - End
3158:
3159: l_orig_k_id okc_k_headers_b.id%type;
3160: l_orig_fin_ast_cle_id okc_k_lines_b.id%type;
3161: l_instance_id okc_k_items.id%type;
3162: l_instance_cle_id okc_k_items.cle_id%type;
3163:
3164: l_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
3165: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;

Line 3162: l_instance_cle_id okc_k_items.cle_id%type;

3158:
3159: l_orig_k_id okc_k_headers_b.id%type;
3160: l_orig_fin_ast_cle_id okc_k_lines_b.id%type;
3161: l_instance_id okc_k_items.id%type;
3162: l_instance_cle_id okc_k_items.cle_id%type;
3163:
3164: l_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
3165: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
3166:

Line 3179: l_rbk_model_line_qty okc_k_items.number_of_items%TYPE;

3175: l_upd_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
3176: l_account_tbl party_account_tbl_type;
3177:
3178: -- gboomina Bug 5362977 - Start
3179: l_rbk_model_line_qty okc_k_items.number_of_items%TYPE;
3180: l_rbk_inv_item_id okc_k_items.object1_id1%TYPE;
3181: l_rbk_inv_org_id okc_k_items.object1_id2%TYPE;
3182: l_instance_query_temp_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
3183: l_instance_header_temp_rec CSI_DATASTRUCTURES_PUB.instance_header_rec;

Line 3180: l_rbk_inv_item_id okc_k_items.object1_id1%TYPE;

3176: l_account_tbl party_account_tbl_type;
3177:
3178: -- gboomina Bug 5362977 - Start
3179: l_rbk_model_line_qty okc_k_items.number_of_items%TYPE;
3180: l_rbk_inv_item_id okc_k_items.object1_id1%TYPE;
3181: l_rbk_inv_org_id okc_k_items.object1_id2%TYPE;
3182: l_instance_query_temp_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
3183: l_instance_header_temp_rec CSI_DATASTRUCTURES_PUB.instance_header_rec;
3184: l_instance_temp_rec CSI_DATASTRUCTURES_PUB.instance_rec;

Line 3181: l_rbk_inv_org_id okc_k_items.object1_id2%TYPE;

3177:
3178: -- gboomina Bug 5362977 - Start
3179: l_rbk_model_line_qty okc_k_items.number_of_items%TYPE;
3180: l_rbk_inv_item_id okc_k_items.object1_id1%TYPE;
3181: l_rbk_inv_org_id okc_k_items.object1_id2%TYPE;
3182: l_instance_query_temp_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
3183: l_instance_header_temp_rec CSI_DATASTRUCTURES_PUB.instance_header_rec;
3184: l_instance_temp_rec CSI_DATASTRUCTURES_PUB.instance_rec;
3185: l_model_line_qty okc_k_items.number_of_items%TYPE;

Line 3185: l_model_line_qty okc_k_items.number_of_items%TYPE;

3181: l_rbk_inv_org_id okc_k_items.object1_id2%TYPE;
3182: l_instance_query_temp_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
3183: l_instance_header_temp_rec CSI_DATASTRUCTURES_PUB.instance_header_rec;
3184: l_instance_temp_rec CSI_DATASTRUCTURES_PUB.instance_rec;
3185: l_model_line_qty okc_k_items.number_of_items%TYPE;
3186: l_cim_rec okl_okc_migration_pvt.cimv_rec_type;
3187: x_cim_rec okl_okc_migration_pvt.cimv_rec_type;
3188: -- gboomina Bug 5362977 - End
3189: