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 5: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);

1: PACKAGE BODY FA_C_INSURE AS
2: /* $Header: faxinsub.pls 120.8.12010000.1 2008/07/28 13:26:04 appldev ship $ */
3:
4: PROCEDURE plsqlmsg (p_msg IN VARCHAR2,
5: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
6:
7: PROCEDURE plsqlmsg_put (p_msg IN VARCHAR2,
8: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
9:

Line 8: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);

4: PROCEDURE plsqlmsg (p_msg IN VARCHAR2,
5: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
6:
7: PROCEDURE plsqlmsg_put (p_msg IN VARCHAR2,
8: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
9:
10: PROCEDURE Get_Period_Counters_Proc
11: (p_asset_book IN VARCHAR2,
12: p_year IN VARCHAR2,

Line 22: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null

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 default null
23: );
24:
25: PROCEDURE insert_values_record
26: (p_pol_asset_policy_id IN NUMBER,

Line 36: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null

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

Line 48: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null

44: p_indexation_id IN NUMBER,
45: p_new_price_index_value IN NUMBER,
46: p_pol_retirement_value IN NUMBER,
47: p_last_period_closed_date IN DATE,
48: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
49: );
50:
51: PROCEDURE Get_New_Price_index_Proc
52: (p_pol_price_index_id IN NUMBER,

Line 56: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null

52: (p_pol_price_index_id IN NUMBER,
53: px_price_index_value IN OUT NOCOPY NUMBER,
54: px_price_index_id IN OUT NOCOPY NUMBER,
55: p_year_date_end IN DATE,
56: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
57: );
58:
59: PROCEDURE process_adjustments
60: (transaction_id NUMBER,

Line 81: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null

77: px_cmv_null_flag IN OUT NOCOPY VARCHAR2,
78: pol_indexation_date DATE,
79: px_pol_retirement_value IN OUT NOCOPY NUMBER,
80: pol_period_fully_reserved NUMBER,
81: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
82: );
83:
84: PROCEDURE process_retirements
85: (pol_asset_id NUMBER,

Line 112: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null

108: px_retirement_date IN OUT NOCOPY DATE,
109: px_reinstatement_without_ret
110: IN OUT NOCOPY VARCHAR2,
111: pol_period_fully_reserved NUMBER,
112: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
113: );
114:
115: PROCEDURE Get_base_index_value
116: (p_asset_book IN VARCHAR2,

Line 122: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null

118: pol_base_index_date DATE,
119: px_base_price_index_value IN OUT NOCOPY NUMBER,
120: pol_price_index_id NUMBER,
121: px_base_price_index_id IN OUT NOCOPY NUMBER,
122: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
123: );
124:
125: PROCEDURE Calculate_Insurance_Value_Proc
126: (pol_asset_id NUMBER,

Line 147: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null

143: pol_indexation_date DATE,
144: px_pol_retirement_value IN OUT NOCOPY NUMBER,
145: retirement_flag VARCHAR2,
146: pol_period_fully_reserved NUMBER,
147: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
148: );
149:
150: PROCEDURE insurance ( Errbuf OUT NOCOPY VARCHAR2,
151: Retcode OUT NOCOPY NUMBER,

Line 157: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null

153: P_Year VARCHAR2,
154: P_Ins_company_id NUMBER,
155: P_Asset_start VARCHAR2,
156: P_Asset_end VARCHAR2,
157: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
158: ) IS
159:
160: year_date_start DATE;
161: year_date_end DATE;

Line 695: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null

691: px_market_value IN OUT NOCOPY NUMBER,
692: px_market_ytd_deprn IN OUT NOCOPY NUMBER,
693: px_cmv_null_flag IN OUT NOCOPY VARCHAR2,
694: pol_period_fully_reserved NUMBER,
695: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
696: ) IS
697:
698: CURSOR Get_market_value ( pol_asset_id NUMBER,
699: last_period_closed NUMBER

Line 737: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null

733: pol_asset_id NUMBER,
734: pol_indexation_date DATE,
735: px_asset_total_life IN OUT NOCOPY NUMBER,
736: px_asset_remaining_life IN OUT NOCOPY NUMBER,
737: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
738: ) IS
739:
740: CURSOR get_asset_life_details (p_asset_book VARCHAR2,
741: pol_asset_id NUMBER)

Line 821: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null

817: pol_price_index_value NUMBER,
818: px_pol_retirement_value IN OUT NOCOPY NUMBER,
819: retirement_flag VARCHAR2,
820: pol_period_fully_reserved NUMBER,
821: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
822: ) IS
823:
824: BEGIN
825:

Line 862: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null

858: new_price_index_value NUMBER,
859: px_pol_retirement_value IN OUT NOCOPY NUMBER,
860: retirement_flag VARCHAR2,
861: pol_period_fully_reserved NUMBER,
862: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
863: ) IS
864:
865: BEGIN
866:

Line 912: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null

908: new_price_index_value NUMBER,
909: px_pol_retirement_value IN OUT NOCOPY NUMBER,
910: retirement_flag VARCHAR2,
911: pol_period_fully_reserved NUMBER,
912: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
913: ) IS
914:
915: asset_total_life NUMBER;
916: asset_remaining_life NUMBER;

