APPS.IGS_AD_SS_GEN_001 dependencies on IGS_GE_DATE

Line 3424: P_FINAL_STRING := IGS_GE_DATE.IGSCHAR(P_START_DATE) || ' - ' ||

3420: P_FINAL_STRING VARCHAR2(2000);
3421: BEGIN
3422:
3423: IF P_START_DATE IS NOT NULL AND P_END_DATE IS NOT NULL THEN
3424: P_FINAL_STRING := IGS_GE_DATE.IGSCHAR(P_START_DATE) || ' - ' ||
3425: IGS_GE_DATE.IGSCHAR(P_END_DATE);
3426: END IF;
3427:
3428: IF P_START_DATE IS NULL AND P_END_DATE IS NULL THEN

Line 3425: IGS_GE_DATE.IGSCHAR(P_END_DATE);

3421: BEGIN
3422:
3423: IF P_START_DATE IS NOT NULL AND P_END_DATE IS NOT NULL THEN
3424: P_FINAL_STRING := IGS_GE_DATE.IGSCHAR(P_START_DATE) || ' - ' ||
3425: IGS_GE_DATE.IGSCHAR(P_END_DATE);
3426: END IF;
3427:
3428: IF P_START_DATE IS NULL AND P_END_DATE IS NULL THEN
3429: IF P_COMP_DATE IS NULL THEN

Line 3432: P_FINAL_STRING := ' - ' || IGS_GE_DATE.IGSCHAR(P_COMP_DATE);

3428: IF P_START_DATE IS NULL AND P_END_DATE IS NULL THEN
3429: IF P_COMP_DATE IS NULL THEN
3430: P_FINAL_STRING := ' - ';
3431: ELSE
3432: P_FINAL_STRING := ' - ' || IGS_GE_DATE.IGSCHAR(P_COMP_DATE);
3433: END IF;
3434: END IF;
3435:
3436: IF P_START_DATE IS NULL AND P_END_DATE IS NOT NULL THEN

Line 3437: P_FINAL_STRING := ' - ' || IGS_GE_DATE.IGSCHAR(P_END_DATE);

3433: END IF;
3434: END IF;
3435:
3436: IF P_START_DATE IS NULL AND P_END_DATE IS NOT NULL THEN
3437: P_FINAL_STRING := ' - ' || IGS_GE_DATE.IGSCHAR(P_END_DATE);
3438: END IF;
3439:
3440: IF P_START_DATE IS NOT NULL AND P_END_DATE IS NULL THEN
3441: IF P_COMP_DATE IS NULL THEN

Line 3442: P_FINAL_STRING := IGS_GE_DATE.IGSCHAR(P_START_DATE) || ' - ';

3438: END IF;
3439:
3440: IF P_START_DATE IS NOT NULL AND P_END_DATE IS NULL THEN
3441: IF P_COMP_DATE IS NULL THEN
3442: P_FINAL_STRING := IGS_GE_DATE.IGSCHAR(P_START_DATE) || ' - ';
3443: ELSE
3444: P_FINAL_STRING := IGS_GE_DATE.IGSCHAR(P_START_DATE) || ' - ' ||
3445: IGS_GE_DATE.IGSCHAR(P_COMP_DATE);
3446: END IF;

Line 3444: P_FINAL_STRING := IGS_GE_DATE.IGSCHAR(P_START_DATE) || ' - ' ||

3440: IF P_START_DATE IS NOT NULL AND P_END_DATE IS NULL THEN
3441: IF P_COMP_DATE IS NULL THEN
3442: P_FINAL_STRING := IGS_GE_DATE.IGSCHAR(P_START_DATE) || ' - ';
3443: ELSE
3444: P_FINAL_STRING := IGS_GE_DATE.IGSCHAR(P_START_DATE) || ' - ' ||
3445: IGS_GE_DATE.IGSCHAR(P_COMP_DATE);
3446: END IF;
3447: END IF;
3448:

Line 3445: IGS_GE_DATE.IGSCHAR(P_COMP_DATE);

3441: IF P_COMP_DATE IS NULL THEN
3442: P_FINAL_STRING := IGS_GE_DATE.IGSCHAR(P_START_DATE) || ' - ';
3443: ELSE
3444: P_FINAL_STRING := IGS_GE_DATE.IGSCHAR(P_START_DATE) || ' - ' ||
3445: IGS_GE_DATE.IGSCHAR(P_COMP_DATE);
3446: END IF;
3447: END IF;
3448:
3449: RETURN P_FINAL_STRING;