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.CSI_MASS_EDIT_PVT dependencies on CSI_MASS_EDIT_PUB

Line 23: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,

19: p_api_version IN NUMBER,
20: p_commit IN VARCHAR2 := fnd_api.g_false,
21: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
22: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
23: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
24: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
25: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
26: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
27: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

Line 25: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,

21: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
22: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
23: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
24: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
25: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
26: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
27: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
28: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
29: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 30: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl,

26: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
27: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
28: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
29: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
30: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl,
31: x_return_status OUT NOCOPY VARCHAR2,
32: x_msg_count OUT NOCOPY NUMBER,
33: x_msg_data OUT NOCOPY VARCHAR2
34:

Line 52: l_mass_edit_error_tbl csi_mass_edit_pub.mass_edit_error_tbl;

48: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
49: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
50: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
51: err_indx PLS_INTEGER := 0;
52: l_mass_edit_error_tbl csi_mass_edit_pub.mass_edit_error_tbl;
53: l_error_message VARCHAR2(2000);
54: l_msg_index NUMBER;
55: l_internal_party_id NUMBER := NULL;
56:

Line 175: p_CREATED_BY => csi_mass_edit_pub.g_user_id,

171: p_END_DATE => px_mass_edit_rec.END_DATE,
172: p_NAME => px_mass_edit_rec.NAME,
173: p_BATCH_TYPE => px_mass_edit_rec.BATCH_TYPE,
174: p_DESCRIPTION => px_mass_edit_rec.DESCRIPTION,
175: p_CREATED_BY => csi_mass_edit_pub.g_user_id,
176: p_CREATION_DATE => sysdate,
177: p_LAST_UPDATED_BY => csi_mass_edit_pub.g_user_id,
178: p_LAST_UPDATE_DATE => sysdate,
179: p_LAST_UPDATE_LOGIN => csi_mass_edit_pub.g_login_id,

Line 177: p_LAST_UPDATED_BY => csi_mass_edit_pub.g_user_id,

173: p_BATCH_TYPE => px_mass_edit_rec.BATCH_TYPE,
174: p_DESCRIPTION => px_mass_edit_rec.DESCRIPTION,
175: p_CREATED_BY => csi_mass_edit_pub.g_user_id,
176: p_CREATION_DATE => sysdate,
177: p_LAST_UPDATED_BY => csi_mass_edit_pub.g_user_id,
178: p_LAST_UPDATE_DATE => sysdate,
179: p_LAST_UPDATE_LOGIN => csi_mass_edit_pub.g_login_id,
180: p_OBJECT_VERSION_NUMBER => 1.0,
181: p_SYSTEM_CASCADE => px_mass_edit_rec.SYSTEM_CASCADE

Line 179: p_LAST_UPDATE_LOGIN => csi_mass_edit_pub.g_login_id,

175: p_CREATED_BY => csi_mass_edit_pub.g_user_id,
176: p_CREATION_DATE => sysdate,
177: p_LAST_UPDATED_BY => csi_mass_edit_pub.g_user_id,
178: p_LAST_UPDATE_DATE => sysdate,
179: p_LAST_UPDATE_LOGIN => csi_mass_edit_pub.g_login_id,
180: p_OBJECT_VERSION_NUMBER => 1.0,
181: p_SYSTEM_CASCADE => px_mass_edit_rec.SYSTEM_CASCADE
182: );
183:

Line 490: x_mass_edit_rec OUT NOCOPY csi_mass_edit_pub.mass_edit_rec)

486: --validate the mass update batch ID/name
487: FUNCTION Is_valid_batch (
488: p_batch_name IN VARCHAR2,
489: p_batch_id IN NUMBER,
490: x_mass_edit_rec OUT NOCOPY csi_mass_edit_pub.mass_edit_rec)
491: RETURN BOOLEAN
492: IS
493:
494: l_mass_edit_rec csi_mass_edit_entries_vl%rowtype;

Line 575: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl)

