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 727: IF fnd_date.canonical_to_date(p_QUALIFIERS_rec.qualifier_attr_value_to) <

723: --dbms_output.put_line('for context ,attribute,value,datatype,precedence');
724:
725: if (p_QUALIFIERS_rec.qualifier_datatype = 'X' and p_QUALIFIERS_rec.comparison_operator_code = 'BETWEEN' ) THEN
726:
727: IF fnd_date.canonical_to_date(p_QUALIFIERS_rec.qualifier_attr_value_to) <
728: fnd_date.canonical_to_date(p_QUALIFIERS_rec.qualifier_attr_value)
729: THEN
730:
731: l_return_status := FND_API.G_RET_STS_ERROR;

Line 728: fnd_date.canonical_to_date(p_QUALIFIERS_rec.qualifier_attr_value)

724:
725: if (p_QUALIFIERS_rec.qualifier_datatype = 'X' and p_QUALIFIERS_rec.comparison_operator_code = 'BETWEEN' ) THEN
726:
727: IF fnd_date.canonical_to_date(p_QUALIFIERS_rec.qualifier_attr_value_to) <
728: fnd_date.canonical_to_date(p_QUALIFIERS_rec.qualifier_attr_value)
729: THEN
730:
731: l_return_status := FND_API.G_RET_STS_ERROR;
732:

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

1108: , p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL
1109: , p_requesting_entity_id => p_qualifiers_rec.list_line_id
1110: , p_request_type => QP_GLOBALS.G_DUPLICATE_MODIFIER_LINES
1111: , p_param1 => l_list_header_id_1
1112: , p_param2 => fnd_date.date_to_canonical(l_start_date_active) --2752265
1113: , p_param3 => fnd_date.date_to_canonical(l_end_date_active) --2752265
1114: , p_param4 => NULL
1115: , p_param5 => NULL
1116: , p_param6 => NULL

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

1109: , p_requesting_entity_id => p_qualifiers_rec.list_line_id
1110: , p_request_type => QP_GLOBALS.G_DUPLICATE_MODIFIER_LINES
1111: , p_param1 => l_list_header_id_1
1112: , p_param2 => fnd_date.date_to_canonical(l_start_date_active) --2752265
1113: , p_param3 => fnd_date.date_to_canonical(l_end_date_active) --2752265
1114: , p_param4 => NULL
1115: , p_param5 => NULL
1116: , p_param6 => NULL
1117: , x_return_status => l_return_status

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

1139: , p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL
1140: , p_requesting_entity_id => p_qualifiers_rec.list_line_id
1141: , p_request_type => QP_GLOBALS.G_DUPLICATE_MODIFIER_LINES
1142: , p_param1 => l_list_header_id_1
1143: , p_param2 => fnd_date.date_to_canonical(l_start_date_active) --2752265
1144: , p_param3 => fnd_date.date_to_canonical(l_end_date_active) --2752265
1145: , p_param4 => p_product_attribute_context
1146: , p_param5 => p_product_attribute
1147: , p_param6 => p_product_attr_value

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

1140: , p_requesting_entity_id => p_qualifiers_rec.list_line_id
1141: , p_request_type => QP_GLOBALS.G_DUPLICATE_MODIFIER_LINES
1142: , p_param1 => l_list_header_id_1
1143: , p_param2 => fnd_date.date_to_canonical(l_start_date_active) --2752265
1144: , p_param3 => fnd_date.date_to_canonical(l_end_date_active) --2752265
1145: , p_param4 => p_product_attribute_context
1146: , p_param5 => p_product_attribute
1147: , p_param6 => p_product_attr_value
1148: , x_return_status => l_return_status