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 303: --l_txn_rec csi_datastructures_pub.transaction_rec;

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;
306: l_error NUMBER := 0;
307: l_success NUMBER := 0;

Line 569: l_txn_rec csi_datastructures_pub.transaction_rec;

565: WHERE ciev.instance_id (+) = ctld.instance_id -- Bug 7613909
566: AND ctld.transaction_line_id = p_txn_line_id
567: AND ctld.instance_id is not null;
568: -- Local Variables
569: l_txn_rec csi_datastructures_pub.transaction_rec;
570:
571: -- Variables for Dummy record details
572: d_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
573: d_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;

Line 588: n_instance_tbl csi_datastructures_pub.instance_tbl;

584: l_msg_count NUMBER;
585: l_msg_data VARCHAR2(2000);
586:
587: -- New Tables for the selected instances in the batch
588: n_instance_tbl csi_datastructures_pub.instance_tbl;
589: n_party_tbl csi_datastructures_pub.party_tbl;
590: n_party_account_tbl csi_datastructures_pub.party_account_tbl;
591: n_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
592: n_price_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 589: n_party_tbl csi_datastructures_pub.party_tbl;

585: l_msg_data VARCHAR2(2000);
586:
587: -- New Tables for the selected instances in the batch
588: n_instance_tbl csi_datastructures_pub.instance_tbl;
589: n_party_tbl csi_datastructures_pub.party_tbl;
590: n_party_account_tbl csi_datastructures_pub.party_account_tbl;
591: n_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
592: n_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
593: n_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 590: n_party_account_tbl csi_datastructures_pub.party_account_tbl;

586:
587: -- New Tables for the selected instances in the batch
588: n_instance_tbl csi_datastructures_pub.instance_tbl;
589: n_party_tbl csi_datastructures_pub.party_tbl;
590: n_party_account_tbl csi_datastructures_pub.party_account_tbl;
591: n_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
592: n_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
593: n_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
594: n_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 591: n_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

587: -- New Tables for the selected instances in the batch
588: n_instance_tbl csi_datastructures_pub.instance_tbl;
589: n_party_tbl csi_datastructures_pub.party_tbl;
590: n_party_account_tbl csi_datastructures_pub.party_account_tbl;
591: n_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
592: n_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
593: n_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
594: n_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
595: n_txn_rec csi_datastructures_pub.transaction_rec;

Line 592: n_price_tbl csi_datastructures_pub.pricing_attribs_tbl;

588: n_instance_tbl csi_datastructures_pub.instance_tbl;
589: n_party_tbl csi_datastructures_pub.party_tbl;
590: n_party_account_tbl csi_datastructures_pub.party_account_tbl;
591: n_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
592: n_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
593: n_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
594: n_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
595: n_txn_rec csi_datastructures_pub.transaction_rec;
596: n_rel_txn_rec csi_datastructures_pub.transaction_rec;

Line 593: n_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

589: n_party_tbl csi_datastructures_pub.party_tbl;
590: n_party_account_tbl csi_datastructures_pub.party_account_tbl;
591: n_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
592: n_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
593: n_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
594: n_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
595: n_txn_rec csi_datastructures_pub.transaction_rec;
596: n_rel_txn_rec csi_datastructures_pub.transaction_rec;
597: n_grp_error_tbl csi_datastructures_pub.grp_upd_error_tbl;

Line 594: n_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

590: n_party_account_tbl csi_datastructures_pub.party_account_tbl;
591: n_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
592: n_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
593: n_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
594: n_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
595: n_txn_rec csi_datastructures_pub.transaction_rec;
596: n_rel_txn_rec csi_datastructures_pub.transaction_rec;
597: n_grp_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
598: n_instance_id_lst csi_datastructures_pub.id_tbl;

Line 595: n_txn_rec csi_datastructures_pub.transaction_rec;

591: n_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
592: n_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
593: n_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
594: n_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
595: n_txn_rec csi_datastructures_pub.transaction_rec;
596: n_rel_txn_rec csi_datastructures_pub.transaction_rec;
597: n_grp_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
598: n_instance_id_lst csi_datastructures_pub.id_tbl;
599:

Line 596: n_rel_txn_rec csi_datastructures_pub.transaction_rec;

592: n_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
593: n_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
594: n_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
595: n_txn_rec csi_datastructures_pub.transaction_rec;
596: n_rel_txn_rec csi_datastructures_pub.transaction_rec;
597: n_grp_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
598: n_instance_id_lst csi_datastructures_pub.id_tbl;
599:
600: l_api_version NUMBER:=1.0;

Line 597: n_grp_error_tbl csi_datastructures_pub.grp_upd_error_tbl;

593: n_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
594: n_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
595: n_txn_rec csi_datastructures_pub.transaction_rec;
596: n_rel_txn_rec csi_datastructures_pub.transaction_rec;
597: n_grp_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
598: n_instance_id_lst csi_datastructures_pub.id_tbl;
599:
600: l_api_version NUMBER:=1.0;
601: l_commit VARCHAR2(1) ;

Line 598: n_instance_id_lst csi_datastructures_pub.id_tbl;

594: n_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
595: n_txn_rec csi_datastructures_pub.transaction_rec;
596: n_rel_txn_rec csi_datastructures_pub.transaction_rec;
597: n_grp_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
598: n_instance_id_lst csi_datastructures_pub.id_tbl;
599:
600: l_api_version NUMBER:=1.0;
601: l_commit VARCHAR2(1) ;
602: l_msg_index NUMBER;

Line 2353: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl

2349: (
2350: p_api_version IN NUMBER
2351: ,p_commit IN VARCHAR2 := fnd_api.g_false
2352: ,p_entry_id IN NUMBER
2353: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
2354: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
2355: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
2356: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
2357: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

Line 2354: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl

2350: p_api_version IN NUMBER
2351: ,p_commit IN VARCHAR2 := fnd_api.g_false
2352: ,p_entry_id IN NUMBER
2353: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
2354: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
2355: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
2356: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
2357: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2358: ,x_return_status OUT NOCOPY VARCHAR2

Line 2355: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl

2351: ,p_commit IN VARCHAR2 := fnd_api.g_false
2352: ,p_entry_id IN NUMBER
2353: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
2354: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
2355: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
2356: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
2357: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2358: ,x_return_status OUT NOCOPY VARCHAR2
2359: ,x_msg_count OUT NOCOPY NUMBER

Line 2356: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl

2352: ,p_entry_id IN NUMBER
2353: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
2354: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
2355: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
2356: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
2357: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2358: ,x_return_status OUT NOCOPY VARCHAR2
2359: ,x_msg_count OUT NOCOPY NUMBER
2360: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2357: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

2353: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
2354: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
2355: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
2356: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
2357: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2358: ,x_return_status OUT NOCOPY VARCHAR2
2359: ,x_msg_count OUT NOCOPY NUMBER
2360: ,x_msg_data OUT NOCOPY VARCHAR2
2361: )

Line 2432: upd_system_tbl csi_datastructures_pub.mu_systems_tbl;

2428: l_api_version CONSTANT NUMBER := 1.0;
2429: l_debug_level NUMBER;
2430: l_txn_line_id NUMBER;
2431:
2432: upd_system_tbl csi_datastructures_pub.mu_systems_tbl;
2433: l_txn_sys_rec csi_datastructures_pub.system_rec;
2434: l_t_txn_sys_rec csi_t_datastructures_grp.txn_system_rec;
2435: l_mu_new_party_rec mu_new_party_csr%ROWTYPE;
2436: --l_mu_customer_id_rec mu_customer_id_csr%ROWTYPE; -- 7350165

Line 2433: l_txn_sys_rec csi_datastructures_pub.system_rec;

