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.PFT_AR_ENGINE_PVT dependencies on PFT_AR_DRIVERS_T

Line 106: type g_request_id_table is table of PFT_AR_DRIVERS_T.CREATED_BY_REQUEST_ID%TYPE

102: ------------------------------
103: -- Global PL/SQL types
104: ------------------------------
105:
106: type g_request_id_table is table of PFT_AR_DRIVERS_T.CREATED_BY_REQUEST_ID%TYPE
107: index by BINARY_INTEGER;
108:
109: type g_object_id_table is table of PFT_AR_DRIVERS_T.CREATED_BY_OBJECT_ID%TYPE
110: index by BINARY_INTEGER;

Line 109: type g_object_id_table is table of PFT_AR_DRIVERS_T.CREATED_BY_OBJECT_ID%TYPE

105:
106: type g_request_id_table is table of PFT_AR_DRIVERS_T.CREATED_BY_REQUEST_ID%TYPE
107: index by BINARY_INTEGER;
108:
109: type g_object_id_table is table of PFT_AR_DRIVERS_T.CREATED_BY_OBJECT_ID%TYPE
110: index by BINARY_INTEGER;
111:
112: type g_drv_table_name_table is table of PFT_AR_DRIVERS_T.SOURCE_TABLE_NAME%TYPE
113: index by BINARY_INTEGER;

Line 112: type g_drv_table_name_table is table of PFT_AR_DRIVERS_T.SOURCE_TABLE_NAME%TYPE

108:
109: type g_object_id_table is table of PFT_AR_DRIVERS_T.CREATED_BY_OBJECT_ID%TYPE
110: index by BINARY_INTEGER;
111:
112: type g_drv_table_name_table is table of PFT_AR_DRIVERS_T.SOURCE_TABLE_NAME%TYPE
113: index by BINARY_INTEGER;
114:
115: type g_column_name_table is table of PFT_AR_DRIVERS_T.COLUMN_NAME%TYPE
116: index by BINARY_INTEGER;

Line 115: type g_column_name_table is table of PFT_AR_DRIVERS_T.COLUMN_NAME%TYPE

111:
112: type g_drv_table_name_table is table of PFT_AR_DRIVERS_T.SOURCE_TABLE_NAME%TYPE
113: index by BINARY_INTEGER;
114:
115: type g_column_name_table is table of PFT_AR_DRIVERS_T.COLUMN_NAME%TYPE
116: index by BINARY_INTEGER;
117:
118: type g_statistic_basis_id_table is table of PFT_AR_DRIVERS_T.STATISTIC_BASIS_ID%TYPE
119: index by BINARY_INTEGER;

Line 118: type g_statistic_basis_id_table is table of PFT_AR_DRIVERS_T.STATISTIC_BASIS_ID%TYPE

114:
115: type g_column_name_table is table of PFT_AR_DRIVERS_T.COLUMN_NAME%TYPE
116: index by BINARY_INTEGER;
117:
118: type g_statistic_basis_id_table is table of PFT_AR_DRIVERS_T.STATISTIC_BASIS_ID%TYPE
119: index by BINARY_INTEGER;
120:
121: type g_condition_obj_id_table is table of PFT_AR_DRIVERS_T.CONDITION_OBJ_ID%TYPE
122: index by BINARY_INTEGER;

Line 121: type g_condition_obj_id_table is table of PFT_AR_DRIVERS_T.CONDITION_OBJ_ID%TYPE

117:
118: type g_statistic_basis_id_table is table of PFT_AR_DRIVERS_T.STATISTIC_BASIS_ID%TYPE
119: index by BINARY_INTEGER;
120:
121: type g_condition_obj_id_table is table of PFT_AR_DRIVERS_T.CONDITION_OBJ_ID%TYPE
122: index by BINARY_INTEGER;
123:
124: type g_valid_flag_table is table of PFT_AR_DRIVERS_T.VALID_FLAG%TYPE
125: index by BINARY_INTEGER;

Line 124: type g_valid_flag_table is table of PFT_AR_DRIVERS_T.VALID_FLAG%TYPE

120:
121: type g_condition_obj_id_table is table of PFT_AR_DRIVERS_T.CONDITION_OBJ_ID%TYPE
122: index by BINARY_INTEGER;
123:
124: type g_valid_flag_table is table of PFT_AR_DRIVERS_T.VALID_FLAG%TYPE
125: index by BINARY_INTEGER;
126:
127: type g_driver_value_table is table of PFT_AR_DRIVERS_T.DRIVER_VALUE%TYPE
128: index by BINARY_INTEGER;

Line 127: type g_driver_value_table is table of PFT_AR_DRIVERS_T.DRIVER_VALUE%TYPE

123:
124: type g_valid_flag_table is table of PFT_AR_DRIVERS_T.VALID_FLAG%TYPE
125: index by BINARY_INTEGER;
126:
127: type g_driver_value_table is table of PFT_AR_DRIVERS_T.DRIVER_VALUE%TYPE
128: index by BINARY_INTEGER;
129:
130: type g_last_update_date_table is table of PFT_AR_DRIVERS_T.LAST_UPDATE_DATE%TYPE
131: index by BINARY_INTEGER;

Line 130: type g_last_update_date_table is table of PFT_AR_DRIVERS_T.LAST_UPDATE_DATE%TYPE

126:
127: type g_driver_value_table is table of PFT_AR_DRIVERS_T.DRIVER_VALUE%TYPE
128: index by BINARY_INTEGER;
129:
130: type g_last_update_date_table is table of PFT_AR_DRIVERS_T.LAST_UPDATE_DATE%TYPE
131: index by BINARY_INTEGER;
132:
133: type g_invalid_reason_table is table of PFT_AR_DRIVERS_T.INVALID_REASON%TYPE
134: index by BINARY_INTEGER;

Line 133: type g_invalid_reason_table is table of PFT_AR_DRIVERS_T.INVALID_REASON%TYPE

129:
130: type g_last_update_date_table is table of PFT_AR_DRIVERS_T.LAST_UPDATE_DATE%TYPE
131: index by BINARY_INTEGER;
132:
133: type g_invalid_reason_table is table of PFT_AR_DRIVERS_T.INVALID_REASON%TYPE
134: index by BINARY_INTEGER;
135:
136: -----------------------------------------------
137: -- Declare private procedures and functions --

Line 2895: -- Register the PFT_AR_DRIVERS_T processing table as INSERT. This is needed

