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_ASSET_PVT dependencies on CSI_ASSET_PVT

Line 1: PACKAGE BODY csi_asset_pvt AS

1: PACKAGE BODY csi_asset_pvt AS
2: /* $Header: csivaab.pls 120.18 2006/11/17 06:38:37 sumathur noship $ */
3:
4: g_pkg_name varchar2(30) := 'CSI_ASSET_PVT';
5:

Line 4: g_pkg_name varchar2(30) := 'CSI_ASSET_PVT';

1: PACKAGE BODY csi_asset_pvt AS
2: /* $Header: csivaab.pls 120.18 2006/11/17 06:38:37 sumathur noship $ */
3:
4: g_pkg_name varchar2(30) := 'CSI_ASSET_PVT';
5:
6: PROCEDURE debug( p_message IN varchar2) IS
7: BEGIN
8: csi_gen_utility_pvt.put_line(p_message);

Line 997: p_lookup_tbl IN OUT NOCOPY csi_asset_pvt.lookup_tbl,

993: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
994: x_return_status OUT NOCOPY VARCHAR2,
995: x_msg_count OUT NOCOPY NUMBER,
996: x_msg_data OUT NOCOPY VARCHAR2,
997: p_lookup_tbl IN OUT NOCOPY csi_asset_pvt.lookup_tbl,
998: p_asset_count_rec IN OUT NOCOPY csi_asset_pvt.asset_count_rec,
999: p_asset_id_tbl IN OUT NOCOPY csi_asset_pvt.asset_id_tbl,
1000: p_asset_loc_tbl IN OUT NOCOPY csi_asset_pvt.asset_loc_tbl,
1001: p_called_from_grp IN VARCHAR2)

Line 998: p_asset_count_rec IN OUT NOCOPY csi_asset_pvt.asset_count_rec,

994: x_return_status OUT NOCOPY VARCHAR2,
995: x_msg_count OUT NOCOPY NUMBER,
996: x_msg_data OUT NOCOPY VARCHAR2,
997: p_lookup_tbl IN OUT NOCOPY csi_asset_pvt.lookup_tbl,
998: p_asset_count_rec IN OUT NOCOPY csi_asset_pvt.asset_count_rec,
999: p_asset_id_tbl IN OUT NOCOPY csi_asset_pvt.asset_id_tbl,
1000: p_asset_loc_tbl IN OUT NOCOPY csi_asset_pvt.asset_loc_tbl,
1001: p_called_from_grp IN VARCHAR2)
1002: IS

Line 999: p_asset_id_tbl IN OUT NOCOPY csi_asset_pvt.asset_id_tbl,

995: x_msg_count OUT NOCOPY NUMBER,
996: x_msg_data OUT NOCOPY VARCHAR2,
997: p_lookup_tbl IN OUT NOCOPY csi_asset_pvt.lookup_tbl,
998: p_asset_count_rec IN OUT NOCOPY csi_asset_pvt.asset_count_rec,
999: p_asset_id_tbl IN OUT NOCOPY csi_asset_pvt.asset_id_tbl,
1000: p_asset_loc_tbl IN OUT NOCOPY csi_asset_pvt.asset_loc_tbl,
1001: p_called_from_grp IN VARCHAR2)
1002: IS
1003:

Line 1000: p_asset_loc_tbl IN OUT NOCOPY csi_asset_pvt.asset_loc_tbl,

996: x_msg_data OUT NOCOPY VARCHAR2,
997: p_lookup_tbl IN OUT NOCOPY csi_asset_pvt.lookup_tbl,
998: p_asset_count_rec IN OUT NOCOPY csi_asset_pvt.asset_count_rec,
999: p_asset_id_tbl IN OUT NOCOPY csi_asset_pvt.asset_id_tbl,
1000: p_asset_loc_tbl IN OUT NOCOPY csi_asset_pvt.asset_loc_tbl,
1001: p_called_from_grp IN VARCHAR2)
1002: IS
1003:
1004: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_INSTANCE_ASSET';

Line 1016: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;

1012: l_acct_class_code VARCHAR2(10);
1013: l_record_found BOOLEAN := FALSE;
1014: l_exists_flag VARCHAR2(1);
1015: l_valid_flag VARCHAR2(1);
1016: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
1017: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1018: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1019: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1020:

