DBA Data[Home] [Help]

APPS.FARX_BL dependencies on FA_RX_SHARED_PKG

Line 46: acct_all_segs fa_rx_shared_pkg.Seg_Array;

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

Line 47: aj_acct_all_segs fa_rx_shared_pkg.Seg_Array;

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

Line 92: h_nq_col_names fa_rx_shared_pkg.Seg_Array;

88: h_nonqual_col_name varchar2(30);
89: h_nonqual_seg_name varchar2(30);
90: h_nonqual_seg_num varchar2(30);
91:
92: h_nq_col_names fa_rx_shared_pkg.Seg_Array;
93: h_nq_seg_names fa_rx_shared_pkg.Seg_Array;
94: h_nq_seg_nums fa_rx_shared_pkg.Seg_Array;
95: h_ctr number;
96:

Line 93: h_nq_seg_names fa_rx_shared_pkg.Seg_Array;

89: h_nonqual_seg_name varchar2(30);
90: h_nonqual_seg_num varchar2(30);
91:
92: h_nq_col_names fa_rx_shared_pkg.Seg_Array;
93: h_nq_seg_names fa_rx_shared_pkg.Seg_Array;
94: h_nq_seg_nums fa_rx_shared_pkg.Seg_Array;
95: h_ctr number;
96:
97: get_segments_success boolean;

Line 94: h_nq_seg_nums fa_rx_shared_pkg.Seg_Array;

90: h_nonqual_seg_num varchar2(30);
91:
92: h_nq_col_names fa_rx_shared_pkg.Seg_Array;
93: h_nq_seg_names fa_rx_shared_pkg.Seg_Array;
94: h_nq_seg_nums fa_rx_shared_pkg.Seg_Array;
95: h_ctr number;
96:
97: get_segments_success boolean;
98:

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

111:
112: h_asset_key_ccid number;
113: h_category_id number; /* StatReq */
114:
115: h_key_segs fa_rx_shared_pkg.Seg_Array; /* StatReq */
116: h_cat_segs fa_rx_shared_pkg.Seg_Array; /* StatReq */
117:
118: h_asset_id NUMBER; /* StatReq */
119: h_stl_depreciation_rate NUMBER; /* StatReq */

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

112: h_asset_key_ccid number;
113: h_category_id number; /* StatReq */
114:
115: h_key_segs fa_rx_shared_pkg.Seg_Array; /* StatReq */
116: h_cat_segs fa_rx_shared_pkg.Seg_Array; /* StatReq */
117:
118: h_asset_id NUMBER; /* StatReq */
119: h_stl_depreciation_rate NUMBER; /* StatReq */
120: h_date_placed_in_service DATE; /* StatReq */

Line 991: fa_rx_shared_pkg.get_acct_segment_numbers (

987: -- Will need these later for getting segments for given ccids.
988:
989: h_mesg_name := 'FA_RX_SEGNUMS';
990:
991: fa_rx_shared_pkg.get_acct_segment_numbers (
992: BOOK => Book,
993: BALANCING_SEGNUM => gl_balancing_seg,
994: ACCOUNT_SEGNUM => gl_account_seg,
995: CC_SEGNUM => fa_cost_ctr_seg,

Line 1004: fa_rx_shared_pkg.get_acct_segment_index (

1000: return_status := FND_FLEX_APIS.GET_SEGMENT_INFO
1001: (101, 'GL#', Acct_Flex_Structure, Gl_Account_Seg,
1002: Acct_Appl_Col, Acct_Segname, Acct_Prompt, Acct_Valueset_Name);
1003:
1004: fa_rx_shared_pkg.get_acct_segment_index (
1005: BOOK => Book,
1006: BALANCING_SEGNUM => gl_balancing_seg,
1007: ACCOUNT_SEGNUM => gl_account_seg,
1008: CC_SEGNUM => fa_cost_ctr_seg,

Line 1065: fa_rx_shared_pkg.get_acct_segments (

1061:
1062: h_mesg_name := 'FA_RX_CONCAT_SEGS';
1063: h_ccid_error := h_br_ajccid;
1064:
1065: fa_rx_shared_pkg.get_acct_segments (
1066: combination_id => h_br_ajccid,
1067: n_segments => n_segs,
1068: segments => acct_all_segs,
1069: calling_fn => 'FA_BALANCES_REPORT');

Line 1129: fa_rx_shared_pkg.get_acct_segments (

1125:
1126: h_mesg_name := 'FA_RX_CONCAT_SEGS';
1127: h_ccid_error := h_ccid;
1128:
1129: fa_rx_shared_pkg.get_acct_segments (
1130: combination_id => h_ccid,
1131: n_segments => n_segs,
1132: segments => acct_all_segs,
1133: calling_fn => 'FA_BALANCES_REPORT');

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

1135: /* StatReq - The following 6 function calls have been added to retrieve more
1136: detailed asset information */
1137:
1138: h_account_description :=
1139: fa_rx_shared_pkg.get_flex_val_meaning(NULL, acct_valueset_name, h_account);
1140:
1141: h_vendor_name :=
1142: fa_rx_shared_pkg.get_asset_info('VENDOR_NAME', h_asset_id, period1_pod, period2_pcd, book,
1143: acct_all_segs(gl_balancing_seg));

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

1138: h_account_description :=
1139: fa_rx_shared_pkg.get_flex_val_meaning(NULL, acct_valueset_name, h_account);
1140:
1141: h_vendor_name :=
1142: fa_rx_shared_pkg.get_asset_info('VENDOR_NAME', h_asset_id, period1_pod, period2_pcd, book,
1143: acct_all_segs(gl_balancing_seg));
1144: h_invoice_number :=
1145: fa_rx_shared_pkg.get_asset_info('INVOICE_NUMBER', h_asset_id, period1_pod, period2_pcd, book,
1146: acct_all_segs(gl_balancing_seg));

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

1141: h_vendor_name :=
1142: fa_rx_shared_pkg.get_asset_info('VENDOR_NAME', h_asset_id, period1_pod, period2_pcd, book,
1143: acct_all_segs(gl_balancing_seg));
1144: h_invoice_number :=
1145: fa_rx_shared_pkg.get_asset_info('INVOICE_NUMBER', h_asset_id, period1_pod, period2_pcd, book,
1146: acct_all_segs(gl_balancing_seg));
1147: h_invoice_descr :=
1148: fa_rx_shared_pkg.get_asset_info('INVOICE_DESCR', h_asset_id, period1_pod, period2_pcd, book,
1149: acct_all_segs(gl_balancing_seg));

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

1144: h_invoice_number :=
1145: fa_rx_shared_pkg.get_asset_info('INVOICE_NUMBER', h_asset_id, period1_pod, period2_pcd, book,
1146: acct_all_segs(gl_balancing_seg));
1147: h_invoice_descr :=
1148: fa_rx_shared_pkg.get_asset_info('INVOICE_DESCR', h_asset_id, period1_pod, period2_pcd, book,
1149: acct_all_segs(gl_balancing_seg));
1150: h_location :=
1151: fa_rx_shared_pkg.get_asset_info('LOCATION', h_asset_id, period1_pod, period2_pcd, distribution_source_book,
1152: acct_all_segs(gl_balancing_seg));

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

1147: h_invoice_descr :=
1148: fa_rx_shared_pkg.get_asset_info('INVOICE_DESCR', h_asset_id, period1_pod, period2_pcd, book,
1149: acct_all_segs(gl_balancing_seg));
1150: h_location :=
1151: fa_rx_shared_pkg.get_asset_info('LOCATION', h_asset_id, period1_pod, period2_pcd, distribution_source_book,
1152: acct_all_segs(gl_balancing_seg));
1153: h_retirement_type :=
1154: fa_rx_shared_pkg.get_asset_info('RETIREMENT_TYPE',h_asset_id, period1_pod, period2_pcd, book,
1155: acct_all_segs(gl_balancing_seg));

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

1150: h_location :=
1151: fa_rx_shared_pkg.get_asset_info('LOCATION', h_asset_id, period1_pod, period2_pcd, distribution_source_book,
1152: acct_all_segs(gl_balancing_seg));
1153: h_retirement_type :=
1154: fa_rx_shared_pkg.get_asset_info('RETIREMENT_TYPE',h_asset_id, period1_pod, period2_pcd, book,
1155: acct_all_segs(gl_balancing_seg));
1156:
1157:
1158: h_adjustment := nvl(h_tax,0) + nvl(h_revaluation,0);

Line 1172: fa_rx_shared_pkg.concat_asset_key (

1168: h_mesg_name := 'FA_RX_CONCAT_SEGS';
1169: h_flex_error := 'KEY#';
1170: h_ccid_error := h_asset_key_ccid;
1171:
1172: fa_rx_shared_pkg.concat_asset_key (
1173: struct_id => h_key_flex_struct,
1174: ccid => h_asset_key_ccid,
1175: concat_string => h_concat_key,
1176: segarray => h_key_segs);

Line 1191: fa_rx_shared_pkg.concat_category (

1187: h_mesg_name := 'FA_RX_CONCAT_SEGS';
1188: h_flex_error := 'CAT#';
1189: h_ccid_error := h_category_id;
1190:
1191: fa_rx_shared_pkg.concat_category (
1192: struct_id => h_cat_flex_struct,
1193: ccid => h_category_id,
1194: concat_string => h_concat_cat,
1195: segarray => h_cat_segs);

Line 1336: fa_rx_shared_pkg.get_acct_segments (

1332:
1333: h_mesg_name := 'FA_RX_CONCAT_SEGS';
1334: h_ccid_error := h_ccid;
1335:
1336: fa_rx_shared_pkg.get_acct_segments (
1337: combination_id => h_ccid,
1338: n_segments => n_segs,
1339: segments => acct_all_segs,
1340: calling_fn => 'FA_BALANCES_REPORT');

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

1342: /* StatReq - The following 6 function calls have been added to retrieve more
1343: detailed asset information */
1344:
1345: h_account_description :=
1346: fa_rx_shared_pkg.get_flex_val_meaning(NULL, acct_valueset_name, h_account);
1347:
1348: h_vendor_name :=
1349: fa_rx_shared_pkg.get_asset_info('VENDOR_NAME', h_asset_id, period1_pod, period2_pcd, book,
1350: acct_all_segs(gl_balancing_seg));

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

1345: h_account_description :=
1346: fa_rx_shared_pkg.get_flex_val_meaning(NULL, acct_valueset_name, h_account);
1347:
1348: h_vendor_name :=
1349: fa_rx_shared_pkg.get_asset_info('VENDOR_NAME', h_asset_id, period1_pod, period2_pcd, book,
1350: acct_all_segs(gl_balancing_seg));
1351: h_invoice_number :=
1352: fa_rx_shared_pkg.get_asset_info('INVOICE_NUMBER', h_asset_id, period1_pod, period2_pcd, book,
1353: acct_all_segs(gl_balancing_seg));

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

1348: h_vendor_name :=
1349: fa_rx_shared_pkg.get_asset_info('VENDOR_NAME', h_asset_id, period1_pod, period2_pcd, book,
1350: acct_all_segs(gl_balancing_seg));
1351: h_invoice_number :=
1352: fa_rx_shared_pkg.get_asset_info('INVOICE_NUMBER', h_asset_id, period1_pod, period2_pcd, book,
1353: acct_all_segs(gl_balancing_seg));
1354: h_invoice_descr :=
1355: fa_rx_shared_pkg.get_asset_info('INVOICE_DESCR', h_asset_id, period1_pod, period2_pcd, book,
1356: acct_all_segs(gl_balancing_seg));

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

1351: h_invoice_number :=
1352: fa_rx_shared_pkg.get_asset_info('INVOICE_NUMBER', h_asset_id, period1_pod, period2_pcd, book,
1353: acct_all_segs(gl_balancing_seg));
1354: h_invoice_descr :=
1355: fa_rx_shared_pkg.get_asset_info('INVOICE_DESCR', h_asset_id, period1_pod, period2_pcd, book,
1356: acct_all_segs(gl_balancing_seg));
1357: h_location :=
1358: fa_rx_shared_pkg.get_asset_info('LOCATION', h_asset_id, period1_pod, period2_pcd, distribution_source_book,
1359: acct_all_segs(gl_balancing_seg));

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

1354: h_invoice_descr :=
1355: fa_rx_shared_pkg.get_asset_info('INVOICE_DESCR', h_asset_id, period1_pod, period2_pcd, book,
1356: acct_all_segs(gl_balancing_seg));
1357: h_location :=
1358: fa_rx_shared_pkg.get_asset_info('LOCATION', h_asset_id, period1_pod, period2_pcd, distribution_source_book,
1359: acct_all_segs(gl_balancing_seg));
1360: h_retirement_type :=
1361: fa_rx_shared_pkg.get_asset_info('RETIREMENT_TYPE',h_asset_id, period1_pod, period2_pcd, book,
1362: acct_all_segs(gl_balancing_seg));

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

1357: h_location :=
1358: fa_rx_shared_pkg.get_asset_info('LOCATION', h_asset_id, period1_pod, period2_pcd, distribution_source_book,
1359: acct_all_segs(gl_balancing_seg));
1360: h_retirement_type :=
1361: fa_rx_shared_pkg.get_asset_info('RETIREMENT_TYPE',h_asset_id, period1_pod, period2_pcd, book,
1362: acct_all_segs(gl_balancing_seg));
1363:
1364:
1365: if (nvl(h_begin,0) + nvl(h_addition,0) - nvl(h_capitalization,0)

Line 1377: fa_rx_shared_pkg.concat_asset_key (

1373: h_mesg_name := 'FA_RX_CONCAT_SEGS';
1374: h_flex_error := 'KEY#';
1375: h_ccid_error := h_asset_key_ccid;
1376:
1377: fa_rx_shared_pkg.concat_asset_key (
1378: struct_id => h_key_flex_struct,
1379: ccid => h_asset_key_ccid,
1380: concat_string => h_concat_key,
1381: segarray => h_key_segs);

Line 1397: fa_rx_shared_pkg.concat_category (

1393: h_mesg_name := 'FA_RX_CONCAT_SEGS';
1394: h_flex_error := 'CAT#';
1395: h_ccid_error := h_category_id;
1396:
1397: fa_rx_shared_pkg.concat_category (
1398: struct_id => h_cat_flex_struct,
1399: ccid => h_category_id,
1400: concat_string => h_concat_cat,
1401: segarray => h_cat_segs);