APPS.IGS_RE_VAL_MIL dependencies on IGS_PR_MILESTONE_TYP

Line 18: -- for a candidate, where the IGS_PR_MILESTONE type and due date are the same.

14: p_message_name OUT NOCOPY VARCHAR2 )
15: RETURN BOOLEAN AS
16: BEGIN -- resp_val_mil_uniq
17: -- Validate that there are no ?logically? duplicate IGS_PR_MILESTONE records
18: -- for a candidate, where the IGS_PR_MILESTONE type and due date are the same.
19: DECLARE
20: v_return_false BOOLEAN;
21: CURSOR c_mil IS
22: SELECT count('x') duplicate_cnt

Line 238: FROM IGS_PR_MILESTONE_TYP mty

234: v_mty_nrrd IGS_PR_MILESTONE.ovrd_ntfctn_re_reminder_days%TYPE;
235: CURSOR c_mty IS
236: SELECT mty.ntfctn_re_reminder_days,
237: mty.ntfctn_reminder_days
238: FROM IGS_PR_MILESTONE_TYP mty
239: WHERE mty.milestone_type = p_milestone_type;
240: BEGIN
241: -- Set the default message number
242: p_message_name := null;

Line 454: -- To validate IGS_PR_MILESTONE type

450: IGS_GE_MSG_STACK.ADD;
451: App_Exception.Raise_Exception;
452: END resp_val_mil_mst;
453: --
454: -- To validate IGS_PR_MILESTONE type
455: FUNCTION RESP_VAL_MIL_MTY(
456: p_milestone_type IN VARCHAR2 ,
457: p_message_name OUT NOCOPY VARCHAR2 )
458: RETURN BOOLEAN AS

Line 460: -- Validate the IGS_PR_MILESTONE type, checking for :

456: p_milestone_type IN VARCHAR2 ,
457: p_message_name OUT NOCOPY VARCHAR2 )
458: RETURN BOOLEAN AS
459: BEGIN -- resp_val_mil_mty
460: -- Validate the IGS_PR_MILESTONE type, checking for :
461: -- That the IGS_PR_MILESTONE type is not closed.
462: DECLARE
463: CURSOR c_mty IS
464: SELECT 'x'

Line 461: -- That the IGS_PR_MILESTONE type is not closed.

457: p_message_name OUT NOCOPY VARCHAR2 )
458: RETURN BOOLEAN AS
459: BEGIN -- resp_val_mil_mty
460: -- Validate the IGS_PR_MILESTONE type, checking for :
461: -- That the IGS_PR_MILESTONE type is not closed.
462: DECLARE
463: CURSOR c_mty IS
464: SELECT 'x'
465: FROM IGS_PR_MILESTONE_TYP mty

Line 465: FROM IGS_PR_MILESTONE_TYP mty

461: -- That the IGS_PR_MILESTONE type is not closed.
462: DECLARE
463: CURSOR c_mty IS
464: SELECT 'x'
465: FROM IGS_PR_MILESTONE_TYP mty
466: WHERE mty.milestone_type = p_milestone_type AND
467: mty.closed_ind = 'Y';
468: v_mty_exists VARCHAR2(1);
469: BEGIN

Line 472: -- check for closed IGS_PR_MILESTONE type

468: v_mty_exists VARCHAR2(1);
469: BEGIN
470: -- Set the default message number
471: p_message_name := null;
472: -- check for closed IGS_PR_MILESTONE type
473: OPEN c_mty;
474: FETCH c_mty INTO v_mty_exists;
475: IF c_mty%FOUND THEN
476: CLOSE c_mty;