APPS.CSF_DEBRIEF_UPDATE_PKG dependencies on FND_PROFILE

Line 98: fnd_profile.value('CSF_DEBRIEF_TRANSACTION_DATE');

94: l_source_type_code Varchar2(10) ;
95: l_repair_line_id Number ;
96: l_service_date Date ;
97: l_date_type varchar2(30) :=
98: fnd_profile.value('CSF_DEBRIEF_TRANSACTION_DATE');
99: l_inv_transaction_type_id Number ;
100: l_organization_id Number ;
101: l_issuing_inventory_org_id Number ;
102: l_receiving_inventory_org_id Number ;

Line 207: select fnd_profile.value('CSF_DEBRIEF_ERROR_STATUS'),

203: where source_code = 'SD'
204: and source_id = p_debrief_line_id;
205:
206: cursor c_debrief_error is
207: select fnd_profile.value('CSF_DEBRIEF_ERROR_STATUS'),
208: jta.assignment_status_id,
209: jta.object_version_number
210: from jtf_task_assignments jta
211: where jta.task_assignment_id = l_task_assignment_id;

Line 1005: l_profile_hours := fnd_profile.value('CSF_UOM_HOURS');

1001: l_time_diff := to_date(l_labor_end_date,'dd-mm-rrrr hh24:mi:ss')
1002: - to_date(l_labor_start_date,'dd-mm-rrrr hh24:mi:ss');
1003:
1004: l_time_diff := l_time_diff * 24;
1005: l_profile_hours := fnd_profile.value('CSF_UOM_HOURS');
1006: l_quantity := inv_convert.inv_um_convert
1007: (Null,
1008: 2,
1009: l_time_diff,