2429: l_debug_level NUMBER;
2430: l_txn_line_id NUMBER;
2431:
2432: upd_system_tbl csi_datastructures_pub.mu_systems_tbl;
2433: l_txn_sys_rec csi_datastructures_pub.system_rec;
2434: l_t_txn_sys_rec csi_t_datastructures_grp.txn_system_rec;
2435: l_mu_new_party_rec mu_new_party_csr%ROWTYPE;
2436: --l_mu_customer_id_rec mu_customer_id_csr%ROWTYPE; -- 7350165
2437: l_mu_system_rec mu_system_csr%ROWTYPE;

Line 2743: ,p_upd_system_tbl OUT NOCOPY csi_datastructures_pub.mu_systems_tbl

2739: /*----------------------------------------------------*/
2740: PROCEDURE IDENTIFY_SYSTEM_FOR_UPDATE
2741: (
2742: p_txn_line_id IN NUMBER
2743: ,p_upd_system_tbl OUT NOCOPY csi_datastructures_pub.mu_systems_tbl
2744: ,x_return_status OUT NOCOPY VARCHAR2
2745: )
2746: IS
2747:

Line 2831: ,p_upd_system_tbl IN csi_datastructures_pub.mu_systems_tbl

2827: PROCEDURE VALIDATE_SYSTEM_BATCH
2828: (
2829: p_entry_id IN NUMBER
2830: ,p_txn_line_id IN NUMBER
2831: ,p_upd_system_tbl IN csi_datastructures_pub.mu_systems_tbl
2832: ,x_return_status OUT NOCOPY VARCHAR2
2833: )
2834: IS
2835:

Line 3017: px_csi_txn_rec csi_datastructures_pub.transaction_rec;

3013: ,p_schedule_date DATE
3014: ) IS
3015:
3016:
3017: px_csi_txn_rec csi_datastructures_pub.transaction_rec;
3018: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3019: l_msg_count number;
3020: l_msg_data varchar2(2000);
3021: l_Error_Message varchar2(2000);

Line 3154: ,p_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

3150: PROCEDURE Process_webadi_create
3151: ( errbuf OUT NOCOPY VARCHAR2
3152: ,retcode OUT NOCOPY NUMBER
3153: ,p_Entry_id IN NUMBER
3154: ,p_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
3155: ) IS
3156:
3157: CURSOR instances_for_create_csr(p_entry_id IN NUMBER) IS
3158: SELECT

Line 3354: c_instance_tbl csi_datastructures_pub.instance_tbl;

3350: FROM CSI_WEBADI_STAGING
3351: where BATCH_ID = p_entry_id
3352: and INSTANCE_ID is null;
3353:
3354: c_instance_tbl csi_datastructures_pub.instance_tbl;
3355: c_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3356: c_party_tbl csi_datastructures_pub.party_tbl;
3357: c_account_tbl csi_datastructures_pub.party_account_tbl;
3358: c_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 3355: c_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

3351: where BATCH_ID = p_entry_id
3352: and INSTANCE_ID is null;
3353:
3354: c_instance_tbl csi_datastructures_pub.instance_tbl;
3355: c_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3356: c_party_tbl csi_datastructures_pub.party_tbl;
3357: c_account_tbl csi_datastructures_pub.party_account_tbl;
3358: c_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3359: c_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 3356: c_party_tbl csi_datastructures_pub.party_tbl;

3352: and INSTANCE_ID is null;
3353:
3354: c_instance_tbl csi_datastructures_pub.instance_tbl;
3355: c_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3356: c_party_tbl csi_datastructures_pub.party_tbl;
3357: c_account_tbl csi_datastructures_pub.party_account_tbl;
3358: c_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3359: c_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3360: c_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 3357: c_account_tbl csi_datastructures_pub.party_account_tbl;

3353:
3354: c_instance_tbl csi_datastructures_pub.instance_tbl;
3355: c_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3356: c_party_tbl csi_datastructures_pub.party_tbl;
3357: c_account_tbl csi_datastructures_pub.party_account_tbl;
3358: c_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3359: c_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3360: c_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
3361: c_csi_txn_tbl csi_datastructures_pub.transaction_tbl;

Line 3358: c_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

3354: c_instance_tbl csi_datastructures_pub.instance_tbl;
3355: c_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3356: c_party_tbl csi_datastructures_pub.party_tbl;
3357: c_account_tbl csi_datastructures_pub.party_account_tbl;
3358: c_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3359: c_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3360: c_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
3361: c_csi_txn_tbl csi_datastructures_pub.transaction_tbl;
3362: c_grp_error_tbl csi_datastructures_pub.grp_error_tbl;

Line 3359: c_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

3355: c_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3356: c_party_tbl csi_datastructures_pub.party_tbl;
3357: c_account_tbl csi_datastructures_pub.party_account_tbl;
3358: c_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3359: c_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3360: c_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
3361: c_csi_txn_tbl csi_datastructures_pub.transaction_tbl;
3362: c_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
3363: l_instance instances_for_create_csr%ROWTYPE;

Line 3360: c_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;

3356: c_party_tbl csi_datastructures_pub.party_tbl;
3357: c_account_tbl csi_datastructures_pub.party_account_tbl;
3358: c_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3359: c_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3360: c_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
3361: c_csi_txn_tbl csi_datastructures_pub.transaction_tbl;
3362: c_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
3363: l_instance instances_for_create_csr%ROWTYPE;
3364: c_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 3361: c_csi_txn_tbl csi_datastructures_pub.transaction_tbl;

3357: c_account_tbl csi_datastructures_pub.party_account_tbl;
3358: c_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3359: c_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3360: c_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
3361: c_csi_txn_tbl csi_datastructures_pub.transaction_tbl;
3362: c_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
3363: l_instance instances_for_create_csr%ROWTYPE;
3364: c_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
3365: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 3362: c_grp_error_tbl csi_datastructures_pub.grp_error_tbl;

3358: c_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3359: c_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3360: c_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
3361: c_csi_txn_tbl csi_datastructures_pub.transaction_tbl;
3362: c_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
3363: l_instance instances_for_create_csr%ROWTYPE;
3364: c_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
3365: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
3366: c_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 3364: c_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

3360: c_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
3361: c_csi_txn_tbl csi_datastructures_pub.transaction_tbl;
3362: c_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
3363: l_instance instances_for_create_csr%ROWTYPE;
3364: c_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
3365: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
3366: c_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
3367: TYPE number_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
3368: l_chr_id_tbl number_tbl;

Line 3365: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

3361: c_csi_txn_tbl csi_datastructures_pub.transaction_tbl;
3362: c_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
3363: l_instance instances_for_create_csr%ROWTYPE;
3364: c_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
3365: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
3366: c_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
3367: TYPE number_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
3368: l_chr_id_tbl number_tbl;
3369: l_attach2_line_id_tbl number_tbl;

Line 3366: c_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

3362: c_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
3363: l_instance instances_for_create_csr%ROWTYPE;
3364: c_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
3365: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
3366: c_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
3367: TYPE number_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
3368: l_chr_id_tbl number_tbl;
3369: l_attach2_line_id_tbl number_tbl;
3370: l_covlvl_id NUMBER;

Line 4382: ,p_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

4378: PROCEDURE Process_webadi_update
4379: ( errbuf OUT NOCOPY VARCHAR2
4380: ,retcode OUT NOCOPY NUMBER
4381: ,p_Entry_id IN NUMBER
4382: ,p_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
4383: ) IS
4384:
4385: CURSOR instances_for_update_csr(p_entry_id IN NUMBER) IS
4386: SELECT

Line 4584: px_csi_txn_rec csi_datastructures_pub.transaction_rec;

4580: where BATCH_ID = p_entry_id
4581: and INSTANCE_ID is not null;
4582:
4583:
4584: px_csi_txn_rec csi_datastructures_pub.transaction_rec;
4585: u_instance_tbl csi_datastructures_pub.instance_tbl;
4586: u_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4587: u_party_tbl csi_datastructures_pub.party_tbl;
4588: u_account_tbl csi_datastructures_pub.party_account_tbl;

