DBA Data[Home] [Help]

APPS.GMD_SUBSTITUTION_PUB dependencies on FND_DATE

Line 1007: FND_DATE.canonical_to_date(p_update_table(i).p_value);

1003: -- Start date should be less than End date
1004: -- Convert the date from canonical format
1005: IF (Upper(p_update_table(i).p_col_to_update) = 'START_DATE') THEN
1006: l_substitution_hdr_rec.start_date :=
1007: FND_DATE.canonical_to_date(p_update_table(i).p_value);
1008: IF (l_substitution_hdr_rec.end_date IS NOT NULL) THEN
1009: IF (l_substitution_hdr_rec.end_date < l_substitution_hdr_rec.start_date) THEN
1010: FND_MESSAGE.SET_NAME('GMD', 'QC_MIN_MAX_DATE');
1011: FND_MSG_PUB.ADD;

Line 1027: FND_DATE.canonical_to_date(p_update_table(i).p_value);

1023: END IF;
1024: l_substitution_hdr_rec.preference := p_update_table(i).p_value;
1025: ELSIF (Upper(p_update_table(i).p_col_to_update) = 'END_DATE') THEN
1026: l_substitution_hdr_rec.end_date :=
1027: FND_DATE.canonical_to_date(p_update_table(i).p_value);
1028: IF (p_update_table(i).p_value IS NOT NULL) THEN
1029: IF (l_substitution_hdr_rec.start_date > l_substitution_hdr_rec.end_date) THEN
1030: FND_MESSAGE.SET_NAME('GMD', 'QC_MIN_MAX_DATE');
1031: FND_MSG_PUB.ADD;