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.FA_INS_ADJUST_PKG dependencies on FA_ADJUST_TYPE_PKG

Line 320: h_max_cache_rows number := FA_ADJUST_TYPE_PKG.MAX_ADJ_CACHE_ROWS;

316: X_last_update_login number default -1,
317: p_log_level_rec in fa_api_types.log_level_rec_type
318: ) return boolean is
319:
320: h_max_cache_rows number := FA_ADJUST_TYPE_PKG.MAX_ADJ_CACHE_ROWS;
321: h_last_updated_by number;
322: h_last_update_login number;
323: h_mesg_name varchar2(30);
324: h_num_rows number;

Line 779: (adj_ptr.selection_mode <> FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_PARTIAL

775: FROM FA_DISTRIBUTION_HISTORY
776: WHERE ASSET_ID = h_asset_id
777: AND BOOK_TYPE_CODE = h_dist_book
778: AND (
779: (adj_ptr.selection_mode <> FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_PARTIAL
780: AND date_ineffective is null
781: )
782: OR
783: (adj_ptr.selection_mode = FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_PARTIAL

Line 783: (adj_ptr.selection_mode = FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_PARTIAL

779: (adj_ptr.selection_mode <> FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_PARTIAL
780: AND date_ineffective is null
781: )
782: OR
783: (adj_ptr.selection_mode = FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_PARTIAL
784: AND transaction_header_id_in=adj_ptr.selection_thid
785: )
786: )
787: ORDER BY DISTRIBUTION_ID;

Line 936: if (adj_ptr.selection_mode <> FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_PARTIAL) then

932: h_dist_book := FA_CACHE_PKG.fazcbc_record.distribution_source_book;
933:
934: h_mesg_name:='FA_INS_ADJ_CNT_ACTIVE';
935:
936: if (adj_ptr.selection_mode <> FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_PARTIAL) then
937:
938: SELECT COUNT(*)
939: INTO h_distribution_lines
940: FROM FA_DISTRIBUTION_HISTORY

Line 1125: and adj_ptr.selection_mode <> FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_REVAL) then

1121:
1122: -- YYOON: Propagated from PRO*C version(faxiaj2.lpc)
1123:
1124: if (adj_ptr.account_type = 'REVAL_RESERVE_ACCT'
1125: and adj_ptr.selection_mode <> FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_REVAL) then
1126:
1127: --DIST ALLOC
1128: if((adj_ptr.adjustment_type like '%RESERVE%') OR
1129: (adj_ptr.adjustment_type like '%EXPENSE%'))

Line 1344: (adj_ptr.selection_mode <> FA_ADJUST_TYPE_PKG.FA_AJ_CLEAR_PARTIAL

1340: FROM FA_DISTRIBUTION_HISTORY
1341: WHERE asset_id = h_asset_id
1342: AND book_type_code=h_dist_book
1343: AND (
1344: (adj_ptr.selection_mode <> FA_ADJUST_TYPE_PKG.FA_AJ_CLEAR_PARTIAL
1345: AND (date_ineffective is null
1346: OR transaction_header_id_out=adj_ptr.selection_thid
1347: )
1348: )

Line 1350: (adj_ptr.selection_mode = FA_ADJUST_TYPE_PKG.FA_AJ_CLEAR_PARTIAL

1346: OR transaction_header_id_out=adj_ptr.selection_thid
1347: )
1348: )
1349: OR
1350: (adj_ptr.selection_mode = FA_ADJUST_TYPE_PKG.FA_AJ_CLEAR_PARTIAL
1351: AND transaction_header_id_out=adj_ptr.selection_thid
1352: )
1353: )
1354: ORDER BY distribution_id;

Line 1976: FUNCTION faxinaj(adj_ptr_passed in out nocopy FA_ADJUST_TYPE_PKG.fa_adj_row_struct,

1972: -- no dependancies unless code is ever implemented that uses the cache
1973: -- for multiple transactions / assets without flushing (like fadcje)
1974: -- bridgway
1975:
1976: FUNCTION faxinaj(adj_ptr_passed in out nocopy FA_ADJUST_TYPE_PKG.fa_adj_row_struct,
1977: X_last_update_date date default sysdate,
1978: X_last_updated_by number default -1,
1979: X_last_update_login number default -1,
1980: p_log_level_rec in fa_api_types.log_level_rec_type

Line 2037: if (adj_ptr.selection_mode in (FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE , FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_PARTIAL)) then

2033: p_log_level_rec => p_log_level_rec);
2034: return FALSE;
2035: end if;
2036:
2037: if (adj_ptr.selection_mode in (FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE , FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_PARTIAL)) then
2038: if (not fadoact
2039: (X_last_update_date => X_last_update_date,
2040: X_last_updated_by => X_last_updated_by,
2041: X_last_update_login => X_last_update_login,

Line 2051: elsif (adj_ptr.selection_mode=FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_REVAL) then -- YYOON

2047: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',
2048: p_log_level_rec => p_log_level_rec);
2049: return FALSE;
2050: end if;
2051: elsif (adj_ptr.selection_mode=FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_REVAL) then -- YYOON
2052: if (not fadoact
2053: (X_last_update_date => X_last_update_date,
2054: X_last_updated_by => X_last_updated_by,
2055: X_last_update_login => X_last_update_login,

Line 2065: elsif (adj_ptr.selection_mode=FA_ADJUST_TYPE_PKG.FA_AJ_SINGLE) then

2061: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',
2062: p_log_level_rec => p_log_level_rec);
2063: return FALSE;
2064: end if;
2065: elsif (adj_ptr.selection_mode=FA_ADJUST_TYPE_PKG.FA_AJ_SINGLE) then
2066: if (not fadosgl
2067: (X_last_update_date => X_last_update_date,
2068: X_last_updated_by => X_last_updated_by,
2069: X_last_update_login => X_last_update_login,

Line 2079: elsif (adj_ptr.selection_mode=FA_ADJUST_TYPE_PKG.FA_AJ_TRANSFER_SINGLE) then

2075: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',
2076: p_log_level_rec => p_log_level_rec);
2077: return FALSE;
2078: end if;
2079: elsif (adj_ptr.selection_mode=FA_ADJUST_TYPE_PKG.FA_AJ_TRANSFER_SINGLE) then
2080: if (not fadosglf
2081: (X_last_update_date => X_last_update_date,
2082: X_last_updated_by => X_last_updated_by,
2083: X_last_update_login => X_last_update_login,

Line 2093: elsif (adj_ptr.selection_mode in (FA_ADJUST_TYPE_PKG.FA_AJ_CLEAR, FA_ADJUST_TYPE_PKG.FA_AJ_CLEAR_PARTIAL)) then

2089: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',
2090: p_log_level_rec => p_log_level_rec);
2091: return FALSE;
2092: end if;
2093: elsif (adj_ptr.selection_mode in (FA_ADJUST_TYPE_PKG.FA_AJ_CLEAR, FA_ADJUST_TYPE_PKG.FA_AJ_CLEAR_PARTIAL)) then
2094: if (not fadoclr
2095: (X_last_update_date => X_last_update_date,
2096: X_last_updated_by => X_last_updated_by,
2097: X_last_update_login => X_last_update_login,

Line 2107: elsif (adj_ptr.selection_mode=FA_ADJUST_TYPE_PKG.FA_AJ_RETIRE) then

2103: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',
2104: p_log_level_rec => p_log_level_rec);
2105: return FALSE;
2106: end if;
2107: elsif (adj_ptr.selection_mode=FA_ADJUST_TYPE_PKG.FA_AJ_RETIRE) then
2108: if (not fadoret
2109: (X_last_update_date => X_last_update_date,
2110: X_last_updated_by => X_last_updated_by,
2111: X_last_update_login => X_last_update_login,

Line 2203: adj_ptr_local FA_ADJUST_TYPE_PKG.fa_adj_row_struct;

2199: X_init_message_flag varchar2 default 'NO',
2200: p_log_level_rec in fa_api_types.log_level_rec_type
2201: ) return boolean is
2202:
2203: adj_ptr_local FA_ADJUST_TYPE_PKG.fa_adj_row_struct;
2204:
2205: BEGIN <>
2206:
2207: if (X_init_message_flag = 'YES') then

Line 2241: adj_ptr_local.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

2237: end if;
2238: adj_ptr_local.current_units := X_current_units;
2239:
2240: if (X_selection_mode='ACTIVE') then
2241: adj_ptr_local.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2242: elsif (X_selection_mode='SINGLE') then
2243: adj_ptr_local.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_SINGLE;
2244: else
2245: FA_SRVR_MSG.ADD_MESSAGE

Line 2243: adj_ptr_local.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_SINGLE;

2239:
2240: if (X_selection_mode='ACTIVE') then
2241: adj_ptr_local.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
2242: elsif (X_selection_mode='SINGLE') then
2243: adj_ptr_local.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_SINGLE;
2244: else
2245: FA_SRVR_MSG.ADD_MESSAGE
2246: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinadj',
2247: NAME => 'FA_INS_ADJ_BAD_SEL_MODE',