APPS.FA_SORP_UPG_PKG dependencies on FA_SORP_REVAL_CHK

Line 805: FUNCTION fa_sorp_reval_chk_fn (p_book_type_code VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

801: p_status_msg := SQLERRM;
802: RETURN FALSE;
803: END fa_category_impl;
804:
805: FUNCTION fa_sorp_reval_chk_fn (p_book_type_code VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
806: RETURN BOOLEAN
807: IS
808: v_period_counter NUMBER;
809: v_period_name VARCHAR2 (30);

Line 870: DELETE FROM fa_sorp_reval_chk;

866: WHERE book_type_code = p_book_type_code
867: AND asset_id = v_asset_id
868: GROUP BY asset_id);
869: BEGIN
870: DELETE FROM fa_sorp_reval_chk;
871:
872: COMMIT;
873:
874: OPEN c_asset_cur;

Line 934: INSERT INTO fa_sorp_reval_chk

930: l_message := 'SUCCESS';
931: l_status_code := 'S';
932: END IF;
933:
934: INSERT INTO fa_sorp_reval_chk
935: (book_type_code, category_id, category_name,
936: asset_id, asset_number, apr_reval_rsv,
937: reval_rsv, status_code, status
938: )

Line 957: END fa_sorp_reval_chk_fn;

953: WHEN OTHERS
954: THEN
955: ROLLBACK;
956: RETURN FALSE;
957: END fa_sorp_reval_chk_fn;
958:
959: FUNCTION fa_sorp_upg_cagf_mc_fn (p_book_type_code VARCHAR2, p_mode VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
960: RETURN BOOLEAN
961: IS