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 223: h_max_cache_rows number := FA_ADJUST_TYPE_PKG.MAX_ADJ_CACHE_ROWS;

219: X_last_update_login number default -1,
220: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
221: return boolean is
222:
223: h_max_cache_rows number := FA_ADJUST_TYPE_PKG.MAX_ADJ_CACHE_ROWS;
224: h_last_updated_by number;
225: h_last_update_login number;
226: h_mesg_name varchar2(30);
227: h_num_rows number;

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

643: FROM FA_DISTRIBUTION_HISTORY
644: WHERE ASSET_ID = h_asset_id
645: AND BOOK_TYPE_CODE = h_dist_book
646: AND (
647: (adj_ptr.selection_mode <> FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_PARTIAL
648: AND date_ineffective is null
649: )
650: OR
651: (adj_ptr.selection_mode = FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_PARTIAL

Line 651: (adj_ptr.selection_mode = FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_PARTIAL

647: (adj_ptr.selection_mode <> FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_PARTIAL
648: AND date_ineffective is null
649: )
650: OR
651: (adj_ptr.selection_mode = FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_PARTIAL
652: AND transaction_header_id_in=adj_ptr.selection_thid
653: )
654: )
655: ORDER BY DISTRIBUTION_ID;

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

745: h_dist_book := FA_CACHE_PKG.fazcbc_record.distribution_source_book;
746:
747: h_mesg_name:='FA_INS_ADJ_CNT_ACTIVE';
748:
749: if (adj_ptr.selection_mode <> FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_PARTIAL) then
750:
751: SELECT COUNT(*)
752: INTO h_distribution_lines
753: FROM FA_DISTRIBUTION_HISTORY

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

842:
843: -- YYOON: Propagated from PRO*C version(faxiaj2.lpc)
844:
845: if (adj_ptr.account_type = 'REVAL_RESERVE_ACCT'
846: and adj_ptr.selection_mode <> FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_REVAL) then
847:
848: h_amount_to_insert := h_total_amount - h_amount_so_far;
849:
850: else

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

991: FROM FA_DISTRIBUTION_HISTORY
992: WHERE asset_id = h_asset_id
993: AND book_type_code=h_dist_book
994: AND (
995: (adj_ptr.selection_mode <> FA_ADJUST_TYPE_PKG.FA_AJ_CLEAR_PARTIAL
996: AND (date_ineffective is null
997: OR transaction_header_id_out=adj_ptr.selection_thid
998: )
999: )

Line 1001: (adj_ptr.selection_mode = FA_ADJUST_TYPE_PKG.FA_AJ_CLEAR_PARTIAL

997: OR transaction_header_id_out=adj_ptr.selection_thid
998: )
999: )
1000: OR
1001: (adj_ptr.selection_mode = FA_ADJUST_TYPE_PKG.FA_AJ_CLEAR_PARTIAL
1002: AND transaction_header_id_out=adj_ptr.selection_thid
1003: )
1004: )
1005: ORDER BY distribution_id;

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

1606: -- no dependancies unless code is ever implemented that uses the cache
1607: -- for multiple transactions / assets without flushing (like fadcje)
1608: -- bridgway
1609:
1610: FUNCTION faxinaj(adj_ptr_passed in out nocopy FA_ADJUST_TYPE_PKG.fa_adj_row_struct,
1611: X_last_update_date date default sysdate,
1612: X_last_updated_by number default -1,
1613: X_last_update_login number default -1,
1614: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

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

1664: ,p_log_level_rec => p_log_level_rec);
1665: return FALSE;
1666: end if;
1667:
1668: if (adj_ptr.selection_mode in (FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE , FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_PARTIAL)) then
1669: if (not fadoact
1670: (X_last_update_date => X_last_update_date,
1671: X_last_updated_by => X_last_updated_by,
1672: X_last_update_login => X_last_update_login

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

1677: FA_SRVR_MSG.ADD_MESSAGE(CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj'
1678: ,p_log_level_rec => p_log_level_rec);
1679: return FALSE;
1680: end if;
1681: elsif (adj_ptr.selection_mode=FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_REVAL) then -- YYOON
1682: if (not fadoact
1683: (X_last_update_date => X_last_update_date,
1684: X_last_updated_by => X_last_updated_by,
1685: X_last_update_login => X_last_update_login

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

1690: FA_SRVR_MSG.ADD_MESSAGE(CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj'
1691: ,p_log_level_rec => p_log_level_rec);
1692: return FALSE;
1693: end if;
1694: elsif (adj_ptr.selection_mode=FA_ADJUST_TYPE_PKG.FA_AJ_SINGLE) then
1695: if (not fadosgl
1696: (X_last_update_date => X_last_update_date,
1697: X_last_updated_by => X_last_updated_by,
1698: X_last_update_login => X_last_update_login

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

1703: FA_SRVR_MSG.ADD_MESSAGE(CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj'
1704: ,p_log_level_rec => p_log_level_rec);
1705: return FALSE;
1706: end if;
1707: elsif (adj_ptr.selection_mode=FA_ADJUST_TYPE_PKG.FA_AJ_TRANSFER_SINGLE) then
1708: if (not fadosglf
1709: (X_last_update_date => X_last_update_date,
1710: X_last_updated_by => X_last_updated_by,
1711: X_last_update_login => X_last_update_login

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

1716: FA_SRVR_MSG.ADD_MESSAGE(CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj'
1717: ,p_log_level_rec => p_log_level_rec);
1718: return FALSE;
1719: end if;
1720: elsif (adj_ptr.selection_mode in (FA_ADJUST_TYPE_PKG.FA_AJ_CLEAR, FA_ADJUST_TYPE_PKG.FA_AJ_CLEAR_PARTIAL)) then
1721: if (not fadoclr
1722: (X_last_update_date => X_last_update_date,
1723: X_last_updated_by => X_last_updated_by,
1724: X_last_update_login => X_last_update_login

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

1729: FA_SRVR_MSG.ADD_MESSAGE(CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj'
1730: ,p_log_level_rec => p_log_level_rec);
1731: return FALSE;
1732: end if;
1733: elsif (adj_ptr.selection_mode=FA_ADJUST_TYPE_PKG.FA_AJ_RETIRE) then
1734: if (not fadoret
1735: (X_last_update_date => X_last_update_date,
1736: X_last_updated_by => X_last_updated_by,
1737: X_last_update_login => X_last_update_login

Line 1826: adj_ptr_local FA_ADJUST_TYPE_PKG.fa_adj_row_struct;

1822: X_init_message_flag varchar2 default 'NO',
1823: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1824: return boolean is
1825:
1826: adj_ptr_local FA_ADJUST_TYPE_PKG.fa_adj_row_struct;
1827:
1828: BEGIN <>
1829:
1830: if (X_init_message_flag = 'YES') then

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

1860: end if;
1861: adj_ptr_local.current_units := X_current_units;
1862:
1863: if (X_selection_mode='ACTIVE') then
1864: adj_ptr_local.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
1865: elsif (X_selection_mode='SINGLE') then
1866: adj_ptr_local.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_SINGLE;
1867: else
1868: FA_SRVR_MSG.ADD_MESSAGE

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

1862:
1863: if (X_selection_mode='ACTIVE') then
1864: adj_ptr_local.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
1865: elsif (X_selection_mode='SINGLE') then
1866: adj_ptr_local.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_SINGLE;
1867: else
1868: FA_SRVR_MSG.ADD_MESSAGE
1869: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinadj',
1870: NAME => 'FA_INS_ADJ_BAD_SEL_MODE'