DBA Data[Home] [Help]

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.17.12010000.2 2008/11/06 20:25:42 mashah 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.17.12010000.2 2008/11/06 20:25:42 mashah ship $ */
3: -- Start of Comments
4: -- Package name : CSI_MASS_EDIT_PUB
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

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

Line 33: p_temp_merror_tbl IN CSI_MASS_EDIT_PUB.Mass_Upd_Rep_Error_Tbl,

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

Line 38: l_temp_merror_tbl csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl;

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

Line 39: l_repo_merror_tbl csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl;

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

Line 126: p_error_tbl IN csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl,

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

Line 297: l_mass_edit_tbl csi_mass_edit_pub.mass_edit_tbl;

293: l_debug_level NUMBER;
294: l_entry_id NUMBER := 0;
295: l_request_id NUMBER ;
296: l_errbuf VARCHAR2(2000);
297: l_mass_edit_tbl csi_mass_edit_pub.mass_edit_tbl;
298: i NUMBER;
299: --l_txn_rec csi_datastructures_pub.transaction_rec;
300: l_count NUMBER;
301: l_warning NUMBER := 0;

Line 539: l_medit_error_tbl csi_mass_edit_pub.mass_edit_error_tbl;

535: l_batch_type VARCHAR2(30);
536: l_found_batch VARCHAR2(30);
537: l_conc_status BOOLEAN;
538:
539: l_medit_error_tbl csi_mass_edit_pub.mass_edit_error_tbl;
540: l_temp_merror_tbl csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl;
541: l_repo_merror_tbl csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl;
542: l_rep_instance_id NUMBER;
543: l_rep_txn_line_id NUMBER;

Line 540: l_temp_merror_tbl csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl;

536: l_found_batch VARCHAR2(30);
537: l_conc_status BOOLEAN;
538:
539: l_medit_error_tbl csi_mass_edit_pub.mass_edit_error_tbl;
540: l_temp_merror_tbl csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl;
541: l_repo_merror_tbl csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl;
542: l_rep_instance_id NUMBER;
543: l_rep_txn_line_id NUMBER;
544: l_found_error VARCHAR2(1) := 'N';

Line 541: l_repo_merror_tbl csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl;

537: l_conc_status BOOLEAN;
538:
539: l_medit_error_tbl csi_mass_edit_pub.mass_edit_error_tbl;
540: l_temp_merror_tbl csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl;
541: l_repo_merror_tbl csi_mass_edit_pub.Mass_Upd_Rep_Error_Tbl;
542: l_rep_instance_id NUMBER;
543: l_rep_txn_line_id NUMBER;
544: l_found_error VARCHAR2(1) := 'N';
545:

Line 546: px_medit_rec csi_mass_edit_pub.mass_edit_rec;

542: l_rep_instance_id NUMBER;
543: l_rep_txn_line_id NUMBER;
544: l_found_error VARCHAR2(1) := 'N';
545:
546: px_medit_rec csi_mass_edit_pub.mass_edit_rec;
547:
548: l_note_id NUMBER;
549: l_batch_desc VARCHAR2(2000);
550: l_name VARCHAR2(50);

Line 1498: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,

1494: p_api_version IN NUMBER,
1495: p_commit IN VARCHAR2 := fnd_api.g_false,
1496: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1497: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1498: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
1499: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
1500: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
1501: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
1502: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

Line 1500: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,

1496: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1497: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1498: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
1499: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
1500: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
1501: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
1502: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1503: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1504: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 1666: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,

1662: p_api_version IN NUMBER,
1663: p_commit IN VARCHAR2 := fnd_api.g_false,
1664: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1665: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1666: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
1667: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
1668: px_mass_edit_inst_tbl IN OUT NOCOPY mass_edit_inst_tbl,
1669: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
1670: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

Line 2744: l_mu_sys_error_tbl csi_mass_edit_pub.mass_edit_sys_error_tbl;

2740: -- AND ACCOUNT_NUMBER = p_account_number;
2741:
2742: -- l_sys_cust_rec SYS_CUST_CSR%ROWTYPE; bug 7350165
2743: l_sys_acct_rec SYS_ACCOUNT_CSR%ROWTYPE;
2744: l_mu_sys_error_tbl csi_mass_edit_pub.mass_edit_sys_error_tbl;
2745: l_errors_found VARCHAR2(1) := 'N';
2746: l_warnings_found VARCHAR2(1) := 'N';
2747:
2748: BEGIN

Line 2889: End CSI_MASS_EDIT_PUB;

2885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2886:
2887: END VALIDATE_SYSTEM_BATCH; -- VALIDATE_SYSTEM_BATCH
2888:
2889: End CSI_MASS_EDIT_PUB;