APPS.FTP_TP_PKG dependencies on FTP_RATE_OUTPUT_MAPPING_RULE

Line 41: -- Record type for FTP_RATE_OUTPUT_MAPPING_RULE

37: -- Praveen Attaluri (Bug Fix)
38: LEDGER_NAME varchar2(30) := 'FEM_BALANCES';
39:
40: -- Tina Dasgupta (R12 FTP Enhancements)
41: -- Record type for FTP_RATE_OUTPUT_MAPPING_RULE
42: type t_alt_rate_obj is record (
43: obj_def_id number,
44: Account_Table_Name varchar2(2000),
45: TRANSFER_RATE_COL_NAME varchar2(2000),

Line 63: -- Global List of table names that have valid mappings defined in FTP_RATE_OUTPUT_MAPPING_RULE

59:
60: -- Globals that indicate whether the the global varb exists or not
61: g_alt_rate_obj_exists BOOLEAN := FALSE;
62:
63: -- Global List of table names that have valid mappings defined in FTP_RATE_OUTPUT_MAPPING_RULE
64: valid_table_list varchar2(3000);
65: g_block VARCHAR2(1000) := 'ftp.plsql.FTP_PKG.';
66:
67:

Line 2462: FTP_RATE_OUTPUT_MAPPING_RULE.

2458: END CHAINING_EXISTS;
2459:
2460: /***************************************************************************
2461: Desc : Procedure to return the valid list of table names present in the
2462: FTP_RATE_OUTPUT_MAPPING_RULE.
2463: Pgmr : Tina Dasgupta
2464: Date : 25-Oct-2006
2465: **************************************************************************/
2466: procedure GET_VALID_TABLE_LIST(

Line 2634: FROM fem_tab_columns_v i, FTP_RATE_OUTPUT_MAPPING_RULE j, ftp_tp_proc_tabls_params k

2630: max(DECODE(HIST_STAT_SPREAD_COL_NAME, column_name, HIST_STAT_SPREAD_COL_NAME, NULL,NULL, -1)) as hist_stat_spr,
2631: max(DECODE(CUR_STAT_SPREAD_COL_NAME, column_name, CUR_STAT_SPREAD_COL_NAME, NULL,NULL, -1)) as cur_stat_spr,
2632: max(DECODE(ADJUSTMENT_AMOUNT_COL_NAME, column_name, ADJUSTMENT_AMOUNT_COL_NAME, NULL,NULL, -1)) as adj_amt,
2633: max(DECODE(CUR_OAS_COL_NAME, column_name, CUR_OAS_COL_NAME, NULL,NULL, -1)) as cur_option
2634: FROM fem_tab_columns_v i, FTP_RATE_OUTPUT_MAPPING_RULE j, ftp_tp_proc_tabls_params k
2635: WHERE i.table_name = j. FTP_ACCOUNT_TABLE_NAME
2636: AND j. FTP_ACCOUNT_TABLE_NAME = k.table_name
2637: AND job_id = jobid
2638: AND k.object_definition_id = process_info.obj_id