Line 4585: u_instance_tbl csi_datastructures_pub.instance_tbl;

4581: and INSTANCE_ID is not null;
4582:
4583:
4584: px_csi_txn_rec csi_datastructures_pub.transaction_rec;
4585: u_instance_tbl csi_datastructures_pub.instance_tbl;
4586: u_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4587: u_party_tbl csi_datastructures_pub.party_tbl;
4588: u_account_tbl csi_datastructures_pub.party_account_tbl;
4589: u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 4586: u_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4582:
4583:
4584: px_csi_txn_rec csi_datastructures_pub.transaction_rec;
4585: u_instance_tbl csi_datastructures_pub.instance_tbl;
4586: u_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4587: u_party_tbl csi_datastructures_pub.party_tbl;
4588: u_account_tbl csi_datastructures_pub.party_account_tbl;
4589: u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4590: u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 4587: u_party_tbl csi_datastructures_pub.party_tbl;

4583:
4584: px_csi_txn_rec csi_datastructures_pub.transaction_rec;
4585: u_instance_tbl csi_datastructures_pub.instance_tbl;
4586: u_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4587: u_party_tbl csi_datastructures_pub.party_tbl;
4588: u_account_tbl csi_datastructures_pub.party_account_tbl;
4589: u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4590: u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4591: u_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 4588: u_account_tbl csi_datastructures_pub.party_account_tbl;

4584: px_csi_txn_rec csi_datastructures_pub.transaction_rec;
4585: u_instance_tbl csi_datastructures_pub.instance_tbl;
4586: u_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4587: u_party_tbl csi_datastructures_pub.party_tbl;
4588: u_account_tbl csi_datastructures_pub.party_account_tbl;
4589: u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4590: u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4591: u_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4592: u_csi_txn_tbl csi_datastructures_pub.transaction_tbl;

Line 4589: u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

4585: u_instance_tbl csi_datastructures_pub.instance_tbl;
4586: u_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4587: u_party_tbl csi_datastructures_pub.party_tbl;
4588: u_account_tbl csi_datastructures_pub.party_account_tbl;
4589: u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4590: u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4591: u_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4592: u_csi_txn_tbl csi_datastructures_pub.transaction_tbl;
4593: u_grp_upd_error_tbl csi_datastructures_pub.grp_upd_error_tbl;

Line 4590: u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

4586: u_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4587: u_party_tbl csi_datastructures_pub.party_tbl;
4588: u_account_tbl csi_datastructures_pub.party_account_tbl;
4589: u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4590: u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4591: u_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4592: u_csi_txn_tbl csi_datastructures_pub.transaction_tbl;
4593: u_grp_upd_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
4594: l_instance_id_lst csi_datastructures_pub.id_tbl;

Line 4591: u_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;

4587: u_party_tbl csi_datastructures_pub.party_tbl;
4588: u_account_tbl csi_datastructures_pub.party_account_tbl;
4589: u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4590: u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4591: u_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4592: u_csi_txn_tbl csi_datastructures_pub.transaction_tbl;
4593: u_grp_upd_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
4594: l_instance_id_lst csi_datastructures_pub.id_tbl;
4595: l_instance instances_for_update_csr%ROWTYPE;

Line 4592: u_csi_txn_tbl csi_datastructures_pub.transaction_tbl;

4588: u_account_tbl csi_datastructures_pub.party_account_tbl;
4589: u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4590: u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4591: u_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4592: u_csi_txn_tbl csi_datastructures_pub.transaction_tbl;
4593: u_grp_upd_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
4594: l_instance_id_lst csi_datastructures_pub.id_tbl;
4595: l_instance instances_for_update_csr%ROWTYPE;
4596: c_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 4593: u_grp_upd_error_tbl csi_datastructures_pub.grp_upd_error_tbl;

4589: u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4590: u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4591: u_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4592: u_csi_txn_tbl csi_datastructures_pub.transaction_tbl;
4593: u_grp_upd_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
4594: l_instance_id_lst csi_datastructures_pub.id_tbl;
4595: l_instance instances_for_update_csr%ROWTYPE;
4596: c_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
4597: e_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 4594: l_instance_id_lst csi_datastructures_pub.id_tbl;

