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 1111: fnd_date.date_to_canonical(p_effective_date);

1107: l_inputs(i).VALUE := p_assignment_id;
1108: ELSIF l_inputs(i).NAME = 'DATE_EARNED'
1109: THEN
1110: l_inputs(i).VALUE :=
1111: fnd_date.date_to_canonical(p_effective_date);
1112: END IF;
1113:
1114: IF g_debug
1115: THEN

Line 1376: || fnd_date.date_to_displaydate(l_effective_date)

1372: , RPAD('Contract', 30) || ': ' || l_contract);
1373: fnd_file.put_line(fnd_file.LOG
1374: , RPAD('Effective Date', 30)
1375: || ': '
1376: || fnd_date.date_to_displaydate(l_effective_date)
1377: );
1378: l_proc_step := 20;
1379:
1380: -- Loop through effective assignments for this person

Line 1786: fnd_date.date_to_displaydate(p_effective_date)

1782: END IF;
1783: CLOSE csr_min_aat_start_date;
1784: hr_utility.set_message(8303, 'PQP_230113_AAT_MISSING_CONTRCT');
1785: hr_utility.set_message_token('EFFECTIVEDATE',
1786: fnd_date.date_to_displaydate(p_effective_date)
1787: );
1788: hr_utility.raise_error;
1789: END IF;
1790: CLOSE csr_min_aat_start_date;

Line 1806: fnd_date.date_to_displaydate(p_effective_date)

1802: END IF;
1803: CLOSE csr_min_asg_start_date;
1804: hr_utility.set_message(8303, 'PQP_230456_FTE_NO_ASG_DETAILS');
1805: hr_utility.set_message_token('EFFECTIVEDATE',
1806: fnd_date.date_to_displaydate(p_effective_date)
1807: );
1808: hr_utility.raise_error;
1809: END IF;
1810: CLOSE csr_min_asg_start_date;

Line 1826: || fnd_date.date_to_canonical(l_earliest_effective_date)

1822: IF g_debug
1823: THEN
1824: debug(l_proc_name,l_proc_step);
1825: debug( 'l_earliest_effective_date:'
1826: || fnd_date.date_to_canonical(l_earliest_effective_date)
1827: );
1828: debug_exit(l_proc_name);
1829: END IF;
1830:

Line 2015: || fnd_date.date_to_displaydate(p_effective_date

2011: );
2012: fnd_file.put_line(fnd_file.LOG
2013: , RPAD('Effective Date', 30, ' ')
2014: || ': '
2015: || fnd_date.date_to_displaydate(p_effective_date
2016: )
2017: );
2018: END IF;
2019:

Line 3043: ,fnd_date.date_to_displaydate(p_effective_date

3039: debug(l_proc_name, l_proc_step);
3040: END IF;
3041: hr_utility.set_message(8303, 'PQP_230113_AAT_MISSING_CONTRCT');
3042: hr_utility.set_message_token('EFFECTIVEDATE'
3043: ,fnd_date.date_to_displaydate(p_effective_date
3044: )
3045: );
3046: hr_utility.raise_error;
3047: END IF;

Line 3075: || fnd_date.date_to_canonical(p_effective_date)

3071: IF g_debug
3072: THEN
3073: debug(l_proc_name, l_proc_step);
3074: debug( 'p_effective_date:'
3075: || fnd_date.date_to_canonical(p_effective_date)
3076: );
3077: debug('l_pqp_contract_table_id:' || l_pqp_contract_table_id);
3078: debug( 'l_assignment_contract.user_row_id:'
3079: || l_assignment_contract.user_row_id

Line 3217: fnd_date.date_to_canonical(p_effective_date);

3213: l_inputs(l_in_cnt).VALUE := p_assignment_id;
3214: ELSIF(l_inputs(l_in_cnt).NAME = 'DATE_EARNED')
3215: THEN
3216: l_inputs(l_in_cnt).VALUE :=
3217: fnd_date.date_to_canonical(p_effective_date);
3218: ELSIF(l_inputs(l_in_cnt).NAME = 'BUSINESS_GROUP_ID')
3219: THEN
3220: l_inputs(l_in_cnt).VALUE := p_business_group_id;
3221: END IF;

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

3518: debug( 'l_effective_abv_row.object_version_number:'
3519: || l_effective_abv_row.object_version_number
3520: );
3521: debug( 'l_effective_abv_row.effective_start_date:'
3522: || fnd_date.date_to_canonical(l_effective_abv_row.effective_start_date
3523: )
3524: );
3525: debug( 'l_effective_abv_row.effective_end_date:'
3526: || fnd_date.date_to_canonical(l_effective_abv_row.effective_end_date

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

3522: || fnd_date.date_to_canonical(l_effective_abv_row.effective_start_date
3523: )
3524: );
3525: debug( 'l_effective_abv_row.effective_end_date:'
3526: || fnd_date.date_to_canonical(l_effective_abv_row.effective_end_date
3527: )
3528: );
3529: debug('l_effective_abv_row.value:' || l_effective_abv_row.VALUE);
3530: END IF;

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

3748: debug( 'l_effective_abv_row.object_version_number:'
3749: || l_effective_abv_row.object_version_number
3750: );
3751: debug( 'l_effective_abv_row.effective_start_date:'
3752: || fnd_date.date_to_canonical(l_effective_abv_row.effective_start_date
3753: )
3754: );
3755: debug( 'l_effective_abv_row.effective_end_date:'
3756: || fnd_date.date_to_canonical(l_effective_abv_row.effective_end_date

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

3752: || fnd_date.date_to_canonical(l_effective_abv_row.effective_start_date
3753: )
3754: );
3755: debug( 'l_effective_abv_row.effective_end_date:'
3756: || fnd_date.date_to_canonical(l_effective_abv_row.effective_end_date
3757: )
3758: );
3759: debug('l_effective_abv_row.value:' || l_effective_abv_row.VALUE);
3760: debug('ROUND(p_abv_value,5):' || ROUND(p_abv_value, 5));