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.PQH_SS_PRINT dependencies on FND_DATE

Line 180: l_effective_date := fnd_date.canonical_to_date(p_effective_date);

176: Fetch csr_parameter_value into l_parameter_value;
177: CLOSE csr_parameter_value;
178: --
179: -- Set the date
180: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
181:
182: If (l_effective_date is null) then
183: l_effective_date := trunc(sysdate);
184: End if;

Line 233: SELECT atv.name column_name,atv.datatype column_type,atv.varchar2_value|| Atv.Number_value||FND_DATE.date_to_canonical(Atv.date_value) column_value

229: --This cursor obtain the values of hte parameters used in where clause of different Table_routes
230: -- 'P_SELECTED_EMP_ID, P_PASSED_ASSIGNMENT_ID removed from list as current
231: --manager not obtained from base table but from transaction table.
232: Cursor obtain_param_values is
233: SELECT atv.name column_name,atv.datatype column_type,atv.varchar2_value|| Atv.Number_value||FND_DATE.date_to_canonical(Atv.date_value) column_value
234: FROM hr_api_transaction_values atv
235: WHERE atv.transaction_step_id in (Select max(transaction_step_id)
236: From hr_api_transaction_steps
237: where transaction_id = p_Transaction_Id

Line 246: params_table(1).param_value := fnd_date.date_to_canonical(p_effective_date);

242:
243: BEGIN
244: --Setting the where clause params in params table
245: params_table(1).param_name := 'p_effective_date';
246: params_table(1).param_value := fnd_date.date_to_canonical(p_effective_date);
247: params_table(1).param_data_type := 'D';
248: params_table(2).param_name := 'p_assignment_id';
249: params_table(2).param_value := 'NULL';
250: params_table(2).param_data_type := 'N';

Line 1010: l_col_val := ' fnd_date.canonical_to_date(''' || l_col_val || ''')';

1006: IF UPPER(params_table(i).param_name) = UPPER(p_column_name) THEN
1007: l_col_val := params_table(i).param_value;
1008: l_col_type := params_table(i).param_data_type;
1009: IF l_col_type = 'D' THEN
1010: l_col_val := ' fnd_date.canonical_to_date(''' || l_col_val || ''')';
1011: ELSIF l_col_type = 'V' THEN
1012: l_col_val := '''' || l_col_val || '''';
1013: END IF;
1014: hr_utility.set_location('Name ' || p_column_name || ' value ' || l_col_val,8);

Line 1162: l_inputs(l_in_cnt).value := fnd_date.date_to_canonical(p_effective_date);

1158: elsif(l_inputs(l_in_cnt).name = 'P_TRANS_ID') then
1159: l_inputs(l_in_cnt).value:=p_transaction_id;
1160: --
1161: elsif(l_inputs(l_in_cnt).name = 'P_EFFECTIVE_DATE') then
1162: l_inputs(l_in_cnt).value := fnd_date.date_to_canonical(p_effective_date);
1163: l_inputs(l_in_cnt).datatype := 'DATE';
1164: --
1165: elsif(l_inputs(l_in_cnt).name = 'P_GROUP_PER_IN_LER_ID') then
1166: l_inputs(l_in_cnt).value := p_group_per_in_ler_id;

Line 1172: l_inputs(l_in_cnt).value := fnd_date.date_to_canonical(p_lf_evt_ocrd_dt);

1168: elsif(l_inputs(l_in_cnt).name = 'P_GROUP_PLAN_ID') then
1169: l_inputs(l_in_cnt).value := p_group_plan_id;
1170: --
1171: elsif(l_inputs(l_in_cnt).name = 'P_LIFE_EVENT_DATE') then
1172: l_inputs(l_in_cnt).value := fnd_date.date_to_canonical(p_lf_evt_ocrd_dt);
1173: l_inputs(l_in_cnt).datatype := 'DATE';
1174: --
1175: end if;
1176: end loop;

Line 1343: p_effective_date=>fnd_date.date_to_canonical(p_effective_date));

1339:
1340: l_approval_type := get_function_parameter_value(
1341: p_parameter_name=>'TYPE',
1342: p_transaction_id =>p_transaction_id,
1343: p_effective_date=>fnd_date.date_to_canonical(p_effective_date));
1344:
1345:
1346: --dt_fndate.set_effective_date(fnd_date.canonical_to_date(p_effective_date));
1347:

Line 1346: --dt_fndate.set_effective_date(fnd_date.canonical_to_date(p_effective_date));

1342: p_transaction_id =>p_transaction_id,
1343: p_effective_date=>fnd_date.date_to_canonical(p_effective_date));
1344:
1345:
1346: --dt_fndate.set_effective_date(fnd_date.canonical_to_date(p_effective_date));
1347:
1348: hr_util_misc_ss.setEffectiveDate(p_effective_date);
1349: l_pdf_short_name := p_doc_short_name;
1350:

Line 1375: decode(atv.varchar2_value|| Atv.Number_value||FND_DATE.date_to_canonical(Atv.date_value),

1371: SELECT userenv('sessionid'),p_transaction_id,
1372: doa.tag_name NAME,
1373: decode(att.decode_function_name,null,atv.varchar2_value|| Atv.Number_value||Atv.date_value,
1374: pqh_ss_utility.get_desc (
1375: decode(atv.varchar2_value|| Atv.Number_value||FND_DATE.date_to_canonical(Atv.date_value),
1376: null,null,
1377: att.decode_function_name||'('''||atv.varchar2_value|| Atv.Number_value
1378: ||FND_DATE.date_to_canonical(Atv.date_value)||''')' ) )) value,
1379: att.enable_flag

Line 1378: ||FND_DATE.date_to_canonical(Atv.date_value)||''')' ) )) value,

1374: pqh_ss_utility.get_desc (
1375: decode(atv.varchar2_value|| Atv.Number_value||FND_DATE.date_to_canonical(Atv.date_value),
1376: null,null,
1377: att.decode_function_name||'('''||atv.varchar2_value|| Atv.Number_value
1378: ||FND_DATE.date_to_canonical(Atv.date_value)||''')' ) )) value,
1379: att.enable_flag
1380: FROM hr_api_transaction_steps steps
1381: , hr_api_transaction_values atv,
1382: pqh_documents_f doc,