4590: u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4591: u_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4592: u_csi_txn_tbl csi_datastructures_pub.transaction_tbl;
4593: u_grp_upd_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
4594: l_instance_id_lst csi_datastructures_pub.id_tbl;
4595: l_instance instances_for_update_csr%ROWTYPE;
4596: c_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
4597: e_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
4598: l_instance_split_tbl csi_datastructures_pub.instance_tbl;

Line 4596: c_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

4592: u_csi_txn_tbl csi_datastructures_pub.transaction_tbl;
4593: u_grp_upd_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
4594: l_instance_id_lst csi_datastructures_pub.id_tbl;
4595: l_instance instances_for_update_csr%ROWTYPE;
4596: c_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
4597: e_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
4598: l_instance_split_tbl csi_datastructures_pub.instance_tbl;
4599: c_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4600: u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 4597: e_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

4593: u_grp_upd_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
4594: l_instance_id_lst csi_datastructures_pub.id_tbl;
4595: l_instance instances_for_update_csr%ROWTYPE;
4596: c_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
4597: e_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
4598: l_instance_split_tbl csi_datastructures_pub.instance_tbl;
4599: c_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4600: u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4601: TYPE varchar_tbl IS TABLE OF Varchar2(30) INDEX BY BINARY_INTEGER;

Line 4598: l_instance_split_tbl csi_datastructures_pub.instance_tbl;

4594: l_instance_id_lst csi_datastructures_pub.id_tbl;
4595: l_instance instances_for_update_csr%ROWTYPE;
4596: c_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
4597: e_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
4598: l_instance_split_tbl csi_datastructures_pub.instance_tbl;
4599: c_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4600: u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4601: TYPE varchar_tbl IS TABLE OF Varchar2(30) INDEX BY BINARY_INTEGER;
4602: l_split_inst_num_tbl varchar_tbl;

Line 4599: c_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

4595: l_instance instances_for_update_csr%ROWTYPE;
4596: c_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
4597: e_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
4598: l_instance_split_tbl csi_datastructures_pub.instance_tbl;
4599: c_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4600: u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4601: TYPE varchar_tbl IS TABLE OF Varchar2(30) INDEX BY BINARY_INTEGER;
4602: l_split_inst_num_tbl varchar_tbl;
4603: l_oks_inst_num_tbl varchar_tbl;

Line 4600: u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

4596: c_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
4597: e_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
4598: l_instance_split_tbl csi_datastructures_pub.instance_tbl;
4599: c_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4600: u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4601: TYPE varchar_tbl IS TABLE OF Varchar2(30) INDEX BY BINARY_INTEGER;
4602: l_split_inst_num_tbl varchar_tbl;
4603: l_oks_inst_num_tbl varchar_tbl;
4604: TYPE number_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 4609: l_split_new_inst_rec csi_datastructures_pub.instance_rec;

4605: l_chr_id_tbl number_tbl;
4606: l_attach2_line_id_tbl number_tbl;
4607: l_covlvl_id NUMBER;
4608: l_cov_line_tbl OKS_IBINT_PUB.k_cov_line_tbl;
4609: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
4610: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4611: l_msg_count number;
4612: l_msg_data varchar2(2000);
4613: inst_idx PLS_INTEGER;

Line 4643: l_rel_instance_id_lst csi_datastructures_pub.id_tbl;

4639: l_rel_obj_ver NUMBER;
4640: l_relationship_id NUMBER;
4641: l_old_par_instance_id NUMBER;
4642: l_par_instance_id NUMBER;
4643: l_rel_instance_id_lst csi_datastructures_pub.id_tbl;
4644: l_instance_number VARCHAR2(30);
4645: l_serial_number_control_code NUMBER;
4646: l_old_version_label VARCHAR2(30);
4647: l_object_version_number NUMBER;