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_DATASTRUCTURES_PUB

Line 299: --l_txn_rec csi_datastructures_pub.transaction_rec;

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;
302: l_error NUMBER := 0;
303: l_success NUMBER := 0;

Line 469: l_txn_rec csi_datastructures_pub.transaction_rec;

465: WHERE ciev.instance_id = ctld.instance_id
466: AND ctld.transaction_line_id = p_txn_line_id
467: AND ctld.instance_id is not null;
468: -- Local Variables
469: l_txn_rec csi_datastructures_pub.transaction_rec;
470:
471: -- Variables for Dummy record details
472: d_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
473: d_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;

Line 488: n_instance_tbl csi_datastructures_pub.instance_tbl;

484: l_msg_count NUMBER;
485: l_msg_data VARCHAR2(2000);
486:
487: -- New Tables for the selected instances in the batch
488: n_instance_tbl csi_datastructures_pub.instance_tbl;
489: n_party_tbl csi_datastructures_pub.party_tbl;
490: n_party_account_tbl csi_datastructures_pub.party_account_tbl;
491: n_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
492: n_price_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 489: n_party_tbl csi_datastructures_pub.party_tbl;

485: l_msg_data VARCHAR2(2000);
486:
487: -- New Tables for the selected instances in the batch
488: n_instance_tbl csi_datastructures_pub.instance_tbl;
489: n_party_tbl csi_datastructures_pub.party_tbl;
490: n_party_account_tbl csi_datastructures_pub.party_account_tbl;
491: n_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
492: n_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
493: n_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 490: n_party_account_tbl csi_datastructures_pub.party_account_tbl;

486:
487: -- New Tables for the selected instances in the batch
488: n_instance_tbl csi_datastructures_pub.instance_tbl;
489: n_party_tbl csi_datastructures_pub.party_tbl;
490: n_party_account_tbl csi_datastructures_pub.party_account_tbl;
491: n_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
492: n_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
493: n_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
494: n_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 491: n_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

487: -- New Tables for the selected instances in the batch
488: n_instance_tbl csi_datastructures_pub.instance_tbl;
489: n_party_tbl csi_datastructures_pub.party_tbl;
490: n_party_account_tbl csi_datastructures_pub.party_account_tbl;
491: n_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
492: n_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
493: n_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
494: n_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
495: n_txn_rec csi_datastructures_pub.transaction_rec;

Line 492: n_price_tbl csi_datastructures_pub.pricing_attribs_tbl;

488: n_instance_tbl csi_datastructures_pub.instance_tbl;
489: n_party_tbl csi_datastructures_pub.party_tbl;
490: n_party_account_tbl csi_datastructures_pub.party_account_tbl;
491: n_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
492: n_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
493: n_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
494: n_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
495: n_txn_rec csi_datastructures_pub.transaction_rec;
496: n_rel_txn_rec csi_datastructures_pub.transaction_rec;

Line 493: n_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

489: n_party_tbl csi_datastructures_pub.party_tbl;
490: n_party_account_tbl csi_datastructures_pub.party_account_tbl;
491: n_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
492: n_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
493: n_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
494: n_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
495: n_txn_rec csi_datastructures_pub.transaction_rec;
496: n_rel_txn_rec csi_datastructures_pub.transaction_rec;
497: n_grp_error_tbl csi_datastructures_pub.grp_upd_error_tbl;

Line 494: n_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

490: n_party_account_tbl csi_datastructures_pub.party_account_tbl;
491: n_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
492: n_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
493: n_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
494: n_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
495: n_txn_rec csi_datastructures_pub.transaction_rec;
496: n_rel_txn_rec csi_datastructures_pub.transaction_rec;
497: n_grp_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
498: n_instance_id_lst csi_datastructures_pub.id_tbl;

Line 495: n_txn_rec csi_datastructures_pub.transaction_rec;

491: n_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
492: n_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
493: n_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
494: n_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
495: n_txn_rec csi_datastructures_pub.transaction_rec;
496: n_rel_txn_rec csi_datastructures_pub.transaction_rec;
497: n_grp_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
498: n_instance_id_lst csi_datastructures_pub.id_tbl;
499:

Line 496: n_rel_txn_rec csi_datastructures_pub.transaction_rec;

492: n_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
493: n_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
494: n_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
495: n_txn_rec csi_datastructures_pub.transaction_rec;
496: n_rel_txn_rec csi_datastructures_pub.transaction_rec;
497: n_grp_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
498: n_instance_id_lst csi_datastructures_pub.id_tbl;
499:
500: l_api_version NUMBER:=1.0;

Line 497: n_grp_error_tbl csi_datastructures_pub.grp_upd_error_tbl;