571: --validate the uniqueness of the batch name
572: PROCEDURE validate_batch_name(
573: p_batch_name IN VARCHAR2,
574: p_api_name IN VARCHAR2,
575: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl)
576: IS
577: l_found VARCHAR2(1) := null;
578: BEGIN
579: debug('Validating batch name');

Line 632: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl)

628: PROCEDURE validate_batch_type(
629: p_batch_type IN VARCHAR2,
630: p_api_name IN VARCHAR2,
631: x_sub_type_id OUT NOCOPY NUMBER ,
632: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl)
633: IS
634:
635: l_sub_type_id NUMBER := -1;
636:

Line 681: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl)

677: END validate_batch_type;
678:
679: PROCEDURE validate_batch_status(
680: p_batch_id IN NUMBER,
681: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl)
682: IS
683:
684: l_status csi_mass_edit_entries_b.status_code%type := null;
685:

Line 756: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl)

752: p_index IN NUMBER,
753: p_instance_id IN NUMBER,
754: p_txn_line_detail_id IN NUMBER,
755: p_error_code IN VARCHAR2,
756: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl)
757: IS
758: BEGIN
759: debug('logging an error in Mass edit error table');
760: x_mass_edit_error_tbl(p_index).entry_id := g_entry_id;

Line 774: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,

770: p_api_version IN NUMBER,
771: p_commit IN VARCHAR2 := fnd_api.g_false,
772: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
773: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
774: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
775: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
776: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
777: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
778: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

Line 776: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,

772: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
773: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
774: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
775: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
776: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
777: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
778: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
779: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
780: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 781: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl,

777: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
778: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
779: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
780: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
781: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl,
782: x_return_status OUT NOCOPY VARCHAR2,
783: x_msg_count OUT NOCOPY NUMBER,
784: x_msg_data OUT NOCOPY VARCHAR2) IS
785:

Line 799: l_mass_edit_rec csi_mass_edit_pub.mass_edit_rec;

795: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
796: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
797: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
798: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
799: l_mass_edit_rec csi_mass_edit_pub.mass_edit_rec;
800: err_indx PLS_INTEGER := 0;
801: tld_idx PLS_INTEGER := 0;
802: inst_idx PLS_INTEGER := 0;
803: pty_idx PLS_INTEGER := 0;

Line 806: l_mass_edit_error_tbl csi_mass_edit_pub.mass_edit_error_tbl;

802: inst_idx PLS_INTEGER := 0;
803: pty_idx PLS_INTEGER := 0;
804: ptyacc_idx PLS_INTEGER := 0;
805:
806: l_mass_edit_error_tbl csi_mass_edit_pub.mass_edit_error_tbl;
807: l_error_message VARCHAR2(2000);
808: l_msg_index NUMBER;
809: l_sub_type_id NUMBER;
810: l_create_instance_tdls VARCHAR2(1) := 'N';

Line 1225: p_LAST_UPDATED_BY => csi_mass_edit_pub.g_user_id,

1221: p_END_DATE => l_mass_edit_rec.END_DATE,
1222: p_NAME => l_mass_edit_rec.NAME,
1223: p_CREATED_BY => fnd_api.g_miss_num,
1224: p_CREATION_DATE => fnd_api.g_miss_date,
1225: p_LAST_UPDATED_BY => csi_mass_edit_pub.g_user_id,
1226: p_LAST_UPDATE_DATE => sysdate,
1227: p_LAST_UPDATE_LOGIN => csi_mass_edit_pub.g_login_id,
1228: p_OBJECT_VERSION_NUMBER => l_mass_edit_rec.OBJECT_VERSION_NUMBER,
1229: p_DESCRIPTION => l_mass_edit_rec.DESCRIPTION,

Line 1227: p_LAST_UPDATE_LOGIN => csi_mass_edit_pub.g_login_id,

1223: p_CREATED_BY => fnd_api.g_miss_num,
1224: p_CREATION_DATE => fnd_api.g_miss_date,
1225: p_LAST_UPDATED_BY => csi_mass_edit_pub.g_user_id,
1226: p_LAST_UPDATE_DATE => sysdate,
1227: p_LAST_UPDATE_LOGIN => csi_mass_edit_pub.g_login_id,
1228: p_OBJECT_VERSION_NUMBER => l_mass_edit_rec.OBJECT_VERSION_NUMBER,
1229: p_DESCRIPTION => l_mass_edit_rec.DESCRIPTION,
1230: p_BATCH_TYPE => px_mass_edit_rec.BATCH_TYPE,
1231: p_SYSTEM_CASCADE => l_mass_edit_rec.SYSTEM_CASCADE

Line 1276: p_mass_edit_rec IN csi_mass_edit_pub.mass_edit_rec,

1272: p_api_version IN NUMBER,
1273: p_commit IN VARCHAR2 := fnd_api.g_false,
1274: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1275: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1276: p_mass_edit_rec IN csi_mass_edit_pub.mass_edit_rec,
1277: x_return_status OUT NOCOPY VARCHAR2,
1278: x_msg_count OUT NOCOPY NUMBER,
1279: x_msg_data OUT NOCOPY VARCHAR2
1280:

Line 1288: l_mass_edit_rec csi_mass_edit_pub.mass_edit_rec;

1284: l_api_name VARCHAR2(30) := 'DELETE_MASS_EDIT_BATCH';
1285: l_msg_count NUMBER;
1286: l_msg_data VARCHAR2(2000);
1287: l_return_status VARCHAR2(1);
1288: l_mass_edit_rec csi_mass_edit_pub.mass_edit_rec;
1289:
1290: BEGIN
1291:
1292: -- Standard Start of API savepoint

Line 1439: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,

1435: p_api_version IN NUMBER,
1436: p_commit IN VARCHAR2 := fnd_api.g_false,
1437: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1438: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1439: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
1440: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl ,
1441: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1442: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1443: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 1615: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl) IS

1611: END Get_mass_edit_details;
1612:
1613: PROCEDURE vld_item_instance_active (p_instance_id_tab IN NumTabType,
1614: p_txn_line_detail_id_tab IN NumTabType,
1615: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl) IS
1616:
1617: e_indx NUMBER := 0;
1618: l_inst_active NUMBER := NULL;
1619:

Line 1657: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl) IS

1653:
1654: END vld_item_instance_active;
1655:
1656: PROCEDURE vld_batch_inst_same_owner(p_txn_line_id_tab IN NumTabType,
1657: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl) IS
1658:
1659: TYPE NumTabType is varray(10000) of number;
1660:
1661: l_account_id_tab NumTabType;

Line 1807: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl) IS

1803:
1804: END vld_batch_inst_same_owner;
1805:
1806: PROCEDURE vld_batch_inst_curr_owner (p_txn_line_id_tab IN NumTabType,
1807: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl) IS
1808:
1809: l_party_rec_count_tab NumTabType;
1810: l_transaction_line_id_tab NumTabType;
1811: l_owner_party_source_table_tab Char30TabType;

Line 1926: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl) IS

1922:
1923: PROCEDURE vld_child_inst_location(p_instance_id_tab IN NumTabType,
1924: p_txn_line_detail_id_tab IN NumTabType,
1925: p_instance_usage_code_tab IN Char30TabType,
1926: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl) IS
1927:
1928: e_indx NUMBER := NULL;
1929: l_object_id NUMBER;
1930: l_parent_found VARCHAR2(1) := 'N';

Line 1983: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl) IS

1979: p_location_type_code_tab IN Char30TabType,
1980: p_location_id_tab IN NumTabType,
1981: p_install_location_id_tab IN NumTabType,
1982: p_instance_status_id_tab IN NumTabType,
1983: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl) IS
1984:
1985: e_indx NUMBER;
1986:
1987: CURSOR dummy_csr(pc_txn_line_id IN NUMBER) IS

Line 2074: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl) IS

2070:
2071: END vld_item_inst_location;
2072:
2073: PROCEDURE vld_term_date(p_txn_line_id_tab IN NumTabType,
2074: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl) IS
2075:
2076: e_indx NUMBER;
2077:
2078: CURSOR dummy_csr(pc_txn_line_id IN NUMBER) IS

Line 2113: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl) IS

2109:
2110: END vld_term_date;
2111:
2112: PROCEDURE vld_xfer_date(p_txn_line_id_tab IN NumTabType,
2113: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl) IS
2114:
2115: e_indx NUMBER := 0;
2116:
2117: CURSOR party_csr (pc_txn_line_id IN NUMBER) IS

Line 2161: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl) IS

2157: p_instance_status_id_tab IN NumTabType,
2158: p_external_reference_tab IN Char30TabType,
2159: p_install_date_tab IN DateTabType,
2160: p_system_id_tab IN NumTabType,
2161: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl) IS
2162:
2163: e_indx NUMBER := 0;
2164:
2165: CURSOR txn_det_csr (pc_txn_line_detail_id IN NUMBER) IS

Line 2271: PROCEDURE validate_batch (px_mass_edit_rec IN csi_mass_edit_pub.mass_edit_rec,

2267: debug(' Error Table Count when exiting check_item_inst_loc_changed is: '||px_mass_edit_error_tbl.count);
2268:
2269: END check_item_inst_loc_changed;
2270:
2271: PROCEDURE validate_batch (px_mass_edit_rec IN csi_mass_edit_pub.mass_edit_rec,
2272: p_mode IN VARCHAR2,
2273: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl,
2274: x_return_status OUT NOCOPY VARCHAR2) IS
2275:

Line 2273: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl,

2269: END check_item_inst_loc_changed;
2270:
2271: PROCEDURE validate_batch (px_mass_edit_rec IN csi_mass_edit_pub.mass_edit_rec,
2272: p_mode IN VARCHAR2,
2273: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl,
2274: x_return_status OUT NOCOPY VARCHAR2) IS
2275:
2276:
2277: -- p_mode Parameters

Line 2289: l_mass_edit_error_tbl csi_mass_edit_pub.mass_edit_error_tbl;

2285: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
2286: l_msg_count NUMBER;
2287: l_msg_data VARCHAR2(2000);
2288: l_return_status VARCHAR2(1);
2289: l_mass_edit_error_tbl csi_mass_edit_pub.mass_edit_error_tbl;
2290: l_errors_found VARCHAR2(1) := 'N';
2291: l_warnings_found VARCHAR2(1) := 'N';
2292:
2293: l_transaction_line_id_tab NumTabType;

Line 2496: p_mu_sys_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_sys_error_tbl)

2492: /*----------------------------------------------------*/
2493: PROCEDURE VLD_SYSTEM_ACTIVE(
2494: p_system_id IN NUMBER ,
2495: p_txn_line_id IN NUMBER,
2496: p_mu_sys_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_sys_error_tbl)
2497: IS
2498: CURSOR sys_active (p_system_id IN NUMBER) IS
2499: SELECT 1
2500: FROM CSI_SYSTEMS_B

Line 2544: p_mu_sys_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_sys_error_tbl)

2540: PROCEDURE VLD_SYSTEM_CURRENT_OWNER(
2541: p_system_id IN NUMBER ,
2542: p_customer_id IN NUMBER,
2543: p_txn_line_id IN NUMBER,
2544: p_mu_sys_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_sys_error_tbl)
2545: IS
2546: CURSOR sys_customer_csr (p_system_id IN NUMBER) IS
2547: SELECT CUSTOMER_ID
2548: FROM CSI_SYSTEMS_B

Line 2589: p_mu_sys_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_sys_error_tbl)

2585: /*----------------------------------------------------*/
2586: PROCEDURE VLD_SYSTEM_LOCATION_CHGD(
2587: p_system_id IN NUMBER ,
2588: p_txn_line_id IN NUMBER,
2589: p_mu_sys_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_sys_error_tbl)
2590: IS
2591: BEGIN
2592:
2593: -- Checking whether location id/contact id changed after batch was created