APPS.IGI_IAC_ADDITIONS_PKG dependencies on IGI_IAC_ADJUSTMENTS

Line 910: UPDATE igi_iac_adjustments

906: SET event_id = p_event_id
907: WHERE book_type_code = p_book_type_code
908: AND asset_id = p_asset_id;
909:
910: UPDATE igi_iac_adjustments
911: SET event_id = p_event_id
912: WHERE book_type_code = p_book_type_code
913: AND asset_id = p_asset_id;
914: END IF;

Line 958: CURSOR c_get_adjustments(p_asset_id igi_iac_adjustments.asset_id%TYPE,

954: AND a.book_type_code = p_book_type_code
955: AND a.asset_id = p_asset_id
956: AND r.calling_program = 'ADDITION';
957:
958: CURSOR c_get_adjustments(p_asset_id igi_iac_adjustments.asset_id%TYPE,
959: p_adjustment_id igi_iac_adjustments.adjustment_id%TYPE) IS
960: SELECT 'X'
961: FROM igi_iac_adjustments
962: WHERE adjustment_id = p_adjustment_id

Line 959: p_adjustment_id igi_iac_adjustments.adjustment_id%TYPE) IS

955: AND a.asset_id = p_asset_id
956: AND r.calling_program = 'ADDITION';
957:
958: CURSOR c_get_adjustments(p_asset_id igi_iac_adjustments.asset_id%TYPE,
959: p_adjustment_id igi_iac_adjustments.adjustment_id%TYPE) IS
960: SELECT 'X'
961: FROM igi_iac_adjustments
962: WHERE adjustment_id = p_adjustment_id
963: AND book_type_code = p_book_type_code

Line 961: FROM igi_iac_adjustments

957:
958: CURSOR c_get_adjustments(p_asset_id igi_iac_adjustments.asset_id%TYPE,
959: p_adjustment_id igi_iac_adjustments.adjustment_id%TYPE) IS
960: SELECT 'X'
961: FROM igi_iac_adjustments
962: WHERE adjustment_id = p_adjustment_id
963: AND book_type_code = p_book_type_code
964: AND asset_id = p_asset_id
965: AND rownum = 1;

Line 1010: /* Delete records from igi_iac_adjustments */

1006: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1007: p_full_path => l_path_name,
1008: p_string => ' Transaction :'||l_asset_info.transaction_sub_type);
1009:
1010: /* Delete records from igi_iac_adjustments */
1011: l_dummy := NULL;
1012: OPEN c_get_adjustments(l_asset_info.asset_id,l_asset_info.adjustment_id);
1013: FETCH c_get_adjustments INTO l_dummy;
1014:

Line 1018: p_string => ' Deleting records from igi_iac_adjustments');

1014:
1015: IF c_get_adjustments%FOUND THEN
1016: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1017: p_full_path => l_path_name,
1018: p_string => ' Deleting records from igi_iac_adjustments');
1019: igi_iac_adjustments_pkg.delete_row(
1020: x_adjustment_id => l_asset_info.adjustment_id);
1021: ELSIF c_get_adjustments%NOTFOUND THEN
1022: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 1019: igi_iac_adjustments_pkg.delete_row(

1015: IF c_get_adjustments%FOUND THEN
1016: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1017: p_full_path => l_path_name,
1018: p_string => ' Deleting records from igi_iac_adjustments');
1019: igi_iac_adjustments_pkg.delete_row(
1020: x_adjustment_id => l_asset_info.adjustment_id);
1021: ELSIF c_get_adjustments%NOTFOUND THEN
1022: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1023: p_full_path => l_path_name,

Line 1024: p_string => ' No records found in igi_iac_adjustments for delete');

1020: x_adjustment_id => l_asset_info.adjustment_id);
1021: ELSIF c_get_adjustments%NOTFOUND THEN
1022: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1023: p_full_path => l_path_name,
1024: p_string => ' No records found in igi_iac_adjustments for delete');
1025: END IF;
1026:
1027: CLOSE c_get_adjustments;
1028: