DBA Data[Home] [Help]

APPS.FARX_BL dependencies on FA_RX_SHARED_PKG

Line 47: acct_all_segs fa_rx_shared_pkg.Seg_Array;

43: bal_seg varchar2(25);
44: cost_seg varchar2(25);
45: acct_seg varchar2(25);
46: acct_flex_structure number;
47: acct_all_segs fa_rx_shared_pkg.Seg_Array;
48: aj_acct_all_segs fa_rx_shared_pkg.Seg_Array;
49: seg_no number;
50: n_segs number;
51: n_ajsegs number;

Line 48: aj_acct_all_segs fa_rx_shared_pkg.Seg_Array;

44: cost_seg varchar2(25);
45: acct_seg varchar2(25);
46: acct_flex_structure number;
47: acct_all_segs fa_rx_shared_pkg.Seg_Array;
48: aj_acct_all_segs fa_rx_shared_pkg.Seg_Array;
49: seg_no number;
50: n_segs number;
51: n_ajsegs number;
52: gl_balancing_seg number;

Line 96: h_nq_col_names fa_rx_shared_pkg.Seg_Array;

92: h_nonqual_col_name varchar2(30);
93: h_nonqual_seg_name varchar2(30);
94: h_nonqual_seg_num varchar2(30);
95:
96: h_nq_col_names fa_rx_shared_pkg.Seg_Array;
97: h_nq_seg_names fa_rx_shared_pkg.Seg_Array;
98: h_nq_seg_nums fa_rx_shared_pkg.Seg_Array;
99: h_ctr number;
100:

Line 97: h_nq_seg_names fa_rx_shared_pkg.Seg_Array;

93: h_nonqual_seg_name varchar2(30);
94: h_nonqual_seg_num varchar2(30);
95:
96: h_nq_col_names fa_rx_shared_pkg.Seg_Array;
97: h_nq_seg_names fa_rx_shared_pkg.Seg_Array;
98: h_nq_seg_nums fa_rx_shared_pkg.Seg_Array;
99: h_ctr number;
100:
101: get_segments_success boolean;

Line 98: h_nq_seg_nums fa_rx_shared_pkg.Seg_Array;

94: h_nonqual_seg_num varchar2(30);
95:
96: h_nq_col_names fa_rx_shared_pkg.Seg_Array;
97: h_nq_seg_names fa_rx_shared_pkg.Seg_Array;
98: h_nq_seg_nums fa_rx_shared_pkg.Seg_Array;
99: h_ctr number;
100:
101: get_segments_success boolean;
102:

Line 119: h_key_segs fa_rx_shared_pkg.Seg_Array; /* StatReq */

115:
116: h_asset_key_ccid number;
117: h_category_id number; /* StatReq */
118:
119: h_key_segs fa_rx_shared_pkg.Seg_Array; /* StatReq */
120: h_cat_segs fa_rx_shared_pkg.Seg_Array; /* StatReq */
121:
122: h_asset_id FA_ADDITIONS.asset_id%TYPE; /* StatReq */
123: h_stl_depreciation_rate NUMBER; /* StatReq */

Line 120: h_cat_segs fa_rx_shared_pkg.Seg_Array; /* StatReq */

116: h_asset_key_ccid number;
117: h_category_id number; /* StatReq */
118:
119: h_key_segs fa_rx_shared_pkg.Seg_Array; /* StatReq */
120: h_cat_segs fa_rx_shared_pkg.Seg_Array; /* StatReq */
121:
122: h_asset_id FA_ADDITIONS.asset_id%TYPE; /* StatReq */
123: h_stl_depreciation_rate NUMBER; /* StatReq */
124: h_date_placed_in_service DATE; /* StatReq */

