APPS.CSI_MASS_EDIT_PVT dependencies on CSI_MASS_EDIT_PVT

Line 1: PACKAGE BODY CSI_MASS_EDIT_PVT as

1: PACKAGE BODY CSI_MASS_EDIT_PVT as
2: /* $Header: csivmeeb.pls 120.10.12010000.2 2008/11/06 20:32:21 mashah ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_MASS_EDIT_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csivmeeb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_MASS_EDIT_PVT';

1: PACKAGE BODY CSI_MASS_EDIT_PVT as
2: /* $Header: csivmeeb.pls 120.10.12010000.2 2008/11/06 20:32:21 mashah ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_MASS_EDIT_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csivmeeb.pls';
6:
7: /* local routine to wrap the gen utility debug stuff */
8:

Line 192: csi_mass_edit_pvt.validate_batch (px_mass_edit_rec,

188:
189: -- query all instances from the px_mass_edit_inst_tbl into the px_txn_line_detail_tbl
190: IF px_mass_edit_inst_tbl.count > 0 THEN
191: -- Validate the batch first
192: csi_mass_edit_pvt.validate_batch (px_mass_edit_rec,
193: 'CRT', -- Create
194: l_mass_edit_error_tbl,
195: l_return_status);
196:

Line 982: csi_mass_edit_pvt.validate_batch (px_mass_edit_rec,

978:
979: debug('l_create_instance_tdls flag: '||l_create_instance_tdls);
980:
981: IF l_create_instance_tdls = 'N' THEN
982: csi_mass_edit_pvt.validate_batch (px_mass_edit_rec,
983: 'UPD', -- Update
984: l_mass_edit_error_tbl,
985: l_return_status);
986: END IF;

Line 1195: csi_mass_edit_pvt.validate_batch (px_mass_edit_rec,

1191: END IF;
1192:
1193: IF l_create_instance_tdls = 'Y' THEN
1194: debug('Calling validate_batch after updating txn details');
1195: csi_mass_edit_pvt.validate_batch (px_mass_edit_rec,
1196: 'UPD', -- Update
1197: l_mass_edit_error_tbl,
1198: l_return_status);
1199:

Line 2370: csi_mass_edit_pvt.vld_item_instance_active (l_instance_id_tab,

2366:
2367: IF p_mode in ('UI','CRT','UPD','CP') THEN
2368: -- Validate that the instance is active
2369: debug('Executing vld_item_instance_active');
2370: csi_mass_edit_pvt.vld_item_instance_active (l_instance_id_tab,
2371: l_txn_line_detail_id_tab,
2372: l_mass_edit_error_tbl);
2373: END IF;
2374:

Line 2378: csi_mass_edit_pvt.vld_batch_inst_curr_owner(l_transaction_line_id_tab,

2374:
2375: IF p_mode = 'CP' THEN
2376: debug('Executing vld_batch_inst_curr_owner: '||l_transaction_line_id_tab(1));
2377: -- check current owner
2378: csi_mass_edit_pvt.vld_batch_inst_curr_owner(l_transaction_line_id_tab,
2379: l_mass_edit_error_tbl);
2380: END IF;
2381:
2382: IF px_mass_edit_rec.batch_type = 'XFER' THEN

Line 2387: csi_mass_edit_pvt.vld_batch_inst_same_owner(l_transaction_line_id_tab,

2383: debug('Batch Type is transfer so call vld_batch_inst_same_owner');
2384: IF p_mode in ('UI','CRT','UPD','CP') THEN
2385: debug('Executing vld_batch_inst_same_owner');
2386: -- check owner type and owner
2387: csi_mass_edit_pvt.vld_batch_inst_same_owner(l_transaction_line_id_tab,
2388: l_mass_edit_error_tbl);
2389: END IF;
2390: END IF;
2391:

Line 2395: csi_mass_edit_pvt.vld_child_inst_location

2391:
2392: IF p_mode in ('UPD','CP') THEN
2393: debug('Executing vld_child_inst_location');
2394: -- check child instances
2395: csi_mass_edit_pvt.vld_child_inst_location
2396: (l_instance_id_tab,
2397: l_txn_line_detail_id_tab,
2398: l_instance_usage_code_tab,
2399: l_mass_edit_error_tbl);

Line 2405: csi_mass_edit_pvt.vld_item_inst_location(l_instance_id_tab,

2401:
2402: IF p_mode in ('UI','CRT','UPD','CP') THEN
2403: debug('Executing vld_item_inst_locatoin');
2404: -- check instance location
2405: csi_mass_edit_pvt.vld_item_inst_location(l_instance_id_tab,
2406: l_transaction_line_id_tab,
2407: l_location_type_code_tab,
2408: l_location_id_tab,
2409: l_install_location_id_tab,

Line 2417: csi_mass_edit_pvt.check_item_inst_loc_changed(l_txn_line_detail_id_tab,

2413:
2414: IF p_mode = 'CP' THEN
2415: debug('Executing check_item_inst_loc_changed');
2416: -- check instance location but throw warning NO error
2417: csi_mass_edit_pvt.check_item_inst_loc_changed(l_txn_line_detail_id_tab,
2418: l_instance_id_tab,
2419: l_install_location_id_tab,
2420: l_location_id_tab,
2421: l_instance_status_id_tab,

Line 2430: csi_mass_edit_pvt.vld_term_date(l_transaction_line_id_tab,

2426: END IF;
2427:
2428: IF p_mode = 'CP' AND px_mass_edit_rec.batch_type = 'TRM' THEN
2429: debug('Executing vld_term_date');
2430: csi_mass_edit_pvt.vld_term_date(l_transaction_line_id_tab,
2431: l_mass_edit_error_tbl);
2432: END IF;
2433:
2434: IF p_mode = 'CP' AND px_mass_edit_rec.batch_type = 'XFER' THEN

Line 2436: csi_mass_edit_pvt.vld_xfer_date(l_transaction_line_id_tab,

2432: END IF;
2433:
2434: IF p_mode = 'CP' AND px_mass_edit_rec.batch_type = 'XFER' THEN
2435: debug('Executing vld_xfer_date');
2436: csi_mass_edit_pvt.vld_xfer_date(l_transaction_line_id_tab,
2437: l_mass_edit_error_tbl);
2438:
2439: END IF;
2440:

Line 2606: END CSI_MASS_EDIT_PVT;

2602:
2603: END VLD_SYSTEM_LOCATION_CHGD;
2604:
2605:
2606: END CSI_MASS_EDIT_PVT;