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.12020000.2 2012/07/04 11:07:31 sjawaji ship $ */
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.12020000.2 2012/07/04 11:07:31 sjawaji ship $ */
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: l_CSI_DEBUG_LEVEL NUMBER;

Line 2975: p_instance_asset_sync_tbl IN CSI_ASSET_PVT.instance_asset_sync_tbl,

2971:
2972: PROCEDURE get_attached_item_instances
2973: ( p_api_version IN NUMBER,
2974: p_init_msg_list IN VARCHAR2,
2975: p_instance_asset_sync_tbl IN CSI_ASSET_PVT.instance_asset_sync_tbl,
2976: x_instance_sync_tbl OUT NOCOPY CSI_ASSET_PVT.instance_sync_tbl,
2977: x_return_status OUT NOCOPY VARCHAR2,
2978: x_msg_count OUT NOCOPY NUMBER,
2979: x_msg_data OUT NOCOPY VARCHAR2,

Line 2976: x_instance_sync_tbl OUT NOCOPY CSI_ASSET_PVT.instance_sync_tbl,

2972: PROCEDURE get_attached_item_instances
2973: ( p_api_version IN NUMBER,
2974: p_init_msg_list IN VARCHAR2,
2975: p_instance_asset_sync_tbl IN CSI_ASSET_PVT.instance_asset_sync_tbl,
2976: x_instance_sync_tbl OUT NOCOPY CSI_ASSET_PVT.instance_sync_tbl,
2977: x_return_status OUT NOCOPY VARCHAR2,
2978: x_msg_count OUT NOCOPY NUMBER,
2979: x_msg_data OUT NOCOPY VARCHAR2,
2980: p_source_system_name IN VARCHAR2 DEFAULT NULL,

Line 3151: p_instance_sync_tbl IN CSI_ASSET_PVT.instance_sync_tbl,

3147:
3148: PROCEDURE get_attached_asset_links
3149: ( p_api_version IN NUMBER,
3150: p_init_msg_list IN VARCHAR2,
3151: p_instance_sync_tbl IN CSI_ASSET_PVT.instance_sync_tbl,
3152: x_instance_asset_sync_tbl OUT NOCOPY CSI_ASSET_PVT.instance_asset_sync_tbl,
3153: x_return_status OUT NOCOPY VARCHAR2,
3154: x_msg_count OUT NOCOPY NUMBER,
3155: x_msg_data OUT NOCOPY VARCHAR2,

Line 3152: x_instance_asset_sync_tbl OUT NOCOPY CSI_ASSET_PVT.instance_asset_sync_tbl,

3148: PROCEDURE get_attached_asset_links
3149: ( p_api_version IN NUMBER,
3150: p_init_msg_list IN VARCHAR2,
3151: p_instance_sync_tbl IN CSI_ASSET_PVT.instance_sync_tbl,
3152: x_instance_asset_sync_tbl OUT NOCOPY CSI_ASSET_PVT.instance_asset_sync_tbl,
3153: x_return_status OUT NOCOPY VARCHAR2,
3154: x_msg_count OUT NOCOPY NUMBER,
3155: x_msg_data OUT NOCOPY VARCHAR2,
3156: p_source_system_name IN VARCHAR2 DEFAULT NULL,

Line 3301: p_instance_asset_sync_tbl IN CSI_ASSET_PVT.instance_asset_sync_tbl,

3297:
3298: PROCEDURE get_fa_asset_details
3299: ( p_api_version IN NUMBER,
3300: p_init_msg_list IN VARCHAR2,
3301: p_instance_asset_sync_tbl IN CSI_ASSET_PVT.instance_asset_sync_tbl,
3302: x_fa_asset_sync_tab OUT NOCOPY CSI_ASSET_PVT.fa_asset_sync_tbl,
3303: x_return_status OUT NOCOPY VARCHAR2,
3304: x_msg_count OUT NOCOPY NUMBER,
3305: x_msg_data OUT NOCOPY VARCHAR2,

Line 3302: x_fa_asset_sync_tab OUT NOCOPY CSI_ASSET_PVT.fa_asset_sync_tbl,

3298: PROCEDURE get_fa_asset_details
3299: ( p_api_version IN NUMBER,
3300: p_init_msg_list IN VARCHAR2,
3301: p_instance_asset_sync_tbl IN CSI_ASSET_PVT.instance_asset_sync_tbl,
3302: x_fa_asset_sync_tab OUT NOCOPY CSI_ASSET_PVT.fa_asset_sync_tbl,
3303: x_return_status OUT NOCOPY VARCHAR2,
3304: x_msg_count OUT NOCOPY NUMBER,
3305: x_msg_data OUT NOCOPY VARCHAR2,
3306: p_source_system_name IN VARCHAR2 DEFAULT NULL,

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

3410: p_data => x_msg_data );
3411: END get_fa_asset_details ;
3412:
3413: PROCEDURE Get_syncup_tree
3414: ( px_instance_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.instance_sync_tbl,
3415: px_instance_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.instance_asset_sync_tbl,
3416: x_fa_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.fa_asset_sync_tbl,
3417: x_return_status OUT NOCOPY VARCHAR2,
3418: x_error_msg OUT NOCOPY VARCHAR2,

Line 3415: px_instance_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.instance_asset_sync_tbl,

3411: END get_fa_asset_details ;
3412:
3413: PROCEDURE Get_syncup_tree
3414: ( px_instance_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.instance_sync_tbl,
3415: px_instance_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.instance_asset_sync_tbl,
3416: x_fa_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.fa_asset_sync_tbl,
3417: x_return_status OUT NOCOPY VARCHAR2,
3418: x_error_msg OUT NOCOPY VARCHAR2,
3419: p_source_system_name IN VARCHAR2 DEFAULT NULL,

Line 3416: x_fa_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.fa_asset_sync_tbl,

3412:
3413: PROCEDURE Get_syncup_tree
3414: ( px_instance_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.instance_sync_tbl,
3415: px_instance_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.instance_asset_sync_tbl,
3416: x_fa_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.fa_asset_sync_tbl,
3417: x_return_status OUT NOCOPY VARCHAR2,
3418: x_error_msg OUT NOCOPY VARCHAR2,
3419: p_source_system_name IN VARCHAR2 DEFAULT NULL,
3420: p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false

Line 3423: l_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;

3419: p_source_system_name IN VARCHAR2 DEFAULT NULL,
3420: p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false
3421: ) IS
3422: l_csi_debug_level NUMBER := 0;
3423: l_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;
3424: l_tmp_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;
3425: l_instance_asset_sync_tbl CSI_ASSET_PVT.instance_asset_sync_tbl;
3426: l_tmp_instance_asset_sync_tbl CSI_ASSET_PVT.instance_asset_sync_tbl;
3427: l_fa_asset_sync_tbl CSI_ASSET_PVT.fa_asset_sync_tbl;

Line 3424: l_tmp_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;

3420: p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false
3421: ) IS
3422: l_csi_debug_level NUMBER := 0;
3423: l_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;
3424: l_tmp_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;
3425: l_instance_asset_sync_tbl CSI_ASSET_PVT.instance_asset_sync_tbl;
3426: l_tmp_instance_asset_sync_tbl CSI_ASSET_PVT.instance_asset_sync_tbl;
3427: l_fa_asset_sync_tbl CSI_ASSET_PVT.fa_asset_sync_tbl;
3428: l_Search_Flag VARCHAR2(1);

Line 3425: l_instance_asset_sync_tbl CSI_ASSET_PVT.instance_asset_sync_tbl;

3421: ) IS
3422: l_csi_debug_level NUMBER := 0;
3423: l_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;
3424: l_tmp_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;
3425: l_instance_asset_sync_tbl CSI_ASSET_PVT.instance_asset_sync_tbl;
3426: l_tmp_instance_asset_sync_tbl CSI_ASSET_PVT.instance_asset_sync_tbl;
3427: l_fa_asset_sync_tbl CSI_ASSET_PVT.fa_asset_sync_tbl;
3428: l_Search_Flag VARCHAR2(1);
3429: l_return_status VARCHAR2(1);

Line 3426: l_tmp_instance_asset_sync_tbl CSI_ASSET_PVT.instance_asset_sync_tbl;

3422: l_csi_debug_level NUMBER := 0;
3423: l_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;
3424: l_tmp_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;
3425: l_instance_asset_sync_tbl CSI_ASSET_PVT.instance_asset_sync_tbl;
3426: l_tmp_instance_asset_sync_tbl CSI_ASSET_PVT.instance_asset_sync_tbl;
3427: l_fa_asset_sync_tbl CSI_ASSET_PVT.fa_asset_sync_tbl;
3428: l_Search_Flag VARCHAR2(1);
3429: l_return_status VARCHAR2(1);
3430: l_msg_data VARCHAR2(500);

Line 3427: l_fa_asset_sync_tbl CSI_ASSET_PVT.fa_asset_sync_tbl;

3423: l_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;
3424: l_tmp_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;
3425: l_instance_asset_sync_tbl CSI_ASSET_PVT.instance_asset_sync_tbl;
3426: l_tmp_instance_asset_sync_tbl CSI_ASSET_PVT.instance_asset_sync_tbl;
3427: l_fa_asset_sync_tbl CSI_ASSET_PVT.fa_asset_sync_tbl;
3428: l_Search_Flag VARCHAR2(1);
3429: l_return_status VARCHAR2(1);
3430: l_msg_data VARCHAR2(500);
3431: l_msg_count NUMBER;

Line 3465: csi_asset_pvt.get_attached_asset_links

3461: WHILE l_process_loop
3462: LOOP
3463: IF l_Search_Flag = 'I' THEN
3464: l_instance_asset_sync_tbl.DELETE;
3465: csi_asset_pvt.get_attached_asset_links
3466: ( p_api_version => 1.0,
3467: p_init_msg_list => l_init_msg_list,
3468: p_instance_sync_tbl => l_instance_sync_tbl,
3469: x_instance_asset_sync_tbl => l_instance_asset_sync_tbl,

Line 3558: csi_asset_pvt.get_attached_item_instances

3554: END IF;
3555:
3556: ELSIF l_Search_Flag = 'A' THEN
3557: l_instance_sync_tbl.DELETE;
3558: csi_asset_pvt.get_attached_item_instances
3559: ( p_api_version => 1.0,
3560: p_init_msg_list => l_init_msg_list,
3561: p_instance_asset_sync_tbl => l_instance_asset_sync_tbl,
3562: x_instance_sync_tbl => l_instance_sync_tbl,

Line 3671: p_lookup_tbl IN OUT nocopy csi_asset_pvt.lookup_tbl,

3667: p_init_msg_list IN varchar2,
3668: p_validation_level IN number,
3669: p_instance_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_tbl,
3670: p_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
3671: p_lookup_tbl IN OUT nocopy csi_asset_pvt.lookup_tbl,
3672: p_asset_count_rec IN OUT nocopy csi_asset_pvt.asset_count_rec,
3673: p_asset_id_tbl IN OUT nocopy csi_asset_pvt.asset_id_tbl,
3674: p_asset_loc_tbl IN OUT nocopy csi_asset_pvt.asset_loc_tbl,
3675: x_return_status OUT nocopy varchar2,

Line 3672: p_asset_count_rec IN OUT nocopy csi_asset_pvt.asset_count_rec,

3668: p_validation_level IN number,
3669: p_instance_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_tbl,
3670: p_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
3671: p_lookup_tbl IN OUT nocopy csi_asset_pvt.lookup_tbl,
3672: p_asset_count_rec IN OUT nocopy csi_asset_pvt.asset_count_rec,
3673: p_asset_id_tbl IN OUT nocopy csi_asset_pvt.asset_id_tbl,
3674: p_asset_loc_tbl IN OUT nocopy csi_asset_pvt.asset_loc_tbl,
3675: x_return_status OUT nocopy varchar2,
3676: x_msg_count OUT nocopy number,

Line 3673: p_asset_id_tbl IN OUT nocopy csi_asset_pvt.asset_id_tbl,

3669: p_instance_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_tbl,
3670: p_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
3671: p_lookup_tbl IN OUT nocopy csi_asset_pvt.lookup_tbl,
3672: p_asset_count_rec IN OUT nocopy csi_asset_pvt.asset_count_rec,
3673: p_asset_id_tbl IN OUT nocopy csi_asset_pvt.asset_id_tbl,
3674: p_asset_loc_tbl IN OUT nocopy csi_asset_pvt.asset_loc_tbl,
3675: x_return_status OUT nocopy varchar2,
3676: x_msg_count OUT nocopy number,
3677: x_msg_data OUT nocopy varchar2)

Line 3674: p_asset_loc_tbl IN OUT nocopy csi_asset_pvt.asset_loc_tbl,

3670: p_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
3671: p_lookup_tbl IN OUT nocopy csi_asset_pvt.lookup_tbl,
3672: p_asset_count_rec IN OUT nocopy csi_asset_pvt.asset_count_rec,
3673: p_asset_id_tbl IN OUT nocopy csi_asset_pvt.asset_id_tbl,
3674: p_asset_loc_tbl IN OUT nocopy csi_asset_pvt.asset_loc_tbl,
3675: x_return_status OUT nocopy varchar2,
3676: x_msg_count OUT nocopy number,
3677: x_msg_data OUT nocopy varchar2)
3678: IS

Line 3728: END csi_asset_pvt;

3724: fnd_msg_pub.add_exc_msg(g_pkg_name , l_api_name);
3725: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
3726: END create_instance_assets;
3727:
3728: END csi_asset_pvt;
3729: