eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_VALIDATE_QUALIFIERS dependencies on FND_DATE

Line 627: IF fnd_date.canonical_to_date(p_QUALIFIERS_rec.qualifier_attr_value_to) <

623: --dbms_output.put_line('for context ,attribute,value,datatype,precedence');
624:
625: if (p_QUALIFIERS_rec.qualifier_datatype = 'X' and p_QUALIFIERS_rec.comparison_operator_code = 'BETWEEN' ) THEN
626:
627: IF fnd_date.canonical_to_date(p_QUALIFIERS_rec.qualifier_attr_value_to) <
628: fnd_date.canonical_to_date(p_QUALIFIERS_rec.qualifier_attr_value)
629: THEN
630:
631: l_return_status := FND_API.G_RET_STS_ERROR;

Line 628: fnd_date.canonical_to_date(p_QUALIFIERS_rec.qualifier_attr_value)

624:
625: if (p_QUALIFIERS_rec.qualifier_datatype = 'X' and p_QUALIFIERS_rec.comparison_operator_code = 'BETWEEN' ) THEN
626:
627: IF fnd_date.canonical_to_date(p_QUALIFIERS_rec.qualifier_attr_value_to) <
628: fnd_date.canonical_to_date(p_QUALIFIERS_rec.qualifier_attr_value)
629: THEN
630:
631: l_return_status := FND_API.G_RET_STS_ERROR;
632:

Line 1012: , p_param2 => fnd_date.date_to_canonical(l_start_date_active) --2752265

1008: , p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL
1009: , p_requesting_entity_id => p_qualifiers_rec.list_line_id
1010: , p_request_type => QP_GLOBALS.G_DUPLICATE_MODIFIER_LINES
1011: , p_param1 => l_list_header_id_1
1012: , p_param2 => fnd_date.date_to_canonical(l_start_date_active) --2752265
1013: , p_param3 => fnd_date.date_to_canonical(l_end_date_active) --2752265
1014: , p_param4 => NULL
1015: , p_param5 => NULL
1016: , p_param6 => NULL

Line 1013: , p_param3 => fnd_date.date_to_canonical(l_end_date_active) --2752265

1009: , p_requesting_entity_id => p_qualifiers_rec.list_line_id
1010: , p_request_type => QP_GLOBALS.G_DUPLICATE_MODIFIER_LINES
1011: , p_param1 => l_list_header_id_1
1012: , p_param2 => fnd_date.date_to_canonical(l_start_date_active) --2752265
1013: , p_param3 => fnd_date.date_to_canonical(l_end_date_active) --2752265
1014: , p_param4 => NULL
1015: , p_param5 => NULL
1016: , p_param6 => NULL
1017: , x_return_status => l_return_status

Line 1043: , p_param2 => fnd_date.date_to_canonical(l_start_date_active) --2752265

1039: , p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL
1040: , p_requesting_entity_id => p_qualifiers_rec.list_line_id
1041: , p_request_type => QP_GLOBALS.G_DUPLICATE_MODIFIER_LINES
1042: , p_param1 => l_list_header_id_1
1043: , p_param2 => fnd_date.date_to_canonical(l_start_date_active) --2752265
1044: , p_param3 => fnd_date.date_to_canonical(l_end_date_active) --2752265
1045: , p_param4 => p_product_attribute_context
1046: , p_param5 => p_product_attribute
1047: , p_param6 => p_product_attr_value

Line 1044: , p_param3 => fnd_date.date_to_canonical(l_end_date_active) --2752265

1040: , p_requesting_entity_id => p_qualifiers_rec.list_line_id
1041: , p_request_type => QP_GLOBALS.G_DUPLICATE_MODIFIER_LINES
1042: , p_param1 => l_list_header_id_1
1043: , p_param2 => fnd_date.date_to_canonical(l_start_date_active) --2752265
1044: , p_param3 => fnd_date.date_to_canonical(l_end_date_active) --2752265
1045: , p_param4 => p_product_attribute_context
1046: , p_param5 => p_product_attribute
1047: , p_param6 => p_product_attr_value
1048: , x_return_status => l_return_status