Line 982: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null

978: pol_price_index_value NUMBER,
979: px_pol_retirement_value IN OUT NOCOPY NUMBER,
980: retirement_flag VARCHAR2,
981: pol_period_fully_reserved NUMBER,
982: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
983: ) IS
984:
985: BEGIN
986:

Line 1027: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null

1023: px_year_counter_end IN OUT NOCOPY NUMBER,
1024: px_year_effective_end IN OUT NOCOPY DATE,
1025: px_year_effective_start IN OUT NOCOPY DATE,
1026: px_year_prev_end_date IN OUT NOCOPY DATE,
1027: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1028: ) IS
1029:
1030:
1031: CURSOR Get_Period_Counters ( P_Asset_book VARCHAR2,

Line 1120: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null

1116: (p_pol_price_index_id IN NUMBER,
1117: px_price_index_value IN OUT NOCOPY NUMBER,
1118: px_price_index_id IN OUT NOCOPY NUMBER,
1119: p_year_date_end IN DATE,
1120: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1121: ) IS
1122:
1123: CURSOR Get_new_price_index ( pol_price_index_id NUMBER,
1124: year_date_end DATE

Line 1190: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null

1186: pol_indexation_date DATE,
1187: px_pol_retirement_value IN OUT NOCOPY NUMBER,
1188: retirement_flag VARCHAR2,
1189: pol_period_fully_reserved NUMBER,
1190: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1191: ) IS
1192:
1193: market_value NUMBER;
1194: market_ytd_deprn NUMBER;

Line 1328: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null

1324: px_cmv_null_flag IN OUT NOCOPY VARCHAR2,
1325: pol_indexation_date DATE,
1326: px_pol_retirement_value IN OUT NOCOPY NUMBER,
1327: pol_period_fully_reserved NUMBER,
1328: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1329: ) IS
1330:
1331: CURSOR Additions (transaction_id NUMBER,
1332: p_book_type_code VARCHAR2,

Line 1396: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

1392: pol_swiss_building VARCHAR2,
1393: pol_retirement_value NUMBER,
1394: new_price_index_value NUMBER,
1395: cal_insurance_value IN OUT NOCOPY NUMBER,
1396: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1397:
1398:
1399: asset_total_life NUMBER;
1400: asset_remaining_life NUMBER;

Line 1472: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null

1468: px_retirement_date IN OUT NOCOPY DATE,
1469: px_reinstatement_without_ret
1470: IN OUT NOCOPY VARCHAR2,
1471: pol_period_fully_reserved NUMBER,
1472: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1473: ) IS
1474:
1475: Cursor retirements ( transaction_id NUMBER) IS
1476:

Line 1606: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null

1602: p_indexation_id IN NUMBER,
1603: p_new_price_index_value IN NUMBER,
1604: p_pol_retirement_value IN NUMBER,
1605: p_last_period_closed_date IN DATE,
1606: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1607: ) IS
1608:
1609: BEGIN
1610:

Line 1634: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null

1630: p_last_period_closed_date IN DATE,
1631: p_pol_price_index_id IN NUMBER,
1632: p_pol_price_index_value IN NUMBER,
1633: p_cal_insurance_value IN NUMBER,
1634: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1635: ) IS
1636:
1637: BEGIN
1638:

Line 1693: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null

1689: pol_base_index_date DATE,
1690: px_base_price_index_value IN OUT NOCOPY NUMBER,
1691: pol_price_index_id NUMBER,
1692: px_base_price_index_id IN OUT NOCOPY NUMBER,
1693: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1694: ) IS
1695:
1696: BEGIN
1697: Get_New_Price_Index_Proc(pol_price_index_id,

Line 1706: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

1702: END Get_base_index_value;
1703:
1704:
1705: PROCEDURE plsqlmsg (p_msg IN VARCHAR2,
1706: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1707: /* This is an R11 AOL routine to allow messages to be written to the */
1708: /* log (set the first parameter = 1) or an output file (set the first */
1709: /* parameter = 2). */
1710:

Line 1716: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

1712: fnd_file.put_line(1, p_msg);
1713: END plsqlmsg;
1714:
1715: PROCEDURE plsqlmsg_put (p_msg IN VARCHAR2,
1716: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1717: /* This is an R11 AOL routine to allow messages to be written to the */
1718: /* log (set the first parameter = 1) or an output file (set the first */
1719: /* parameter = 2). */
1720: