DBA Data[Home] [Help]

APPS.PQP_BUDGET_MAINTENANCE dependencies on FND_DATE

Line 236: fnd_date.canonical_to_date(get_parameter_value('EFFECTIVE DATE'

232: get_parameter_value('UOM', g_parameter_list);
233: g_action :=
234: get_parameter_value('ACTION', g_parameter_list);
235: g_effective_date :=
236: fnd_date.canonical_to_date(get_parameter_value('EFFECTIVE DATE'
237: ,g_parameter_list
238: )
239: );
240: g_business_group_id := fnd_profile.VALUE('PER_BUSINESS_GROUP_ID');

Line 242: fnd_date.canonical_to_date(get_parameter_value('EFFECTIVE DATE'

238: )
239: );
240: g_business_group_id := fnd_profile.VALUE('PER_BUSINESS_GROUP_ID');
241: g_effective_date :=
242: fnd_date.canonical_to_date(get_parameter_value('EFFECTIVE DATE'
243: ,g_parameter_list
244: )
245: );
246: g_payroll_id :=

Line 285: || RPAD(NVL(fnd_date.date_to_displaydate(p_output_file_record.effective_date

281: ,30
282: ,' '
283: )
284: || g_column_separator
285: || RPAD(NVL(fnd_date.date_to_displaydate(p_output_file_record.effective_date
286: )
287: ,' '
288: )
289: ,15

Line 1100: fnd_date.date_to_canonical(p_effective_date);

1096: l_inputs(i).VALUE := p_assignment_id;
1097: ELSIF l_inputs(i).NAME = 'DATE_EARNED'
1098: THEN
1099: l_inputs(i).VALUE :=
1100: fnd_date.date_to_canonical(p_effective_date);
1101: END IF;
1102:
1103: IF g_debug
1104: THEN

Line 1364: || fnd_date.date_to_displaydate(l_effective_date)

1360: , RPAD('Contract', 30) || ': ' || l_contract);
1361: fnd_file.put_line(fnd_file.LOG
1362: , RPAD('Effective Date', 30)
1363: || ': '
1364: || fnd_date.date_to_displaydate(l_effective_date)
1365: );
1366: l_proc_step := 20;
1367:
1368: -- Loop through effective assignments for this person

Line 1774: fnd_date.date_to_displaydate(p_effective_date)

1770: END IF;
1771: CLOSE csr_min_aat_start_date;
1772: hr_utility.set_message(8303, 'PQP_230113_AAT_MISSING_CONTRCT');
1773: hr_utility.set_message_token('EFFECTIVEDATE',
1774: fnd_date.date_to_displaydate(p_effective_date)
1775: );
1776: hr_utility.raise_error;
1777: END IF;
1778: CLOSE csr_min_aat_start_date;

Line 1794: fnd_date.date_to_displaydate(p_effective_date)

1790: END IF;
1791: CLOSE csr_min_asg_start_date;
1792: hr_utility.set_message(8303, 'PQP_230456_FTE_NO_ASG_DETAILS');
1793: hr_utility.set_message_token('EFFECTIVEDATE',
1794: fnd_date.date_to_displaydate(p_effective_date)
1795: );
1796: hr_utility.raise_error;
1797: END IF;
1798: CLOSE csr_min_asg_start_date;

Line 1814: || fnd_date.date_to_canonical(l_earliest_effective_date)

1810: IF g_debug
1811: THEN
1812: debug(l_proc_name,l_proc_step);
1813: debug( 'l_earliest_effective_date:'
1814: || fnd_date.date_to_canonical(l_earliest_effective_date)
1815: );
1816: debug_exit(l_proc_name);
1817: END IF;
1818:

Line 1992: || fnd_date.date_to_displaydate(p_effective_date

1988: );
1989: fnd_file.put_line(fnd_file.LOG
1990: , RPAD('Effective Date', 30, ' ')
1991: || ': '
1992: || fnd_date.date_to_displaydate(p_effective_date
1993: )
1994: );
1995: END IF;
1996:

Line 3001: ,fnd_date.date_to_displaydate(p_effective_date

2997: debug(l_proc_name, l_proc_step);
2998: END IF;
2999: hr_utility.set_message(8303, 'PQP_230113_AAT_MISSING_CONTRCT');
3000: hr_utility.set_message_token('EFFECTIVEDATE'
3001: ,fnd_date.date_to_displaydate(p_effective_date
3002: )
3003: );
3004: hr_utility.raise_error;
3005: END IF;

Line 3033: || fnd_date.date_to_canonical(p_effective_date)

3029: IF g_debug
3030: THEN
3031: debug(l_proc_name, l_proc_step);
3032: debug( 'p_effective_date:'
3033: || fnd_date.date_to_canonical(p_effective_date)
3034: );
3035: debug('l_pqp_contract_table_id:' || l_pqp_contract_table_id);
3036: debug( 'l_assignment_contract.user_row_id:'
3037: || l_assignment_contract.user_row_id

Line 3175: fnd_date.date_to_canonical(p_effective_date);

3171: l_inputs(l_in_cnt).VALUE := p_assignment_id;
3172: ELSIF(l_inputs(l_in_cnt).NAME = 'DATE_EARNED')
3173: THEN
3174: l_inputs(l_in_cnt).VALUE :=
3175: fnd_date.date_to_canonical(p_effective_date);
3176: ELSIF(l_inputs(l_in_cnt).NAME = 'BUSINESS_GROUP_ID')
3177: THEN
3178: l_inputs(l_in_cnt).VALUE := p_business_group_id;
3179: END IF;

Line 3480: || fnd_date.date_to_canonical(l_effective_abv_row.effective_start_date

3476: debug( 'l_effective_abv_row.object_version_number:'
3477: || l_effective_abv_row.object_version_number
3478: );
3479: debug( 'l_effective_abv_row.effective_start_date:'
3480: || fnd_date.date_to_canonical(l_effective_abv_row.effective_start_date
3481: )
3482: );
3483: debug( 'l_effective_abv_row.effective_end_date:'
3484: || fnd_date.date_to_canonical(l_effective_abv_row.effective_end_date

Line 3484: || fnd_date.date_to_canonical(l_effective_abv_row.effective_end_date

3480: || fnd_date.date_to_canonical(l_effective_abv_row.effective_start_date
3481: )
3482: );
3483: debug( 'l_effective_abv_row.effective_end_date:'
3484: || fnd_date.date_to_canonical(l_effective_abv_row.effective_end_date
3485: )
3486: );
3487: debug('l_effective_abv_row.value:' || l_effective_abv_row.VALUE);
3488: END IF;

Line 3710: || fnd_date.date_to_canonical(l_effective_abv_row.effective_start_date

3706: debug( 'l_effective_abv_row.object_version_number:'
3707: || l_effective_abv_row.object_version_number
3708: );
3709: debug( 'l_effective_abv_row.effective_start_date:'
3710: || fnd_date.date_to_canonical(l_effective_abv_row.effective_start_date
3711: )
3712: );
3713: debug( 'l_effective_abv_row.effective_end_date:'
3714: || fnd_date.date_to_canonical(l_effective_abv_row.effective_end_date

Line 3714: || fnd_date.date_to_canonical(l_effective_abv_row.effective_end_date

3710: || fnd_date.date_to_canonical(l_effective_abv_row.effective_start_date
3711: )
3712: );
3713: debug( 'l_effective_abv_row.effective_end_date:'
3714: || fnd_date.date_to_canonical(l_effective_abv_row.effective_end_date
3715: )
3716: );
3717: debug('l_effective_abv_row.value:' || l_effective_abv_row.VALUE);
3718: debug('ROUND(p_abv_value,5):' || ROUND(p_abv_value, 5));