2891: ,p_table_name => 'FEM_BALANCES'
2892: ,p_statement_type => 'INSERT'
2893: );
2894:
2895: -- Register the PFT_AR_DRIVERS_T processing table as INSERT. This is needed
2896: -- in the event of a engine failure where the only way to purge these records
2897: -- is through the Undo Process
2898: Register_Table (
2899: p_request_rec => p_request_rec

Line 2901: ,p_table_name => 'PFT_AR_DRIVERS_T'

2897: -- is through the Undo Process
2898: Register_Table (
2899: p_request_rec => p_request_rec
2900: ,p_rule_rec => p_rule_rec
2901: ,p_table_name => 'PFT_AR_DRIVERS_T'
2902: ,p_statement_type => 'INSERT'
2903: );
2904:
2905: -- Register the PFT_AR_DRIVER_VALUES_T processing table as INSERT. This is needed

Line 3356: -- PFT_AR_DRIVERS_T.

3352: commit;
3353:
3354: ------------------------------------------------------------------------------
3355: -- Create Driver Sequence for peforming Activity Rate Driver Processing in
3356: -- PFT_AR_DRIVERS_T.
3357: ------------------------------------------------------------------------------
3358: begin
3359: -- Temporary sequence is in the default APPS schema as GSCC does not
3360: -- allow hardcoded schemas.

Line 3504: -- PFT_AR_DRIVERS_T.

3500: end if;
3501:
3502: ------------------------------------------------------------------------------
3503: -- Create Driver Sequence for peforming Activity Rate Driver Processing in
3504: -- PFT_AR_DRIVERS_T.
3505: ------------------------------------------------------------------------------
3506: begin
3507: select 'Y'
3508: into l_object_exists_flag

Line 3733: ' INSERT INTO PFT_AR_DRIVERS_T('||

3729:
3730: BEGIN
3731:
3732: EXECUTE IMMEDIATE
3733: ' INSERT INTO PFT_AR_DRIVERS_T('||
3734: ' CREATED_BY_REQUEST_ID'||
3735: ' ,CREATED_BY_OBJECT_ID'||
3736: ' ,SEQ_ID'||
3737: ' ,SOURCE_TABLE_NAME'||

Line 3798: ,p_data_table => 'PFT_AR_DRIVERS_T'

3794: x_prg_stat => l_mp_prog_status
3795: ,x_exception_code => l_mp_exception_code
3796: ,p_rule_id => p_rule_rec.act_rate_obj_id
3797: ,p_eng_step => L_CALC_DRIVER_VALUES
3798: ,p_data_table => 'PFT_AR_DRIVERS_T'
3799: ,p_eng_sql => null
3800: ,p_table_alias => 'drv'
3801: ,p_run_name => L_CALC_DRIVER_VALUES
3802: ,p_eng_prg => 'PFT_AR_ENGINE_PVT.Calc_Driver_Values'

Line 3894: FROM PFT_AR_DRIVERS_T

3890:
3891: -- IF all drivers are invalid then report DRIVER_NOT_VALID error
3892: SELECT count(*)
3893: INTO l_valid_drv_count
3894: FROM PFT_AR_DRIVERS_T
3895: WHERE CREATED_BY_REQUEST_ID = p_request_rec.request_id
3896: AND CREATED_BY_OBJECT_ID = p_rule_rec.act_rate_obj_id
3897: AND VALID_FLAG = 'Y';
3898:

Line 3935: ,p_value1 => 'PFT_AR_DRIVERS_T'

3931: FEM_ENGINES_PKG.User_Message (
3932: p_app_name => G_PFT
3933: ,p_msg_name => G_AR_ALL_INV_DRIV_ERR
3934: ,p_token1 => 'TABLE_NAME'
3935: ,p_value1 => 'PFT_AR_DRIVERS_T'
3936: ,p_token2 => 'OBJECT_ID'
3937: ,p_value2 => p_rule_rec.act_rate_obj_id
3938: );
3939:

Line 4089: -- STEP 1: Build MP SQL Statement for fetching rows in PFT_AR_DRIVERS_T

4085: l_fetch_limit := G_DEFAULT_FETCH_LIMIT;
4086: end if;
4087:
4088: ------------------------------------------------------------------------------
4089: -- STEP 1: Build MP SQL Statement for fetching rows in PFT_AR_DRIVERS_T
4090: ------------------------------------------------------------------------------
4091:
4092: FEM_ENGINES_PKG.Tech_Message (
4093: p_severity => G_LOG_LEVEL_1

Line 4095: ,p_msg_text => 'Step 1: Build MP SQL Statement for fetching rows in PFT_AR_DRIVERS_T'

4091:
4092: FEM_ENGINES_PKG.Tech_Message (
4093: p_severity => G_LOG_LEVEL_1
4094: ,p_module => G_BLOCK||'.'||L_API_NAME
4095: ,p_msg_text => 'Step 1: Build MP SQL Statement for fetching rows in PFT_AR_DRIVERS_T'
4096: );
4097:
4098: if (G_MP_ENABLED) then
4099: -- Get the Data Slice

Line 4124: ' from pft_ar_drivers_t {{table_partition}} drv'||

4120: ' ,valid_flag'||
4121: ' ,driver_value'||
4122: ' ,last_update_date'||
4123: ' ,invalid_reason'||
4124: ' from pft_ar_drivers_t {{table_partition}} drv'||
4125: ' where created_by_request_id = '||p_request_id||
4126: ' and created_by_object_id = '||p_act_rate_obj_id||
4127: ' and {{data_slice}} ';
4128:

Line 4154: -- STEP 2: Open MP Cursor for fetching rows in PFT_AR_DRIVERS_T

4150: ,p_msg_text => 'l_ar_drivers_stmt = '||l_ar_drivers_stmt
4151: );
4152:
4153: ------------------------------------------------------------------------------
4154: -- STEP 2: Open MP Cursor for fetching rows in PFT_AR_DRIVERS_T
4155: ------------------------------------------------------------------------------
4156:
4157: FEM_ENGINES_PKG.Tech_Message (
4158: p_severity => G_LOG_LEVEL_1

Line 4160: ,p_msg_text => 'Step 2: Open MP Cursor for fetching rows in PFT_AR_DRIVERS_T'

4156:
4157: FEM_ENGINES_PKG.Tech_Message (
4158: p_severity => G_LOG_LEVEL_1
4159: ,p_module => G_BLOCK||'.'||L_API_NAME
4160: ,p_msg_text => 'Step 2: Open MP Cursor for fetching rows in PFT_AR_DRIVERS_T'
4161: );
4162:
4163: -- Execute the built SQL statement for opening the cursor
4164: if (l_num_vals = 4) then

Line 4393: -- STEP 4: Bulk Update PFT_AR_DRIVERS_T Table

4389:
4390: end loop;
4391:
4392: ----------------------------------------------------------------------------
4393: -- STEP 4: Bulk Update PFT_AR_DRIVERS_T Table
4394: ----------------------------------------------------------------------------
4395:
4396: FEM_ENGINES_PKG.Tech_Message (
4397: p_severity => G_LOG_LEVEL_1

Line 4399: ,p_msg_text => 'Step 4: Bulk Update PFT_AR_DRIVERS_T Table'

4395:
4396: FEM_ENGINES_PKG.Tech_Message (
4397: p_severity => G_LOG_LEVEL_1
4398: ,p_module => G_BLOCK||'.'||L_API_NAME
4399: ,p_msg_text => 'Step 4: Bulk Update PFT_AR_DRIVERS_T Table'
4400: );
4401:
4402: forall rec_num in l_rowid_tbl.FIRST..l_rowid_tbl.LAST
4403: update pft_ar_drivers_t

Line 4403: update pft_ar_drivers_t

4399: ,p_msg_text => 'Step 4: Bulk Update PFT_AR_DRIVERS_T Table'
4400: );
4401:
4402: forall rec_num in l_rowid_tbl.FIRST..l_rowid_tbl.LAST
4403: update pft_ar_drivers_t
4404: set driver_value = l_driver_value_tbl(rec_num)
4405: ,valid_flag = l_valid_flag_tbl(rec_num)
4406: ,invalid_reason = l_invalid_reason_tbl(rec_num)
4407: where rowid = l_rowid_tbl(rec_num);

Line 4440: ' from pft_ar_drivers_t {{table_partition}} drv'||

4436: ' ,'||p_act_rate_obj_id||
4437: ' ,assgn.activity_id'||
4438: ' ,drv.driver_value'||
4439: ' ,assgn.statistic_basis_id'||
4440: ' from pft_ar_drivers_t {{table_partition}} drv'||
4441: ' ,pft_activity_driver_asgn assgn'||
4442: ' where drv.created_by_request_id = '||p_request_id||
4443: ' and drv.created_by_object_id = '||p_act_rate_obj_id||
4444: ' and drv.valid_flag = ''Y'''||

Line 5127: -- STEP 2.2: Delete all records in the PFT_AR_DRIVERS_T table

5123:
5124: commit;
5125:
5126: ----------------------------------------------------------------------------
5127: -- STEP 2.2: Delete all records in the PFT_AR_DRIVERS_T table
5128: ----------------------------------------------------------------------------
5129:
5130: FEM_ENGINES_PKG.Tech_Message (
5131: p_severity => G_LOG_LEVEL_1

Line 5133: ,p_msg_text => 'Step 2.2: Purging Records in PFT_AR_DRIVERS_T'

5129:
5130: FEM_ENGINES_PKG.Tech_Message (
5131: p_severity => G_LOG_LEVEL_1
5132: ,p_module => G_BLOCK||'.'||L_API_NAME
5133: ,p_msg_text => 'Step 2.2: Purging Records in PFT_AR_DRIVERS_T'
5134: );
5135:
5136: delete from pft_ar_drivers_t
5137: where created_by_request_id = p_request_rec.request_id

Line 5136: delete from pft_ar_drivers_t

5132: ,p_module => G_BLOCK||'.'||L_API_NAME
5133: ,p_msg_text => 'Step 2.2: Purging Records in PFT_AR_DRIVERS_T'
5134: );
5135:
5136: delete from pft_ar_drivers_t
5137: where created_by_request_id = p_request_rec.request_id
5138: and created_by_object_id = p_rule_rec.act_rate_obj_id;
5139:
5140: commit;