Line 1777: fa_rx_shared_pkg.get_acct_segment_numbers (

1773: -- Will need these later for getting segments for given ccids.
1774:
1775: h_mesg_name := 'FA_RX_SEGNUMS';
1776:
1777: fa_rx_shared_pkg.get_acct_segment_numbers (
1778: BOOK => Book,
1779: BALANCING_SEGNUM => gl_balancing_seg,
1780: ACCOUNT_SEGNUM => gl_account_seg,
1781: CC_SEGNUM => fa_cost_ctr_seg,

Line 1790: fa_rx_shared_pkg.get_acct_segment_index (

1786: return_status := FND_FLEX_APIS.GET_SEGMENT_INFO
1787: (101, 'GL#', Acct_Flex_Structure, Gl_Account_Seg,
1788: Acct_Appl_Col, Acct_Segname, Acct_Prompt, Acct_Valueset_Name);
1789:
1790: fa_rx_shared_pkg.get_acct_segment_index (
1791: BOOK => Book,
1792: BALANCING_SEGNUM => gl_balancing_seg,
1793: ACCOUNT_SEGNUM => gl_account_seg,
1794: CC_SEGNUM => fa_cost_ctr_seg,

Line 1851: fa_rx_shared_pkg.get_acct_segments (

1847:
1848: h_mesg_name := 'FA_RX_CONCAT_SEGS';
1849: h_ccid_error := h_br_ajccid;
1850:
1851: fa_rx_shared_pkg.get_acct_segments (
1852: combination_id => h_br_ajccid,
1853: n_segments => n_segs,
1854: segments => acct_all_segs,
1855: calling_fn => 'FA_BALANCES_REPORT');

Line 1957: fa_rx_shared_pkg.get_acct_segments (

1953:
1954: h_mesg_name := 'FA_RX_CONCAT_SEGS';
1955: h_ccid_error := h_ccid;
1956:
1957: fa_rx_shared_pkg.get_acct_segments (
1958: combination_id => h_ccid,
1959: n_segments => n_segs,
1960: segments => acct_all_segs,
1961: calling_fn => 'FA_BALANCES_REPORT');

Line 1967: fa_rx_shared_pkg.get_flex_val_meaning(NULL, acct_valueset_name, h_account);

1963: /* StatReq - The following 6 function calls have been added to retrieve more
1964: detailed asset information */
1965:
1966: h_account_description :=
1967: fa_rx_shared_pkg.get_flex_val_meaning(NULL, acct_valueset_name, h_account);
1968:
1969: h_vendor_name :=
1970: fa_rx_shared_pkg.get_asset_info('VENDOR_NAME', h_asset_id, period1_pod, period2_pcd, book,
1971: acct_all_segs(gl_balancing_seg));

Line 1970: fa_rx_shared_pkg.get_asset_info('VENDOR_NAME', h_asset_id, period1_pod, period2_pcd, book,

1966: h_account_description :=
1967: fa_rx_shared_pkg.get_flex_val_meaning(NULL, acct_valueset_name, h_account);
1968:
1969: h_vendor_name :=
1970: fa_rx_shared_pkg.get_asset_info('VENDOR_NAME', h_asset_id, period1_pod, period2_pcd, book,
1971: acct_all_segs(gl_balancing_seg));
1972: h_invoice_number :=
1973: fa_rx_shared_pkg.get_asset_info('INVOICE_NUMBER', h_asset_id, period1_pod, period2_pcd, book,
1974: acct_all_segs(gl_balancing_seg));

Line 1973: fa_rx_shared_pkg.get_asset_info('INVOICE_NUMBER', h_asset_id, period1_pod, period2_pcd, book,

1969: h_vendor_name :=
1970: fa_rx_shared_pkg.get_asset_info('VENDOR_NAME', h_asset_id, period1_pod, period2_pcd, book,
1971: acct_all_segs(gl_balancing_seg));
1972: h_invoice_number :=
1973: fa_rx_shared_pkg.get_asset_info('INVOICE_NUMBER', h_asset_id, period1_pod, period2_pcd, book,
1974: acct_all_segs(gl_balancing_seg));
1975: h_invoice_descr :=
1976: fa_rx_shared_pkg.get_asset_info('INVOICE_DESCR', h_asset_id, period1_pod, period2_pcd, book,
1977: acct_all_segs(gl_balancing_seg));

Line 1976: fa_rx_shared_pkg.get_asset_info('INVOICE_DESCR', h_asset_id, period1_pod, period2_pcd, book,

1972: h_invoice_number :=
1973: fa_rx_shared_pkg.get_asset_info('INVOICE_NUMBER', h_asset_id, period1_pod, period2_pcd, book,
1974: acct_all_segs(gl_balancing_seg));
1975: h_invoice_descr :=
1976: fa_rx_shared_pkg.get_asset_info('INVOICE_DESCR', h_asset_id, period1_pod, period2_pcd, book,
1977: acct_all_segs(gl_balancing_seg));
1978: h_location :=
1979: fa_rx_shared_pkg.get_asset_info('LOCATION', h_asset_id, period1_pod, period2_pcd, distribution_source_book,
1980: acct_all_segs(gl_balancing_seg));

Line 1979: fa_rx_shared_pkg.get_asset_info('LOCATION', h_asset_id, period1_pod, period2_pcd, distribution_source_book,

1975: h_invoice_descr :=
1976: fa_rx_shared_pkg.get_asset_info('INVOICE_DESCR', h_asset_id, period1_pod, period2_pcd, book,
1977: acct_all_segs(gl_balancing_seg));
1978: h_location :=
1979: fa_rx_shared_pkg.get_asset_info('LOCATION', h_asset_id, period1_pod, period2_pcd, distribution_source_book,
1980: acct_all_segs(gl_balancing_seg));
1981: h_retirement_type :=
1982: fa_rx_shared_pkg.get_asset_info('RETIREMENT_TYPE',h_asset_id, period1_pod, period2_pcd, book,
1983: acct_all_segs(gl_balancing_seg));

Line 1982: fa_rx_shared_pkg.get_asset_info('RETIREMENT_TYPE',h_asset_id, period1_pod, period2_pcd, book,

1978: h_location :=
1979: fa_rx_shared_pkg.get_asset_info('LOCATION', h_asset_id, period1_pod, period2_pcd, distribution_source_book,
1980: acct_all_segs(gl_balancing_seg));
1981: h_retirement_type :=
1982: fa_rx_shared_pkg.get_asset_info('RETIREMENT_TYPE',h_asset_id, period1_pod, period2_pcd, book,
1983: acct_all_segs(gl_balancing_seg));
1984:
1985:
1986: if h_sorp_enabled_flag = 'N' then

Line 2014: fa_rx_shared_pkg.concat_asset_key (

2010: h_mesg_name := 'FA_RX_CONCAT_SEGS';
2011: h_flex_error := 'KEY#';
2012: h_ccid_error := h_asset_key_ccid;
2013:
2014: fa_rx_shared_pkg.concat_asset_key (
2015: struct_id => h_key_flex_struct,
2016: ccid => h_asset_key_ccid,
2017: concat_string => h_concat_key,
2018: segarray => h_key_segs);

Line 2033: fa_rx_shared_pkg.concat_category (

2029: h_mesg_name := 'FA_RX_CONCAT_SEGS';
2030: h_flex_error := 'CAT#';
2031: h_ccid_error := h_category_id;
2032:
2033: fa_rx_shared_pkg.concat_category (
2034: struct_id => h_cat_flex_struct,
2035: ccid => h_category_id,
2036: concat_string => h_concat_cat,
2037: segarray => h_cat_segs);

Line 2235: fa_rx_shared_pkg.get_acct_segments (

2231:
2232: h_mesg_name := 'FA_RX_CONCAT_SEGS';
2233: h_ccid_error := h_ccid;
2234:
2235: fa_rx_shared_pkg.get_acct_segments (
2236: combination_id => h_ccid,
2237: n_segments => n_segs,
2238: segments => acct_all_segs,
2239: calling_fn => 'FA_BALANCES_REPORT');

Line 2245: fa_rx_shared_pkg.get_flex_val_meaning(NULL, acct_valueset_name, h_account);

2241: /* StatReq - The following 6 function calls have been added to retrieve more
2242: detailed asset information */
2243:
2244: h_account_description :=
2245: fa_rx_shared_pkg.get_flex_val_meaning(NULL, acct_valueset_name, h_account);
2246:
2247: h_vendor_name :=
2248: fa_rx_shared_pkg.get_asset_info('VENDOR_NAME', h_asset_id, period1_pod, period2_pcd, book,
2249: acct_all_segs(gl_balancing_seg));

Line 2248: fa_rx_shared_pkg.get_asset_info('VENDOR_NAME', h_asset_id, period1_pod, period2_pcd, book,

2244: h_account_description :=
2245: fa_rx_shared_pkg.get_flex_val_meaning(NULL, acct_valueset_name, h_account);
2246:
2247: h_vendor_name :=
2248: fa_rx_shared_pkg.get_asset_info('VENDOR_NAME', h_asset_id, period1_pod, period2_pcd, book,
2249: acct_all_segs(gl_balancing_seg));
2250: h_invoice_number :=
2251: fa_rx_shared_pkg.get_asset_info('INVOICE_NUMBER', h_asset_id, period1_pod, period2_pcd, book,
2252: acct_all_segs(gl_balancing_seg));

Line 2251: fa_rx_shared_pkg.get_asset_info('INVOICE_NUMBER', h_asset_id, period1_pod, period2_pcd, book,

2247: h_vendor_name :=
2248: fa_rx_shared_pkg.get_asset_info('VENDOR_NAME', h_asset_id, period1_pod, period2_pcd, book,
2249: acct_all_segs(gl_balancing_seg));
2250: h_invoice_number :=
2251: fa_rx_shared_pkg.get_asset_info('INVOICE_NUMBER', h_asset_id, period1_pod, period2_pcd, book,
2252: acct_all_segs(gl_balancing_seg));
2253: h_invoice_descr :=
2254: fa_rx_shared_pkg.get_asset_info('INVOICE_DESCR', h_asset_id, period1_pod, period2_pcd, book,
2255: acct_all_segs(gl_balancing_seg));

Line 2254: fa_rx_shared_pkg.get_asset_info('INVOICE_DESCR', h_asset_id, period1_pod, period2_pcd, book,

2250: h_invoice_number :=
2251: fa_rx_shared_pkg.get_asset_info('INVOICE_NUMBER', h_asset_id, period1_pod, period2_pcd, book,
2252: acct_all_segs(gl_balancing_seg));
2253: h_invoice_descr :=
2254: fa_rx_shared_pkg.get_asset_info('INVOICE_DESCR', h_asset_id, period1_pod, period2_pcd, book,
2255: acct_all_segs(gl_balancing_seg));
2256: h_location :=
2257: fa_rx_shared_pkg.get_asset_info('LOCATION', h_asset_id, period1_pod, period2_pcd, distribution_source_book,
2258: acct_all_segs(gl_balancing_seg));

Line 2257: fa_rx_shared_pkg.get_asset_info('LOCATION', h_asset_id, period1_pod, period2_pcd, distribution_source_book,

2253: h_invoice_descr :=
2254: fa_rx_shared_pkg.get_asset_info('INVOICE_DESCR', h_asset_id, period1_pod, period2_pcd, book,
2255: acct_all_segs(gl_balancing_seg));
2256: h_location :=
2257: fa_rx_shared_pkg.get_asset_info('LOCATION', h_asset_id, period1_pod, period2_pcd, distribution_source_book,
2258: acct_all_segs(gl_balancing_seg));
2259: h_retirement_type :=
2260: fa_rx_shared_pkg.get_asset_info('RETIREMENT_TYPE',h_asset_id, period1_pod, period2_pcd, book,
2261: acct_all_segs(gl_balancing_seg));

Line 2260: fa_rx_shared_pkg.get_asset_info('RETIREMENT_TYPE',h_asset_id, period1_pod, period2_pcd, book,

2256: h_location :=
2257: fa_rx_shared_pkg.get_asset_info('LOCATION', h_asset_id, period1_pod, period2_pcd, distribution_source_book,
2258: acct_all_segs(gl_balancing_seg));
2259: h_retirement_type :=
2260: fa_rx_shared_pkg.get_asset_info('RETIREMENT_TYPE',h_asset_id, period1_pod, period2_pcd, book,
2261: acct_all_segs(gl_balancing_seg));
2262:
2263:
2264: if (nvl(h_begin,0) + nvl(h_addition,0) - nvl(h_capitalization,0)

Line 2276: fa_rx_shared_pkg.concat_asset_key (

2272: h_mesg_name := 'FA_RX_CONCAT_SEGS';
2273: h_flex_error := 'KEY#';
2274: h_ccid_error := h_asset_key_ccid;
2275:
2276: fa_rx_shared_pkg.concat_asset_key (
2277: struct_id => h_key_flex_struct,
2278: ccid => h_asset_key_ccid,
2279: concat_string => h_concat_key,
2280: segarray => h_key_segs);

Line 2296: fa_rx_shared_pkg.concat_category (

2292: h_mesg_name := 'FA_RX_CONCAT_SEGS';
2293: h_flex_error := 'CAT#';
2294: h_ccid_error := h_category_id;
2295:
2296: fa_rx_shared_pkg.concat_category (
2297: struct_id => h_cat_flex_struct,
2298: ccid => h_category_id,
2299: concat_string => h_concat_cat,
2300: segarray => h_cat_segs);