DBA Data[Home] [Help]

APPS.GMD_SEARCH_REPLACE_VERS dependencies on FND_DATE

Line 91: NVL( FND_DATE.canonical_to_date(p_effective_start_date) ,X_hdr_rec.effective_start_date ),

87: -- and also validates the dates with operation dates.
88:
89: -- Bug# 5493773 Removed NVL for the end date as the end date can be NULL
90: l_ret := GMD_ROUTINGS_PVT.Validate_dates(p_routing_id,
91: NVL( FND_DATE.canonical_to_date(p_effective_start_date) ,X_hdr_rec.effective_start_date ),
92: FND_DATE.canonical_to_date(p_effective_end_date) );
93:
94: IF l_ret < 0 THEN
95: RAISE VALIDATION_FAILURE ;

Line 92: FND_DATE.canonical_to_date(p_effective_end_date) );

88:
89: -- Bug# 5493773 Removed NVL for the end date as the end date can be NULL
90: l_ret := GMD_ROUTINGS_PVT.Validate_dates(p_routing_id,
91: NVL( FND_DATE.canonical_to_date(p_effective_start_date) ,X_hdr_rec.effective_start_date ),
92: FND_DATE.canonical_to_date(p_effective_end_date) );
93:
94: IF l_ret < 0 THEN
95: RAISE VALIDATION_FAILURE ;
96: END IF;

Line 170: X_EFFECTIVE_START_DATE => NVL( FND_DATE.canonical_to_date(p_effective_start_date) ,X_hdr_rec.effective_start_date ),

166: X_ATTRIBUTE28 => x_hdr_rec.ATTRIBUTE28,
167: X_ATTRIBUTE29 => x_hdr_rec.ATTRIBUTE29,
168: X_ATTRIBUTE30 => x_hdr_rec.ATTRIBUTE30,
169: X_ATTRIBUTE_CATEGORY => x_hdr_rec.ATTRIBUTE_CATEGORY,
170: X_EFFECTIVE_START_DATE => NVL( FND_DATE.canonical_to_date(p_effective_start_date) ,X_hdr_rec.effective_start_date ),
171: X_EFFECTIVE_END_DATE => NVL(FND_DATE.canonical_to_date (p_effective_end_date) ,X_hdr_rec.effective_end_date ),
172: X_OWNER_ID => NVL(p_owner,X_hdr_rec.owner_id),
173: X_PROJECT_ID => x_hdr_rec.PROJECT_ID,
174: X_PROCESS_LOSS => x_hdr_rec.PROCESS_LOSS,

Line 171: X_EFFECTIVE_END_DATE => NVL(FND_DATE.canonical_to_date (p_effective_end_date) ,X_hdr_rec.effective_end_date ),

167: X_ATTRIBUTE29 => x_hdr_rec.ATTRIBUTE29,
168: X_ATTRIBUTE30 => x_hdr_rec.ATTRIBUTE30,
169: X_ATTRIBUTE_CATEGORY => x_hdr_rec.ATTRIBUTE_CATEGORY,
170: X_EFFECTIVE_START_DATE => NVL( FND_DATE.canonical_to_date(p_effective_start_date) ,X_hdr_rec.effective_start_date ),
171: X_EFFECTIVE_END_DATE => NVL(FND_DATE.canonical_to_date (p_effective_end_date) ,X_hdr_rec.effective_end_date ),
172: X_OWNER_ID => NVL(p_owner,X_hdr_rec.owner_id),
173: X_PROJECT_ID => x_hdr_rec.PROJECT_ID,
174: X_PROCESS_LOSS => x_hdr_rec.PROCESS_LOSS,
175: X_ROUTING_STATUS => 100,

Line 399: X_EFFECTIVE_START_DATE => NVL(FND_DATE.canonical_to_date(p_effective_start_date) ,X_hdr_rec.effective_start_date ),

395: X_OPRN_VERS => X_oprn_vers,
396: X_PROCESS_QTY_UOM => x_hdr_rec.PROCESS_QTY_UOM,
397: X_OPRN_CLASS => NVL(p_operation_class,x_hdr_rec.oprn_class), -- 4116557
398: X_INACTIVE_IND => NVL(p_inactive_ind,0),
399: X_EFFECTIVE_START_DATE => NVL(FND_DATE.canonical_to_date(p_effective_start_date) ,X_hdr_rec.effective_start_date ),
400: X_EFFECTIVE_END_DATE => FND_DATE.canonical_to_date( p_effective_end_date ),
401: X_DELETE_MARK => 0,
402: X_TEXT_CODE => x_hdr_rec.TEXT_CODE,
403: X_ATTRIBUTE1 => x_hdr_rec.ATTRIBUTE1,

Line 400: X_EFFECTIVE_END_DATE => FND_DATE.canonical_to_date( p_effective_end_date ),

396: X_PROCESS_QTY_UOM => x_hdr_rec.PROCESS_QTY_UOM,
397: X_OPRN_CLASS => NVL(p_operation_class,x_hdr_rec.oprn_class), -- 4116557
398: X_INACTIVE_IND => NVL(p_inactive_ind,0),
399: X_EFFECTIVE_START_DATE => NVL(FND_DATE.canonical_to_date(p_effective_start_date) ,X_hdr_rec.effective_start_date ),
400: X_EFFECTIVE_END_DATE => FND_DATE.canonical_to_date( p_effective_end_date ),
401: X_DELETE_MARK => 0,
402: X_TEXT_CODE => x_hdr_rec.TEXT_CODE,
403: X_ATTRIBUTE1 => x_hdr_rec.ATTRIBUTE1,
404: X_ATTRIBUTE2 => x_hdr_rec.ATTRIBUTE2,