2: /* $Header: OKLRKWFB.pls 120.2.12010000.3 2009/10/01 21:56:14 rmunjulu ship $ */
3:
4: -- Rec Type to get and set notification body details
5: TYPE noti_rec_type IS RECORD (
6: success_main_body FND_NEW_MESSAGES.message_text%TYPE,
7: error_main_body FND_NEW_MESSAGES.message_text%TYPE,
8: termination_main_body FND_NEW_MESSAGES.message_text%TYPE,
9: return_main_body FND_NEW_MESSAGES.message_text%TYPE,
10: dispose_main_body FND_NEW_MESSAGES.message_text%TYPE,
3:
4: -- Rec Type to get and set notification body details
5: TYPE noti_rec_type IS RECORD (
6: success_main_body FND_NEW_MESSAGES.message_text%TYPE,
7: error_main_body FND_NEW_MESSAGES.message_text%TYPE,
8: termination_main_body FND_NEW_MESSAGES.message_text%TYPE,
9: return_main_body FND_NEW_MESSAGES.message_text%TYPE,
10: dispose_main_body FND_NEW_MESSAGES.message_text%TYPE,
11: scrap_main_body FND_NEW_MESSAGES.message_text%TYPE,
4: -- Rec Type to get and set notification body details
5: TYPE noti_rec_type IS RECORD (
6: success_main_body FND_NEW_MESSAGES.message_text%TYPE,
7: error_main_body FND_NEW_MESSAGES.message_text%TYPE,
8: termination_main_body FND_NEW_MESSAGES.message_text%TYPE,
9: return_main_body FND_NEW_MESSAGES.message_text%TYPE,
10: dispose_main_body FND_NEW_MESSAGES.message_text%TYPE,
11: scrap_main_body FND_NEW_MESSAGES.message_text%TYPE,
12: contract_dtls FND_NEW_MESSAGES.message_text%TYPE,
5: TYPE noti_rec_type IS RECORD (
6: success_main_body FND_NEW_MESSAGES.message_text%TYPE,
7: error_main_body FND_NEW_MESSAGES.message_text%TYPE,
8: termination_main_body FND_NEW_MESSAGES.message_text%TYPE,
9: return_main_body FND_NEW_MESSAGES.message_text%TYPE,
10: dispose_main_body FND_NEW_MESSAGES.message_text%TYPE,
11: scrap_main_body FND_NEW_MESSAGES.message_text%TYPE,
12: contract_dtls FND_NEW_MESSAGES.message_text%TYPE,
13: lease_contract FND_NEW_MESSAGES.message_text%TYPE,
6: success_main_body FND_NEW_MESSAGES.message_text%TYPE,
7: error_main_body FND_NEW_MESSAGES.message_text%TYPE,
8: termination_main_body FND_NEW_MESSAGES.message_text%TYPE,
9: return_main_body FND_NEW_MESSAGES.message_text%TYPE,
10: dispose_main_body FND_NEW_MESSAGES.message_text%TYPE,
11: scrap_main_body FND_NEW_MESSAGES.message_text%TYPE,
12: contract_dtls FND_NEW_MESSAGES.message_text%TYPE,
13: lease_contract FND_NEW_MESSAGES.message_text%TYPE,
14: service_contract FND_NEW_MESSAGES.message_text%TYPE,
7: error_main_body FND_NEW_MESSAGES.message_text%TYPE,
8: termination_main_body FND_NEW_MESSAGES.message_text%TYPE,
9: return_main_body FND_NEW_MESSAGES.message_text%TYPE,
10: dispose_main_body FND_NEW_MESSAGES.message_text%TYPE,
11: scrap_main_body FND_NEW_MESSAGES.message_text%TYPE,
12: contract_dtls FND_NEW_MESSAGES.message_text%TYPE,
13: lease_contract FND_NEW_MESSAGES.message_text%TYPE,
14: service_contract FND_NEW_MESSAGES.message_text%TYPE,
15: termination_date FND_NEW_MESSAGES.message_text%TYPE,
8: termination_main_body FND_NEW_MESSAGES.message_text%TYPE,
9: return_main_body FND_NEW_MESSAGES.message_text%TYPE,
10: dispose_main_body FND_NEW_MESSAGES.message_text%TYPE,
11: scrap_main_body FND_NEW_MESSAGES.message_text%TYPE,
12: contract_dtls FND_NEW_MESSAGES.message_text%TYPE,
13: lease_contract FND_NEW_MESSAGES.message_text%TYPE,
14: service_contract FND_NEW_MESSAGES.message_text%TYPE,
15: termination_date FND_NEW_MESSAGES.message_text%TYPE,
16: asset_ret_date FND_NEW_MESSAGES.message_text%TYPE,
9: return_main_body FND_NEW_MESSAGES.message_text%TYPE,
10: dispose_main_body FND_NEW_MESSAGES.message_text%TYPE,
11: scrap_main_body FND_NEW_MESSAGES.message_text%TYPE,
12: contract_dtls FND_NEW_MESSAGES.message_text%TYPE,
13: lease_contract FND_NEW_MESSAGES.message_text%TYPE,
14: service_contract FND_NEW_MESSAGES.message_text%TYPE,
15: termination_date FND_NEW_MESSAGES.message_text%TYPE,
16: asset_ret_date FND_NEW_MESSAGES.message_text%TYPE,
17: asset_disp_date FND_NEW_MESSAGES.message_text%TYPE,
10: dispose_main_body FND_NEW_MESSAGES.message_text%TYPE,
11: scrap_main_body FND_NEW_MESSAGES.message_text%TYPE,
12: contract_dtls FND_NEW_MESSAGES.message_text%TYPE,
13: lease_contract FND_NEW_MESSAGES.message_text%TYPE,
14: service_contract FND_NEW_MESSAGES.message_text%TYPE,
15: termination_date FND_NEW_MESSAGES.message_text%TYPE,
16: asset_ret_date FND_NEW_MESSAGES.message_text%TYPE,
17: asset_disp_date FND_NEW_MESSAGES.message_text%TYPE,
18: schedule_assets FND_NEW_MESSAGES.message_text%TYPE,
11: scrap_main_body FND_NEW_MESSAGES.message_text%TYPE,
12: contract_dtls FND_NEW_MESSAGES.message_text%TYPE,
13: lease_contract FND_NEW_MESSAGES.message_text%TYPE,
14: service_contract FND_NEW_MESSAGES.message_text%TYPE,
15: termination_date FND_NEW_MESSAGES.message_text%TYPE,
16: asset_ret_date FND_NEW_MESSAGES.message_text%TYPE,
17: asset_disp_date FND_NEW_MESSAGES.message_text%TYPE,
18: schedule_assets FND_NEW_MESSAGES.message_text%TYPE,
19: asset_num FND_NEW_MESSAGES.message_text%TYPE,
12: contract_dtls FND_NEW_MESSAGES.message_text%TYPE,
13: lease_contract FND_NEW_MESSAGES.message_text%TYPE,
14: service_contract FND_NEW_MESSAGES.message_text%TYPE,
15: termination_date FND_NEW_MESSAGES.message_text%TYPE,
16: asset_ret_date FND_NEW_MESSAGES.message_text%TYPE,
17: asset_disp_date FND_NEW_MESSAGES.message_text%TYPE,
18: schedule_assets FND_NEW_MESSAGES.message_text%TYPE,
19: asset_num FND_NEW_MESSAGES.message_text%TYPE,
20: item FND_NEW_MESSAGES.message_text%TYPE,
13: lease_contract FND_NEW_MESSAGES.message_text%TYPE,
14: service_contract FND_NEW_MESSAGES.message_text%TYPE,
15: termination_date FND_NEW_MESSAGES.message_text%TYPE,
16: asset_ret_date FND_NEW_MESSAGES.message_text%TYPE,
17: asset_disp_date FND_NEW_MESSAGES.message_text%TYPE,
18: schedule_assets FND_NEW_MESSAGES.message_text%TYPE,
19: asset_num FND_NEW_MESSAGES.message_text%TYPE,
20: item FND_NEW_MESSAGES.message_text%TYPE,
21: item_description FND_NEW_MESSAGES.message_text%TYPE,
14: service_contract FND_NEW_MESSAGES.message_text%TYPE,
15: termination_date FND_NEW_MESSAGES.message_text%TYPE,
16: asset_ret_date FND_NEW_MESSAGES.message_text%TYPE,
17: asset_disp_date FND_NEW_MESSAGES.message_text%TYPE,
18: schedule_assets FND_NEW_MESSAGES.message_text%TYPE,
19: asset_num FND_NEW_MESSAGES.message_text%TYPE,
20: item FND_NEW_MESSAGES.message_text%TYPE,
21: item_description FND_NEW_MESSAGES.message_text%TYPE,
22: reference_num FND_NEW_MESSAGES.message_text%TYPE,
15: termination_date FND_NEW_MESSAGES.message_text%TYPE,
16: asset_ret_date FND_NEW_MESSAGES.message_text%TYPE,
17: asset_disp_date FND_NEW_MESSAGES.message_text%TYPE,
18: schedule_assets FND_NEW_MESSAGES.message_text%TYPE,
19: asset_num FND_NEW_MESSAGES.message_text%TYPE,
20: item FND_NEW_MESSAGES.message_text%TYPE,
21: item_description FND_NEW_MESSAGES.message_text%TYPE,
22: reference_num FND_NEW_MESSAGES.message_text%TYPE,
23: serial_num FND_NEW_MESSAGES.message_text%TYPE,
16: asset_ret_date FND_NEW_MESSAGES.message_text%TYPE,
17: asset_disp_date FND_NEW_MESSAGES.message_text%TYPE,
18: schedule_assets FND_NEW_MESSAGES.message_text%TYPE,
19: asset_num FND_NEW_MESSAGES.message_text%TYPE,
20: item FND_NEW_MESSAGES.message_text%TYPE,
21: item_description FND_NEW_MESSAGES.message_text%TYPE,
22: reference_num FND_NEW_MESSAGES.message_text%TYPE,
23: serial_num FND_NEW_MESSAGES.message_text%TYPE,
24: quantity FND_NEW_MESSAGES.message_text%TYPE,
17: asset_disp_date FND_NEW_MESSAGES.message_text%TYPE,
18: schedule_assets FND_NEW_MESSAGES.message_text%TYPE,
19: asset_num FND_NEW_MESSAGES.message_text%TYPE,
20: item FND_NEW_MESSAGES.message_text%TYPE,
21: item_description FND_NEW_MESSAGES.message_text%TYPE,
22: reference_num FND_NEW_MESSAGES.message_text%TYPE,
23: serial_num FND_NEW_MESSAGES.message_text%TYPE,
24: quantity FND_NEW_MESSAGES.message_text%TYPE,
25: body_end FND_NEW_MESSAGES.message_text%TYPE);
18: schedule_assets FND_NEW_MESSAGES.message_text%TYPE,
19: asset_num FND_NEW_MESSAGES.message_text%TYPE,
20: item FND_NEW_MESSAGES.message_text%TYPE,
21: item_description FND_NEW_MESSAGES.message_text%TYPE,
22: reference_num FND_NEW_MESSAGES.message_text%TYPE,
23: serial_num FND_NEW_MESSAGES.message_text%TYPE,
24: quantity FND_NEW_MESSAGES.message_text%TYPE,
25: body_end FND_NEW_MESSAGES.message_text%TYPE);
26:
19: asset_num FND_NEW_MESSAGES.message_text%TYPE,
20: item FND_NEW_MESSAGES.message_text%TYPE,
21: item_description FND_NEW_MESSAGES.message_text%TYPE,
22: reference_num FND_NEW_MESSAGES.message_text%TYPE,
23: serial_num FND_NEW_MESSAGES.message_text%TYPE,
24: quantity FND_NEW_MESSAGES.message_text%TYPE,
25: body_end FND_NEW_MESSAGES.message_text%TYPE);
26:
27:
20: item FND_NEW_MESSAGES.message_text%TYPE,
21: item_description FND_NEW_MESSAGES.message_text%TYPE,
22: reference_num FND_NEW_MESSAGES.message_text%TYPE,
23: serial_num FND_NEW_MESSAGES.message_text%TYPE,
24: quantity FND_NEW_MESSAGES.message_text%TYPE,
25: body_end FND_NEW_MESSAGES.message_text%TYPE);
26:
27:
28: -- Start of comments
21: item_description FND_NEW_MESSAGES.message_text%TYPE,
22: reference_num FND_NEW_MESSAGES.message_text%TYPE,
23: serial_num FND_NEW_MESSAGES.message_text%TYPE,
24: quantity FND_NEW_MESSAGES.message_text%TYPE,
25: body_end FND_NEW_MESSAGES.message_text%TYPE);
26:
27:
28: -- Start of comments
29: --
1133: l_dispose_date DATE;
1134: l_dispose_asset_id NUMBER;
1135:
1136: l_scrapped_yn VARCHAR2(1) := 'N';
1137: l_msg_body FND_NEW_MESSAGES.message_text%TYPE;
1138:
1139: l_dispose_date_text VARCHAR2(60); -- added for bug 7538658
1140:
1141: l_user_id NUMBER; -- added for bug 7538658