DBA Data[Home] [Help]

APPS.RCV_HXT_GRP dependencies on FND_DATE

Line 1151: p_attributes.po_receipt_date := FND_DATE.Canonical_to_Date(p_attribute_value);

1147: p_attributes.po_price_type_display := p_attribute_value;
1148: ELSIF l_attribute_name = 'PO BILLABLE AMOUNT' THEN
1149: p_attributes.po_billable_amount := p_attribute_value;
1150: ELSIF l_attribute_name = 'PO RECEIPT DATE' THEN
1151: p_attributes.po_receipt_date := FND_DATE.Canonical_to_Date(p_attribute_value);
1152: ELSIF l_attribute_name = 'PROJECT_ID' THEN
1153: p_attributes.project_id := p_attribute_value;
1154: ELSIF l_attribute_name = 'TASK_ID' THEN
1155: p_attributes.task_id := p_attribute_value;

Line 3350: p_attributes_rec.po_receipt_date := FND_DATE.canonical_to_date(l_attributes.attribute5);

3346: p_attributes_rec.po_number := l_attributes.attribute1;
3347: p_attributes_rec.po_line_id := l_attributes.attribute2;
3348: p_attributes_rec.po_price_type := l_attributes.attribute3;
3349: p_attributes_rec.po_billable_amount := l_attributes.attribute4;
3350: p_attributes_rec.po_receipt_date := FND_DATE.canonical_to_date(l_attributes.attribute5);
3351: p_attributes_rec.po_line := l_attributes.attribute6;
3352: p_attributes_rec.po_price_type_display := l_attributes.attribute7;
3353: p_attributes_rec.po_header_id := l_attributes.attribute8;
3354: EXCEPTION

Line 4197: l_attributes(att_idx).attribute_value := FND_DATE.date_to_canonical(l_all_attributes(l_bb_id).po_receipt_date);

4193: l_attributes(att_idx).attribute_value := l_all_attributes(l_bb_id).po_price_type_display;
4194: ELSIF l_attributes(att_idx).attribute_name = 'PO Billable Amount' THEN
4195: l_attributes(att_idx).attribute_value := l_all_attributes(l_bb_id).po_billable_amount;
4196: ELSIF l_attributes(att_idx).attribute_name = 'PO Receipt Date' THEN
4197: l_attributes(att_idx).attribute_value := FND_DATE.date_to_canonical(l_all_attributes(l_bb_id).po_receipt_date);
4198: END IF;
4199: END LOOP;
4200:
4201: -- set time information

Line 4515: l_start_date := FND_DATE.Canonical_To_Date(p_start_date);

4511: || ', p_receipt_date=' || p_receipt_date
4512: );
4513:
4514: -- convert the date parameters
4515: l_start_date := FND_DATE.Canonical_To_Date(p_start_date);
4516: l_end_date := FND_DATE.Canonical_To_Date(p_end_date);
4517: l_receipt_date := FND_DATE.Canonical_To_Date(p_receipt_date);
4518:
4519: /* Bug 5713531 .Change made in where clause as po_headers and po_lines */

Line 4516: l_end_date := FND_DATE.Canonical_To_Date(p_end_date);

4512: );
4513:
4514: -- convert the date parameters
4515: l_start_date := FND_DATE.Canonical_To_Date(p_start_date);
4516: l_end_date := FND_DATE.Canonical_To_Date(p_end_date);
4517: l_receipt_date := FND_DATE.Canonical_To_Date(p_receipt_date);
4518:
4519: /* Bug 5713531 .Change made in where clause as po_headers and po_lines */
4520: -- add supplier name condition

Line 4517: l_receipt_date := FND_DATE.Canonical_To_Date(p_receipt_date);

4513:
4514: -- convert the date parameters
4515: l_start_date := FND_DATE.Canonical_To_Date(p_start_date);
4516: l_end_date := FND_DATE.Canonical_To_Date(p_end_date);
4517: l_receipt_date := FND_DATE.Canonical_To_Date(p_receipt_date);
4518:
4519: /* Bug 5713531 .Change made in where clause as po_headers and po_lines */
4520: -- add supplier name condition
4521: -- bug 6031665 : corrected the syntax error. Previously the in condition was