Line 1017: l_asset_count_rec csi_asset_pvt.asset_count_rec;

1013: l_record_found BOOLEAN := FALSE;
1014: l_exists_flag VARCHAR2(1);
1015: l_valid_flag VARCHAR2(1);
1016: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
1017: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1018: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1019: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1020:
1021: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 1018: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

1014: l_exists_flag VARCHAR2(1);
1015: l_valid_flag VARCHAR2(1);
1016: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
1017: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1018: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1019: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1020:
1021: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1022: l_error_message varchar2(2000);

Line 1019: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

1015: l_valid_flag VARCHAR2(1);
1016: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
1017: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1018: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1019: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1020:
1021: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1022: l_error_message varchar2(2000);
1023:

Line 1544: p_lookup_tbl IN OUT NOCOPY csi_asset_pvt.lookup_tbl,

1540: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
1541: x_return_status OUT NOCOPY VARCHAR2,
1542: x_msg_count OUT NOCOPY NUMBER,
1543: x_msg_data OUT NOCOPY VARCHAR2,
1544: p_lookup_tbl IN OUT NOCOPY csi_asset_pvt.lookup_tbl,
1545: p_asset_count_rec IN OUT NOCOPY csi_asset_pvt.asset_count_rec,
1546: p_asset_id_tbl IN OUT NOCOPY csi_asset_pvt.asset_id_tbl,
1547: p_asset_loc_tbl IN OUT NOCOPY csi_asset_pvt.asset_loc_tbl )
1548: IS

Line 1545: p_asset_count_rec IN OUT NOCOPY csi_asset_pvt.asset_count_rec,

1541: x_return_status OUT NOCOPY VARCHAR2,
1542: x_msg_count OUT NOCOPY NUMBER,
1543: x_msg_data OUT NOCOPY VARCHAR2,
1544: p_lookup_tbl IN OUT NOCOPY csi_asset_pvt.lookup_tbl,
1545: p_asset_count_rec IN OUT NOCOPY csi_asset_pvt.asset_count_rec,
1546: p_asset_id_tbl IN OUT NOCOPY csi_asset_pvt.asset_id_tbl,
1547: p_asset_loc_tbl IN OUT NOCOPY csi_asset_pvt.asset_loc_tbl )
1548: IS
1549: l_api_name CONSTANT VARCHAR2(30) := 'update_instance_asset';

Line 1546: p_asset_id_tbl IN OUT NOCOPY csi_asset_pvt.asset_id_tbl,

1542: x_msg_count OUT NOCOPY NUMBER,
1543: x_msg_data OUT NOCOPY VARCHAR2,
1544: p_lookup_tbl IN OUT NOCOPY csi_asset_pvt.lookup_tbl,
1545: p_asset_count_rec IN OUT NOCOPY csi_asset_pvt.asset_count_rec,
1546: p_asset_id_tbl IN OUT NOCOPY csi_asset_pvt.asset_id_tbl,
1547: p_asset_loc_tbl IN OUT NOCOPY csi_asset_pvt.asset_loc_tbl )
1548: IS
1549: l_api_name CONSTANT VARCHAR2(30) := 'update_instance_asset';
1550: l_api_version CONSTANT NUMBER := 1.0;

Line 1547: p_asset_loc_tbl IN OUT NOCOPY csi_asset_pvt.asset_loc_tbl )

1543: x_msg_data OUT NOCOPY VARCHAR2,
1544: p_lookup_tbl IN OUT NOCOPY csi_asset_pvt.lookup_tbl,
1545: p_asset_count_rec IN OUT NOCOPY csi_asset_pvt.asset_count_rec,
1546: p_asset_id_tbl IN OUT NOCOPY csi_asset_pvt.asset_id_tbl,
1547: p_asset_loc_tbl IN OUT NOCOPY csi_asset_pvt.asset_loc_tbl )
1548: IS
1549: l_api_name CONSTANT VARCHAR2(30) := 'update_instance_asset';
1550: l_api_version CONSTANT NUMBER := 1.0;
1551: l_CSI_DEBUG_LEVEL NUMBER;

