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_C_INSURE dependencies on FA_API_TYPES

Line 4: g_log_level_rec fa_api_types.log_level_rec_type;

1: PACKAGE BODY FA_C_INSURE AS
2: /* $Header: faxinsub.pls 120.9 2009/03/27 03:26:27 bridgway ship $ */
3:
4: g_log_level_rec fa_api_types.log_level_rec_type;
5:
6: PROCEDURE plsqlmsg (p_msg IN VARCHAR2);
7:
8: PROCEDURE plsqlmsg_put (p_msg IN VARCHAR2);

Line 22: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);

18: px_year_counter_end IN OUT NOCOPY NUMBER,
19: px_year_effective_end IN OUT NOCOPY DATE,
20: px_year_effective_start IN OUT NOCOPY DATE,
21: px_year_prev_end_date IN OUT NOCOPY DATE
22: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
23:
24: PROCEDURE insert_values_record
25: (p_pol_asset_policy_id IN NUMBER,
26: px_indexation_id IN OUT NOCOPY NUMBER,

Line 35: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);

31: p_last_period_closed_date IN DATE,
32: p_pol_price_index_id IN NUMBER,
33: p_pol_price_index_value IN NUMBER,
34: p_cal_insurance_value IN NUMBER
35: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
36:
37: PROCEDURE update_policies_record
38: (p_pol_asset_policy_id IN NUMBER,
39: p_pol_policy_number IN VARCHAR2,

Line 46: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);

42: p_indexation_id IN NUMBER,
43: p_new_price_index_value IN NUMBER,
44: p_pol_retirement_value IN NUMBER,
45: p_last_period_closed_date IN DATE
46: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
47:
48: PROCEDURE Get_New_Price_index_Proc
49: (p_pol_price_index_id IN NUMBER,
50: px_price_index_value IN OUT NOCOPY NUMBER,

Line 53: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);

49: (p_pol_price_index_id IN NUMBER,
50: px_price_index_value IN OUT NOCOPY NUMBER,
51: px_price_index_id IN OUT NOCOPY NUMBER,
52: p_year_date_end IN DATE
53: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
54:
55: PROCEDURE process_adjustments
56: (transaction_id NUMBER,
57: pol_asset_id NUMBER,

Line 77: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);

73: px_cmv_null_flag IN OUT NOCOPY VARCHAR2,
74: pol_indexation_date DATE,
75: px_pol_retirement_value IN OUT NOCOPY NUMBER,
76: pol_period_fully_reserved NUMBER
77: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
78:
79: PROCEDURE process_retirements
80: (pol_asset_id NUMBER,
81: pol_policy_number VARCHAR2,

Line 107: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);

103: px_retirement_date IN OUT NOCOPY DATE,
104: px_reinstatement_without_ret
105: IN OUT NOCOPY VARCHAR2,
106: pol_period_fully_reserved NUMBER
107: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
108:
109: PROCEDURE Get_base_index_value
110: (p_asset_book IN VARCHAR2,
111: pol_asset_id NUMBER,

Line 116: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);

112: pol_base_index_date DATE,
113: px_base_price_index_value IN OUT NOCOPY NUMBER,
114: pol_price_index_id NUMBER,
115: px_base_price_index_id IN OUT NOCOPY NUMBER
116: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
117:
118: PROCEDURE Calculate_Insurance_Value_Proc
119: (pol_asset_id NUMBER,
120: pol_policy_number VARCHAR2,

Line 140: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);

136: pol_indexation_date DATE,
137: px_pol_retirement_value IN OUT NOCOPY NUMBER,
138: retirement_flag VARCHAR2,
139: pol_period_fully_reserved NUMBER
140: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
141:
142: PROCEDURE insurance ( Errbuf OUT NOCOPY VARCHAR2,
143: Retcode OUT NOCOPY NUMBER,
144: P_Asset_book VARCHAR2,

Line 699: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

695: px_market_value IN OUT NOCOPY NUMBER,
696: px_market_ytd_deprn IN OUT NOCOPY NUMBER,
697: px_cmv_null_flag IN OUT NOCOPY VARCHAR2,
698: pol_period_fully_reserved NUMBER
699: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
700:
701: CURSOR Get_market_value ( pol_asset_id NUMBER,
702: last_period_closed NUMBER
703: ) IS

Line 740: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

736: pol_asset_id NUMBER,
737: pol_indexation_date DATE,
738: px_asset_total_life IN OUT NOCOPY NUMBER,
739: px_asset_remaining_life IN OUT NOCOPY NUMBER
740: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
741:
742: CURSOR get_asset_life_details (p_asset_book VARCHAR2,
743: pol_asset_id NUMBER)
744: IS

Line 824: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

820: pol_price_index_value NUMBER,
821: px_pol_retirement_value IN OUT NOCOPY NUMBER,
822: retirement_flag VARCHAR2,
823: pol_period_fully_reserved NUMBER
824: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
825:
826: BEGIN
827:
828: /* Check market value purely to see if asset has been depreciated */

Line 866: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

862: new_price_index_value NUMBER,
863: px_pol_retirement_value IN OUT NOCOPY NUMBER,
864: retirement_flag VARCHAR2,
865: pol_period_fully_reserved NUMBER
866: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
867:
868: BEGIN
869:
870:

Line 918: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

914: new_price_index_value NUMBER,
915: px_pol_retirement_value IN OUT NOCOPY NUMBER,
916: retirement_flag VARCHAR2,
917: pol_period_fully_reserved NUMBER
918: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
919:
920: asset_total_life NUMBER;
921: asset_remaining_life NUMBER;
922:

Line 989: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

985: pol_price_index_value NUMBER,
986: px_pol_retirement_value IN OUT NOCOPY NUMBER,
987: retirement_flag VARCHAR2,
988: pol_period_fully_reserved NUMBER
989: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
990:
991: BEGIN
992:
993: /* Check market value purely to see if asset has been depreciated */

Line 1035: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

1031: px_year_counter_end IN OUT NOCOPY NUMBER,
1032: px_year_effective_end IN OUT NOCOPY DATE,
1033: px_year_effective_start IN OUT NOCOPY DATE,
1034: px_year_prev_end_date IN OUT NOCOPY DATE
1035: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
1036:
1037:
1038: CURSOR Get_Period_Counters ( P_Asset_book VARCHAR2,
1039: P_Year VARCHAR2

Line 1127: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

1123: (p_pol_price_index_id IN NUMBER,
1124: px_price_index_value IN OUT NOCOPY NUMBER,
1125: px_price_index_id IN OUT NOCOPY NUMBER,
1126: p_year_date_end IN DATE
1127: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
1128:
1129: CURSOR Get_new_price_index ( pol_price_index_id NUMBER,
1130: year_date_end DATE
1131: ) IS

Line 1196: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

1192: pol_indexation_date DATE,
1193: px_pol_retirement_value IN OUT NOCOPY NUMBER,
1194: retirement_flag VARCHAR2,
1195: pol_period_fully_reserved NUMBER
1196: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
1197:
1198: market_value NUMBER;
1199: market_ytd_deprn NUMBER;
1200: base_price_index_value NUMBER;

Line 1339: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

1335: px_cmv_null_flag IN OUT NOCOPY VARCHAR2,
1336: pol_indexation_date DATE,
1337: px_pol_retirement_value IN OUT NOCOPY NUMBER,
1338: pol_period_fully_reserved NUMBER
1339: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
1340:
1341: CURSOR Additions (transaction_id NUMBER,
1342: p_book_type_code VARCHAR2,
1343: p_asset_id NUMBER) IS

Line 1406: cal_insurance_value IN OUT NOCOPY NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

1402: pol_calculation_method VARCHAR2,
1403: pol_swiss_building VARCHAR2,
1404: pol_retirement_value NUMBER,
1405: new_price_index_value NUMBER,
1406: cal_insurance_value IN OUT NOCOPY NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
1407:
1408:
1409: asset_total_life NUMBER;
1410: asset_remaining_life NUMBER;

Line 1483: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

1479: px_retirement_date IN OUT NOCOPY DATE,
1480: px_reinstatement_without_ret
1481: IN OUT NOCOPY VARCHAR2,
1482: pol_period_fully_reserved NUMBER
1483: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
1484:
1485: Cursor retirements ( transaction_id NUMBER) IS
1486:
1487: SELECT nvl(ret.cost_retired,0)

Line 1619: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

1615: p_indexation_id IN NUMBER,
1616: p_new_price_index_value IN NUMBER,
1617: p_pol_retirement_value IN NUMBER,
1618: p_last_period_closed_date IN DATE
1619: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
1620:
1621: BEGIN
1622:
1623: UPDATE fa_ins_policies pol

Line 1646: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

1642: p_last_period_closed_date IN DATE,
1643: p_pol_price_index_id IN NUMBER,
1644: p_pol_price_index_value IN NUMBER,
1645: p_cal_insurance_value IN NUMBER
1646: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
1647:
1648: BEGIN
1649:
1650: SELECT FA_INDEXATION_S.nextval

Line 1704: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

1700: pol_base_index_date DATE,
1701: px_base_price_index_value IN OUT NOCOPY NUMBER,
1702: pol_price_index_id NUMBER,
1703: px_base_price_index_id IN OUT NOCOPY NUMBER
1704: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
1705:
1706: BEGIN
1707: Get_New_Price_Index_Proc(pol_price_index_id,
1708: px_base_price_index_value,