493: n_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
494: n_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
495: n_txn_rec csi_datastructures_pub.transaction_rec;
496: n_rel_txn_rec csi_datastructures_pub.transaction_rec;
497: n_grp_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
498: n_instance_id_lst csi_datastructures_pub.id_tbl;
499:
500: l_api_version NUMBER:=1.0;
501: l_commit VARCHAR2(1) ;

Line 498: n_instance_id_lst csi_datastructures_pub.id_tbl;

494: n_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
495: n_txn_rec csi_datastructures_pub.transaction_rec;
496: n_rel_txn_rec csi_datastructures_pub.transaction_rec;
497: n_grp_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
498: n_instance_id_lst csi_datastructures_pub.id_tbl;
499:
500: l_api_version NUMBER:=1.0;
501: l_commit VARCHAR2(1) ;
502: l_msg_index NUMBER;

Line 2238: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl

2234: (
2235: p_api_version IN NUMBER
2236: ,p_commit IN VARCHAR2 := fnd_api.g_false
2237: ,p_entry_id IN NUMBER
2238: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
2239: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
2240: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
2241: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
2242: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

Line 2239: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl

2235: p_api_version IN NUMBER
2236: ,p_commit IN VARCHAR2 := fnd_api.g_false
2237: ,p_entry_id IN NUMBER
2238: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
2239: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
2240: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
2241: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
2242: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2243: ,x_return_status OUT NOCOPY VARCHAR2

Line 2240: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl

2236: ,p_commit IN VARCHAR2 := fnd_api.g_false
2237: ,p_entry_id IN NUMBER
2238: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
2239: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
2240: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
2241: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
2242: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2243: ,x_return_status OUT NOCOPY VARCHAR2
2244: ,x_msg_count OUT NOCOPY NUMBER

Line 2241: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl

2237: ,p_entry_id IN NUMBER
2238: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
2239: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
2240: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
2241: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
2242: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2243: ,x_return_status OUT NOCOPY VARCHAR2
2244: ,x_msg_count OUT NOCOPY NUMBER
2245: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2242: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

2238: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
2239: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
2240: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
2241: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
2242: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2243: ,x_return_status OUT NOCOPY VARCHAR2
2244: ,x_msg_count OUT NOCOPY NUMBER
2245: ,x_msg_data OUT NOCOPY VARCHAR2
2246: )

Line 2317: upd_system_tbl csi_datastructures_pub.mu_systems_tbl;

2313: l_api_version CONSTANT NUMBER := 1.0;
2314: l_debug_level NUMBER;
2315: l_txn_line_id NUMBER;
2316:
2317: upd_system_tbl csi_datastructures_pub.mu_systems_tbl;
2318: l_txn_sys_rec csi_datastructures_pub.system_rec;
2319: l_t_txn_sys_rec csi_t_datastructures_grp.txn_system_rec;
2320: l_mu_new_party_rec mu_new_party_csr%ROWTYPE;
2321: --l_mu_customer_id_rec mu_customer_id_csr%ROWTYPE; -- 7350165

Line 2318: l_txn_sys_rec csi_datastructures_pub.system_rec;

2314: l_debug_level NUMBER;
2315: l_txn_line_id NUMBER;
2316:
2317: upd_system_tbl csi_datastructures_pub.mu_systems_tbl;
2318: l_txn_sys_rec csi_datastructures_pub.system_rec;
2319: l_t_txn_sys_rec csi_t_datastructures_grp.txn_system_rec;
2320: l_mu_new_party_rec mu_new_party_csr%ROWTYPE;
2321: --l_mu_customer_id_rec mu_customer_id_csr%ROWTYPE; -- 7350165
2322: l_mu_system_rec mu_system_csr%ROWTYPE;

Line 2628: ,p_upd_system_tbl OUT NOCOPY csi_datastructures_pub.mu_systems_tbl

2624: /*----------------------------------------------------*/
2625: PROCEDURE IDENTIFY_SYSTEM_FOR_UPDATE
2626: (
2627: p_txn_line_id IN NUMBER
2628: ,p_upd_system_tbl OUT NOCOPY csi_datastructures_pub.mu_systems_tbl
2629: ,x_return_status OUT NOCOPY VARCHAR2
2630: )
2631: IS
2632:

Line 2716: ,p_upd_system_tbl IN csi_datastructures_pub.mu_systems_tbl

2712: PROCEDURE VALIDATE_SYSTEM_BATCH
2713: (
2714: p_entry_id IN NUMBER
2715: ,p_txn_line_id IN NUMBER
2716: ,p_upd_system_tbl IN csi_datastructures_pub.mu_systems_tbl
2717: ,x_return_status OUT NOCOPY VARCHAR2
2718: )
2719: IS
2720: