DBA Data[Home] [Help]

APPS.RCV_HXT_GRP dependencies on FND_DATE

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

1187: /*Converting into destination number format*/
1188: p_attributes.po_billable_amount := to_number(l_attribute_value, g_number_mask, 'NLS_NUMERIC_CHARACTERS='||nls_num_chars||'') ;
1189: -- Bug# 14492865 - End
1190: ELSIF l_attribute_name = 'PO RECEIPT DATE' THEN
1191: p_attributes.po_receipt_date := FND_DATE.Canonical_to_Date(p_attribute_value);
1192: ELSIF l_attribute_name = 'PROJECT_ID' THEN
1193: p_attributes.project_id := p_attribute_value;
1194: ELSIF l_attribute_name = 'TASK_ID' THEN
1195: p_attributes.task_id := p_attribute_value;

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

3404: p_attributes_rec.po_number := l_attributes.attribute1;
3405: p_attributes_rec.po_line_id := l_attributes.attribute2;
3406: p_attributes_rec.po_price_type := l_attributes.attribute3;
3407: p_attributes_rec.po_billable_amount := l_attributes.attribute4;
3408: p_attributes_rec.po_receipt_date := FND_DATE.canonical_to_date(l_attributes.attribute5);
3409: p_attributes_rec.po_line := l_attributes.attribute6;
3410: p_attributes_rec.po_price_type_display := l_attributes.attribute7;
3411: p_attributes_rec.po_header_id := l_attributes.attribute8;
3412: EXCEPTION

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

4263: l_attributes(att_idx).attribute_value := l_all_attributes(l_bb_id).po_price_type_display;
4264: ELSIF l_attributes(att_idx).attribute_name = 'PO Billable Amount' THEN
4265: l_attributes(att_idx).attribute_value := l_all_attributes(l_bb_id).po_billable_amount;
4266: ELSIF l_attributes(att_idx).attribute_name = 'PO Receipt Date' THEN
4267: l_attributes(att_idx).attribute_value := FND_DATE.date_to_canonical(l_all_attributes(l_bb_id).po_receipt_date);
4268: END IF;
4269: END LOOP;
4270:
4271: -- set time information

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

4679: || ', p_receipt_date=' || p_receipt_date
4680: );
4681:
4682: -- convert the date parameters
4683: l_start_date := FND_DATE.Canonical_To_Date(p_start_date);
4684: l_end_date := FND_DATE.Canonical_To_Date(p_end_date);
4685: l_receipt_date := FND_DATE.Canonical_To_Date(p_receipt_date);
4686:
4687: /* Bug 5713531 .Change made in where clause as po_headers and po_lines */

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

4680: );
4681:
4682: -- convert the date parameters
4683: l_start_date := FND_DATE.Canonical_To_Date(p_start_date);
4684: l_end_date := FND_DATE.Canonical_To_Date(p_end_date);
4685: l_receipt_date := FND_DATE.Canonical_To_Date(p_receipt_date);
4686:
4687: /* Bug 5713531 .Change made in where clause as po_headers and po_lines */
4688: -- add supplier name condition

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

4681:
4682: -- convert the date parameters
4683: l_start_date := FND_DATE.Canonical_To_Date(p_start_date);
4684: l_end_date := FND_DATE.Canonical_To_Date(p_end_date);
4685: l_receipt_date := FND_DATE.Canonical_To_Date(p_receipt_date);
4686:
4687: /* Bug 5713531 .Change made in where clause as po_headers and po_lines */
4688: -- add supplier name condition
4689: -- bug 6031665 : corrected the syntax error. Previously the in condition was