Line 2615: csi_asset_pvt.resolve_id_columns

2611: END IF;
2612: --
2613:
2614: l_old_ins_asset_tbl(1):=l_old_ins_asset_rec;
2615: csi_asset_pvt.resolve_id_columns
2616: (p_asset_header_tbl => l_old_ins_asset_tbl);
2617: l_old_ins_asset_rec:=l_old_ins_asset_tbl(1);
2618:
2619:

Line 2621: csi_asset_pvt.resolve_id_columns

2617: l_old_ins_asset_rec:=l_old_ins_asset_tbl(1);
2618:
2619:
2620: l_new_ins_asset_tbl(1):=l_new_ins_asset_rec;
2621: csi_asset_pvt.resolve_id_columns
2622: (p_asset_header_tbl => l_new_ins_asset_tbl);
2623: l_new_ins_asset_rec:=l_new_ins_asset_tbl(1);
2624:
2625: --

Line 2816: ( px_instance_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.instance_sync_tbl,

2812:
2813: END get_instance_asset_hist ;
2814:
2815: PROCEDURE asset_syncup_validation
2816: ( px_instance_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.instance_sync_tbl,
2817: px_instance_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.instance_asset_sync_tbl,
2818: px_fa_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.fa_asset_sync_tbl,
2819: x_error_msg OUT NOCOPY VARCHAR2,
2820: x_return_status OUT NOCOPY VARCHAR2

Line 2817: px_instance_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.instance_asset_sync_tbl,

2813: END get_instance_asset_hist ;
2814:
2815: PROCEDURE asset_syncup_validation
2816: ( px_instance_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.instance_sync_tbl,
2817: px_instance_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.instance_asset_sync_tbl,
2818: px_fa_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.fa_asset_sync_tbl,
2819: x_error_msg OUT NOCOPY VARCHAR2,
2820: x_return_status OUT NOCOPY VARCHAR2
2821: ) IS

Line 2818: px_fa_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.fa_asset_sync_tbl,

2814:
2815: PROCEDURE asset_syncup_validation
2816: ( px_instance_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.instance_sync_tbl,
2817: px_instance_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.instance_asset_sync_tbl,
2818: px_fa_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.fa_asset_sync_tbl,
2819: x_error_msg OUT NOCOPY VARCHAR2,
2820: x_return_status OUT NOCOPY VARCHAR2
2821: ) IS
2822: l_fa_asset_sync_tbl csi_asset_pvt.fa_asset_sync_tbl;

Line 2822: l_fa_asset_sync_tbl csi_asset_pvt.fa_asset_sync_tbl;

2818: px_fa_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.fa_asset_sync_tbl,
2819: x_error_msg OUT NOCOPY VARCHAR2,
2820: x_return_status OUT NOCOPY VARCHAR2
2821: ) IS
2822: l_fa_asset_sync_tbl csi_asset_pvt.fa_asset_sync_tbl;
2823: l_Sync_Flag VARCHAR2(1) := FND_API.G_TRUE;
2824: l_location_id NUMBER := 0;
2825: l_fa_location_id NUMBER := 0;
2826:

Line 2951: p_instance_asset_sync_tbl IN CSI_ASSET_PVT.instance_asset_sync_tbl,

2947:
2948: PROCEDURE get_attached_item_instances
2949: ( p_api_version IN NUMBER,
2950: p_init_msg_list IN VARCHAR2,
2951: p_instance_asset_sync_tbl IN CSI_ASSET_PVT.instance_asset_sync_tbl,
2952: x_instance_sync_tbl OUT NOCOPY CSI_ASSET_PVT.instance_sync_tbl,
2953: x_return_status OUT NOCOPY VARCHAR2,
2954: x_msg_count OUT NOCOPY NUMBER,
2955: x_msg_data OUT NOCOPY VARCHAR2,

Line 2952: x_instance_sync_tbl OUT NOCOPY CSI_ASSET_PVT.instance_sync_tbl,

2948: PROCEDURE get_attached_item_instances
2949: ( p_api_version IN NUMBER,
2950: p_init_msg_list IN VARCHAR2,
2951: p_instance_asset_sync_tbl IN CSI_ASSET_PVT.instance_asset_sync_tbl,
2952: x_instance_sync_tbl OUT NOCOPY CSI_ASSET_PVT.instance_sync_tbl,
2953: x_return_status OUT NOCOPY VARCHAR2,
2954: x_msg_count OUT NOCOPY NUMBER,
2955: x_msg_data OUT NOCOPY VARCHAR2,
2956: p_source_system_name IN VARCHAR2 DEFAULT NULL,

Line 3127: p_instance_sync_tbl IN CSI_ASSET_PVT.instance_sync_tbl,

3123:
3124: PROCEDURE get_attached_asset_links
3125: ( p_api_version IN NUMBER,
3126: p_init_msg_list IN VARCHAR2,
3127: p_instance_sync_tbl IN CSI_ASSET_PVT.instance_sync_tbl,
3128: x_instance_asset_sync_tbl OUT NOCOPY CSI_ASSET_PVT.instance_asset_sync_tbl,
3129: x_return_status OUT NOCOPY VARCHAR2,
3130: x_msg_count OUT NOCOPY NUMBER,
3131: x_msg_data OUT NOCOPY VARCHAR2,

Line 3128: x_instance_asset_sync_tbl OUT NOCOPY CSI_ASSET_PVT.instance_asset_sync_tbl,

3124: PROCEDURE get_attached_asset_links
3125: ( p_api_version IN NUMBER,
3126: p_init_msg_list IN VARCHAR2,
3127: p_instance_sync_tbl IN CSI_ASSET_PVT.instance_sync_tbl,
3128: x_instance_asset_sync_tbl OUT NOCOPY CSI_ASSET_PVT.instance_asset_sync_tbl,
3129: x_return_status OUT NOCOPY VARCHAR2,
3130: x_msg_count OUT NOCOPY NUMBER,
3131: x_msg_data OUT NOCOPY VARCHAR2,
3132: p_source_system_name IN VARCHAR2 DEFAULT NULL,

Line 3277: p_instance_asset_sync_tbl IN CSI_ASSET_PVT.instance_asset_sync_tbl,

3273:
3274: PROCEDURE get_fa_asset_details
3275: ( p_api_version IN NUMBER,
3276: p_init_msg_list IN VARCHAR2,
3277: p_instance_asset_sync_tbl IN CSI_ASSET_PVT.instance_asset_sync_tbl,
3278: x_fa_asset_sync_tab OUT NOCOPY CSI_ASSET_PVT.fa_asset_sync_tbl,
3279: x_return_status OUT NOCOPY VARCHAR2,
3280: x_msg_count OUT NOCOPY NUMBER,
3281: x_msg_data OUT NOCOPY VARCHAR2,

Line 3278: x_fa_asset_sync_tab OUT NOCOPY CSI_ASSET_PVT.fa_asset_sync_tbl,

3274: PROCEDURE get_fa_asset_details
3275: ( p_api_version IN NUMBER,
3276: p_init_msg_list IN VARCHAR2,
3277: p_instance_asset_sync_tbl IN CSI_ASSET_PVT.instance_asset_sync_tbl,
3278: x_fa_asset_sync_tab OUT NOCOPY CSI_ASSET_PVT.fa_asset_sync_tbl,
3279: x_return_status OUT NOCOPY VARCHAR2,
3280: x_msg_count OUT NOCOPY NUMBER,
3281: x_msg_data OUT NOCOPY VARCHAR2,
3282: p_source_system_name IN VARCHAR2 DEFAULT NULL,

Line 3390: ( px_instance_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.instance_sync_tbl,

3386: p_data => x_msg_data );
3387: END get_fa_asset_details ;
3388:
3389: PROCEDURE Get_syncup_tree
3390: ( px_instance_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.instance_sync_tbl,
3391: px_instance_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.instance_asset_sync_tbl,
3392: x_fa_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.fa_asset_sync_tbl,
3393: x_return_status OUT NOCOPY VARCHAR2,
3394: x_error_msg OUT NOCOPY VARCHAR2,

Line 3391: px_instance_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.instance_asset_sync_tbl,

3387: END get_fa_asset_details ;
3388:
3389: PROCEDURE Get_syncup_tree
3390: ( px_instance_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.instance_sync_tbl,
3391: px_instance_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.instance_asset_sync_tbl,
3392: x_fa_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.fa_asset_sync_tbl,
3393: x_return_status OUT NOCOPY VARCHAR2,
3394: x_error_msg OUT NOCOPY VARCHAR2,
3395: p_source_system_name IN VARCHAR2 DEFAULT NULL,

Line 3392: x_fa_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.fa_asset_sync_tbl,

3388:
3389: PROCEDURE Get_syncup_tree
3390: ( px_instance_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.instance_sync_tbl,
3391: px_instance_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.instance_asset_sync_tbl,
3392: x_fa_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.fa_asset_sync_tbl,
3393: x_return_status OUT NOCOPY VARCHAR2,
3394: x_error_msg OUT NOCOPY VARCHAR2,
3395: p_source_system_name IN VARCHAR2 DEFAULT NULL,
3396: p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false

Line 3399: l_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;

3395: p_source_system_name IN VARCHAR2 DEFAULT NULL,
3396: p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false
3397: ) IS
3398: l_csi_debug_level NUMBER := 0;
3399: l_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;
3400: l_tmp_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;
3401: l_instance_asset_sync_tbl CSI_ASSET_PVT.instance_asset_sync_tbl;
3402: l_tmp_instance_asset_sync_tbl CSI_ASSET_PVT.instance_asset_sync_tbl;
3403: l_fa_asset_sync_tbl CSI_ASSET_PVT.fa_asset_sync_tbl;

Line 3400: l_tmp_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;

3396: p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false
3397: ) IS
3398: l_csi_debug_level NUMBER := 0;
3399: l_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;
3400: l_tmp_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;
3401: l_instance_asset_sync_tbl CSI_ASSET_PVT.instance_asset_sync_tbl;
3402: l_tmp_instance_asset_sync_tbl CSI_ASSET_PVT.instance_asset_sync_tbl;
3403: l_fa_asset_sync_tbl CSI_ASSET_PVT.fa_asset_sync_tbl;
3404: l_Search_Flag VARCHAR2(1);

Line 3401: l_instance_asset_sync_tbl CSI_ASSET_PVT.instance_asset_sync_tbl;

3397: ) IS
3398: l_csi_debug_level NUMBER := 0;
3399: l_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;
3400: l_tmp_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;
3401: l_instance_asset_sync_tbl CSI_ASSET_PVT.instance_asset_sync_tbl;
3402: l_tmp_instance_asset_sync_tbl CSI_ASSET_PVT.instance_asset_sync_tbl;
3403: l_fa_asset_sync_tbl CSI_ASSET_PVT.fa_asset_sync_tbl;
3404: l_Search_Flag VARCHAR2(1);
3405: l_return_status VARCHAR2(1);

Line 3402: l_tmp_instance_asset_sync_tbl CSI_ASSET_PVT.instance_asset_sync_tbl;

3398: l_csi_debug_level NUMBER := 0;
3399: l_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;
3400: l_tmp_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;
3401: l_instance_asset_sync_tbl CSI_ASSET_PVT.instance_asset_sync_tbl;
3402: l_tmp_instance_asset_sync_tbl CSI_ASSET_PVT.instance_asset_sync_tbl;
3403: l_fa_asset_sync_tbl CSI_ASSET_PVT.fa_asset_sync_tbl;
3404: l_Search_Flag VARCHAR2(1);
3405: l_return_status VARCHAR2(1);
3406: l_msg_data VARCHAR2(500);

Line 3403: l_fa_asset_sync_tbl CSI_ASSET_PVT.fa_asset_sync_tbl;

3399: l_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;
3400: l_tmp_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;
3401: l_instance_asset_sync_tbl CSI_ASSET_PVT.instance_asset_sync_tbl;
3402: l_tmp_instance_asset_sync_tbl CSI_ASSET_PVT.instance_asset_sync_tbl;
3403: l_fa_asset_sync_tbl CSI_ASSET_PVT.fa_asset_sync_tbl;
3404: l_Search_Flag VARCHAR2(1);
3405: l_return_status VARCHAR2(1);
3406: l_msg_data VARCHAR2(500);
3407: l_msg_count NUMBER;

Line 3441: csi_asset_pvt.get_attached_asset_links

3437: WHILE l_process_loop
3438: LOOP
3439: IF l_Search_Flag = 'I' THEN
3440: l_instance_asset_sync_tbl.DELETE;
3441: csi_asset_pvt.get_attached_asset_links
3442: ( p_api_version => 1.0,
3443: p_init_msg_list => l_init_msg_list,
3444: p_instance_sync_tbl => l_instance_sync_tbl,
3445: x_instance_asset_sync_tbl => l_instance_asset_sync_tbl,

Line 3534: csi_asset_pvt.get_attached_item_instances

3530: END IF;
3531:
3532: ELSIF l_Search_Flag = 'A' THEN
3533: l_instance_sync_tbl.DELETE;
3534: csi_asset_pvt.get_attached_item_instances
3535: ( p_api_version => 1.0,
3536: p_init_msg_list => l_init_msg_list,
3537: p_instance_asset_sync_tbl => l_instance_asset_sync_tbl,
3538: x_instance_sync_tbl => l_instance_sync_tbl,

Line 3647: p_lookup_tbl IN OUT nocopy csi_asset_pvt.lookup_tbl,

3643: p_init_msg_list IN varchar2,
3644: p_validation_level IN number,
3645: p_instance_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_tbl,
3646: p_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
3647: p_lookup_tbl IN OUT nocopy csi_asset_pvt.lookup_tbl,
3648: p_asset_count_rec IN OUT nocopy csi_asset_pvt.asset_count_rec,
3649: p_asset_id_tbl IN OUT nocopy csi_asset_pvt.asset_id_tbl,
3650: p_asset_loc_tbl IN OUT nocopy csi_asset_pvt.asset_loc_tbl,
3651: x_return_status OUT nocopy varchar2,

Line 3648: p_asset_count_rec IN OUT nocopy csi_asset_pvt.asset_count_rec,

3644: p_validation_level IN number,
3645: p_instance_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_tbl,
3646: p_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
3647: p_lookup_tbl IN OUT nocopy csi_asset_pvt.lookup_tbl,
3648: p_asset_count_rec IN OUT nocopy csi_asset_pvt.asset_count_rec,
3649: p_asset_id_tbl IN OUT nocopy csi_asset_pvt.asset_id_tbl,
3650: p_asset_loc_tbl IN OUT nocopy csi_asset_pvt.asset_loc_tbl,
3651: x_return_status OUT nocopy varchar2,
3652: x_msg_count OUT nocopy number,

Line 3649: p_asset_id_tbl IN OUT nocopy csi_asset_pvt.asset_id_tbl,

3645: p_instance_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_tbl,
3646: p_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
3647: p_lookup_tbl IN OUT nocopy csi_asset_pvt.lookup_tbl,
3648: p_asset_count_rec IN OUT nocopy csi_asset_pvt.asset_count_rec,
3649: p_asset_id_tbl IN OUT nocopy csi_asset_pvt.asset_id_tbl,
3650: p_asset_loc_tbl IN OUT nocopy csi_asset_pvt.asset_loc_tbl,
3651: x_return_status OUT nocopy varchar2,
3652: x_msg_count OUT nocopy number,
3653: x_msg_data OUT nocopy varchar2)

Line 3650: p_asset_loc_tbl IN OUT nocopy csi_asset_pvt.asset_loc_tbl,

3646: p_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
3647: p_lookup_tbl IN OUT nocopy csi_asset_pvt.lookup_tbl,
3648: p_asset_count_rec IN OUT nocopy csi_asset_pvt.asset_count_rec,
3649: p_asset_id_tbl IN OUT nocopy csi_asset_pvt.asset_id_tbl,
3650: p_asset_loc_tbl IN OUT nocopy csi_asset_pvt.asset_loc_tbl,
3651: x_return_status OUT nocopy varchar2,
3652: x_msg_count OUT nocopy number,
3653: x_msg_data OUT nocopy varchar2)
3654: IS

Line 3704: END csi_asset_pvt;

3700: fnd_msg_pub.add_exc_msg(g_pkg_name , l_api_name);
3701: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
3702: END create_instance_assets;
3703:
3704: END csi_asset_pvt;
3705: