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_PUB dependencies on CSI_MASS_EDIT_PUB

Line 1: PACKAGE BODY csi_mass_edit_pub as

1: PACKAGE BODY csi_mass_edit_pub as
2: /* $Header: csipmeeb.pls 120.59.12020000.2 2012/08/13 05:53:04 sjawaji ship $ */
3: -- Start of Comments
4: -- Package name : CSI_MASS_EDIT_PUB
5: -- Purpose :

Line 4: -- Package name : CSI_MASS_EDIT_PUB

1: PACKAGE BODY csi_mass_edit_pub as
2: /* $Header: csipmeeb.pls 120.59.12020000.2 2012/08/13 05:53:04 sjawaji ship $ */
3: -- Start of Comments
4: -- Package name : CSI_MASS_EDIT_PUB
5: -- Purpose :
6:
7: -- History :
8: -- NOTE :

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_MASS_EDIT_PUB';

7: -- History :
8: -- NOTE :
9: -- End of Comments
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_MASS_EDIT_PUB';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csipmeeb.pls';
13:
14: /* local routine to wrap the gen utility debug stuff */
15:

Line 34: p_temp_merror_tbl IN CSI_MASS_EDIT_PUB.Mass_Upd_Rep_Error_Tbl,

30:
31:
32:
33: PROCEDURE conc_report (
34: p_temp_merror_tbl IN CSI_MASS_EDIT_PUB.Mass_Upd_Rep_Error_Tbl,
35: p_name IN VARCHAR2,
36: p_batch_id IN NUMBER,
37: p_batch_name IN VARCHAR2
38: ) IS

Line 39: l_temp_merror_tbl csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl;

35: p_name IN VARCHAR2,
36: p_batch_id IN NUMBER,
37: p_batch_name IN VARCHAR2
38: ) IS
39: l_temp_merror_tbl csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl;
40: l_repo_merror_tbl csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl;
41: l_rep_instance_id NUMBER;
42: l_rep_txn_line_id NUMBER;
43:

Line 40: l_repo_merror_tbl csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl;

36: p_batch_id IN NUMBER,
37: p_batch_name IN VARCHAR2
38: ) IS
39: l_temp_merror_tbl csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl;
40: l_repo_merror_tbl csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl;
41: l_rep_instance_id NUMBER;
42: l_rep_txn_line_id NUMBER;
43:
44: BEGIN

Line 128: p_error_tbl IN csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl,

124: End conc_report;
125:
126:
127: PROCEDURE update_error_status (
128: p_error_tbl IN csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl,
129: p_txn_line_id IN NUMBER,
130: p_entry_id IN NUMBER
131: ) is
132: l_instance_id NUMBER;

Line 301: l_mass_edit_tbl csi_mass_edit_pub.mass_edit_tbl;

297: l_debug_level NUMBER;
298: l_entry_id NUMBER := 0;
299: l_request_id NUMBER ;
300: l_errbuf VARCHAR2(2000);
301: l_mass_edit_tbl csi_mass_edit_pub.mass_edit_tbl;
302: i NUMBER;
303: --l_txn_rec csi_datastructures_pub.transaction_rec;
304: l_count NUMBER;
305: l_warning NUMBER := 0;

Line 639: l_medit_error_tbl csi_mass_edit_pub.mass_edit_error_tbl;

635: l_batch_type VARCHAR2(30);
636: l_found_batch VARCHAR2(30);
637: l_conc_status BOOLEAN;
638:
639: l_medit_error_tbl csi_mass_edit_pub.mass_edit_error_tbl;
640: l_temp_merror_tbl csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl;
641: l_repo_merror_tbl csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl;
642: l_rep_instance_id NUMBER;
643: l_rep_txn_line_id NUMBER;

Line 640: l_temp_merror_tbl csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl;

636: l_found_batch VARCHAR2(30);
637: l_conc_status BOOLEAN;
638:
639: l_medit_error_tbl csi_mass_edit_pub.mass_edit_error_tbl;
640: l_temp_merror_tbl csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl;
641: l_repo_merror_tbl csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl;
642: l_rep_instance_id NUMBER;
643: l_rep_txn_line_id NUMBER;
644: l_found_error VARCHAR2(1) := 'N';

Line 641: l_repo_merror_tbl csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl;

637: l_conc_status BOOLEAN;
638:
639: l_medit_error_tbl csi_mass_edit_pub.mass_edit_error_tbl;
640: l_temp_merror_tbl csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl;
641: l_repo_merror_tbl csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl;
642: l_rep_instance_id NUMBER;
643: l_rep_txn_line_id NUMBER;
644: l_found_error VARCHAR2(1) := 'N';
645:

Line 646: px_medit_rec csi_mass_edit_pub.mass_edit_rec;

642: l_rep_instance_id NUMBER;
643: l_rep_txn_line_id NUMBER;
644: l_found_error VARCHAR2(1) := 'N';
645:
646: px_medit_rec csi_mass_edit_pub.mass_edit_rec;
647:
648: l_note_id NUMBER;
649: l_batch_desc VARCHAR2(2000);
650: l_name VARCHAR2(50);

Line 1613: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,

1609: p_api_version IN NUMBER,
1610: p_commit IN VARCHAR2 := fnd_api.g_false,
1611: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1612: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1613: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
1614: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
1615: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
1616: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
1617: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

Line 1615: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,

1611: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1612: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1613: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
1614: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
1615: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
1616: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
1617: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1618: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1619: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 1781: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,

1777: p_api_version IN NUMBER,
1778: p_commit IN VARCHAR2 := fnd_api.g_false,
1779: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1780: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1781: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
1782: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
1783: px_mass_edit_inst_tbl IN OUT NOCOPY mass_edit_inst_tbl,
1784: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
1785: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

Line 2859: l_mu_sys_error_tbl csi_mass_edit_pub.mass_edit_sys_error_tbl;

2855: -- AND ACCOUNT_NUMBER = p_account_number;
2856:
2857: -- l_sys_cust_rec SYS_CUST_CSR%ROWTYPE; bug 7350165
2858: l_sys_acct_rec SYS_ACCOUNT_CSR%ROWTYPE;
2859: l_mu_sys_error_tbl csi_mass_edit_pub.mass_edit_sys_error_tbl;
2860: l_errors_found VARCHAR2(1) := 'N';
2861: l_warnings_found VARCHAR2(1) := 'N';
2862:
2863: BEGIN

Line 3007: --This program is called from CSI_MASS_EDIT_PUB.Process_mass_edit_batch

3003:
3004:
3005:
3006: --Updated the csi_mass_edit_entries_b table with status_code to SCHEDULED from status CREATED
3007: --This program is called from CSI_MASS_EDIT_PUB.Process_mass_edit_batch
3008: PROCEDURE Process_webadi_batch
3009: ( errbuf OUT NOCOPY VARCHAR2
3010: ,retcode OUT NOCOPY NUMBER
3011: ,p_Entry_id IN NUMBER

Line 3372: l_log_tbl csi_mass_edit_pub.log_tbl;

3368: l_chr_id_tbl number_tbl;
3369: l_attach2_line_id_tbl number_tbl;
3370: l_covlvl_id NUMBER;
3371: l_cov_line_tbl OKS_IBINT_PUB.k_cov_line_tbl;
3372: l_log_tbl csi_mass_edit_pub.log_tbl;
3373: l_par_instance_id NUMBER;
3374: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3375: l_crt_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3376: l_msg_count number;

Line 6110: l_mass_edit_rec csi_mass_edit_pub.mass_edit_rec;

6106: ,p_Entry_id IN NUMBER
6107: ,p_reupld_batch_id OUT NOCOPY NUMBER
6108: ) IS
6109:
6110: l_mass_edit_rec csi_mass_edit_pub.mass_edit_rec;
6111: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
6112: l_mass_edit_inst_tbl csi_mass_edit_pub.mass_edit_inst_tbl;
6113: l_txn_line_detail_rec csi_t_datastructures_grp.txn_line_detail_rec;
6114: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 6112: l_mass_edit_inst_tbl csi_mass_edit_pub.mass_edit_inst_tbl;

6108: ) IS
6109:
6110: l_mass_edit_rec csi_mass_edit_pub.mass_edit_rec;
6111: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
6112: l_mass_edit_inst_tbl csi_mass_edit_pub.mass_edit_inst_tbl;
6113: l_txn_line_detail_rec csi_t_datastructures_grp.txn_line_detail_rec;
6114: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6115: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6116: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 6117: l_mass_edit_error_tbl csi_mass_edit_pub.mass_edit_error_tbl;

6113: l_txn_line_detail_rec csi_t_datastructures_grp.txn_line_detail_rec;
6114: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6115: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6116: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6117: l_mass_edit_error_tbl csi_mass_edit_pub.mass_edit_error_tbl;
6118:
6119: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6120: l_msg_count number;
6121: l_msg_data varchar2(2000);

Line 6148: debug('Calling API csi_mass_edit_pub.CREATE_MASS_EDIT_BATCH.');

6144: l_mass_edit_rec.name := l_old_batch_name || '_' || l_new_batch_seq;
6145: l_mass_edit_rec.description := l_old_batch_desc;
6146: l_mass_edit_rec.batch_type := 'WBADI';
6147:
6148: debug('Calling API csi_mass_edit_pub.CREATE_MASS_EDIT_BATCH.');
6149: csi_mass_edit_pub.CREATE_MASS_EDIT_BATCH
6150: (p_api_version => 1.0,
6151: p_commit => fnd_api.g_false,
6152: p_init_msg_list => fnd_api.g_true,

Line 6149: csi_mass_edit_pub.CREATE_MASS_EDIT_BATCH

6145: l_mass_edit_rec.description := l_old_batch_desc;
6146: l_mass_edit_rec.batch_type := 'WBADI';
6147:
6148: debug('Calling API csi_mass_edit_pub.CREATE_MASS_EDIT_BATCH.');
6149: csi_mass_edit_pub.CREATE_MASS_EDIT_BATCH
6150: (p_api_version => 1.0,
6151: p_commit => fnd_api.g_false,
6152: p_init_msg_list => fnd_api.g_true,
6153: p_validation_level => fnd_api.g_valid_level_full,

Line 6533: End CSI_MASS_EDIT_PUB;

6529: END;
6530:
6531: END Populate_WebAdi_Ids;
6532:
6533: End CSI_MASS_EDIT_PUB;