512:
513: FUNCTION created_by RETURN NUMBER IS
514: BEGIN
515:
516: RETURN NVL(FND_GLOBAL.user_id,-1);
517:
518: END created_by;
519:
520: FUNCTION creation_date RETURN DATE IS
526:
527: FUNCTION last_updated_by RETURN NUMBER IS
528: BEGIN
529:
530: RETURN NVL(FND_GLOBAL.user_id,-1);
531:
532: END last_updated_by;
533:
534: FUNCTION last_update_date RETURN DATE IS
540:
541: FUNCTION last_update_login RETURN NUMBER IS
542: BEGIN
543:
544: IF FND_GLOBAL.conc_login_id = -1 OR
545: FND_GLOBAL.conc_login_id IS NULL
546: THEN
547: RETURN FND_GLOBAL.login_id;
548: ELSE
541: FUNCTION last_update_login RETURN NUMBER IS
542: BEGIN
543:
544: IF FND_GLOBAL.conc_login_id = -1 OR
545: FND_GLOBAL.conc_login_id IS NULL
546: THEN
547: RETURN FND_GLOBAL.login_id;
548: ELSE
549: RETURN FND_GLOBAL.conc_login_id;
543:
544: IF FND_GLOBAL.conc_login_id = -1 OR
545: FND_GLOBAL.conc_login_id IS NULL
546: THEN
547: RETURN FND_GLOBAL.login_id;
548: ELSE
549: RETURN FND_GLOBAL.conc_login_id;
550: END IF;
551:
545: FND_GLOBAL.conc_login_id IS NULL
546: THEN
547: RETURN FND_GLOBAL.login_id;
548: ELSE
549: RETURN FND_GLOBAL.conc_login_id;
550: END IF;
551:
552: END last_update_login;
553:
553:
554: FUNCTION request_id RETURN NUMBER IS
555: BEGIN
556:
557: IF FND_GLOBAL.conc_request_id = -1 OR
558: FND_GLOBAL.conc_request_id IS NULL
559: THEN
560: RETURN NULL;
561: ELSE
554: FUNCTION request_id RETURN NUMBER IS
555: BEGIN
556:
557: IF FND_GLOBAL.conc_request_id = -1 OR
558: FND_GLOBAL.conc_request_id IS NULL
559: THEN
560: RETURN NULL;
561: ELSE
562: RETURN FND_GLOBAL.conc_request_id;
558: FND_GLOBAL.conc_request_id IS NULL
559: THEN
560: RETURN NULL;
561: ELSE
562: RETURN FND_GLOBAL.conc_request_id;
563: END IF;
564:
565: END request_id;
566:
566:
567: FUNCTION program_id RETURN NUMBER IS
568: BEGIN
569:
570: IF FND_GLOBAL.conc_program_id = -1 OR
571: FND_GLOBAL.conc_program_id IS NULL
572: THEN
573: RETURN NULL;
574: ELSE
567: FUNCTION program_id RETURN NUMBER IS
568: BEGIN
569:
570: IF FND_GLOBAL.conc_program_id = -1 OR
571: FND_GLOBAL.conc_program_id IS NULL
572: THEN
573: RETURN NULL;
574: ELSE
575: RETURN FND_GLOBAL.conc_program_id;
571: FND_GLOBAL.conc_program_id IS NULL
572: THEN
573: RETURN NULL;
574: ELSE
575: RETURN FND_GLOBAL.conc_program_id;
576: END IF;
577:
578: END program_id;
579:
579:
580: FUNCTION program_application_id RETURN NUMBER IS
581: BEGIN
582:
583: IF FND_GLOBAL.prog_appl_id = -1 OR
584: FND_GLOBAL.prog_appl_id IS NULL
585: THEN
586: RETURN NULL;
587: ELSE
580: FUNCTION program_application_id RETURN NUMBER IS
581: BEGIN
582:
583: IF FND_GLOBAL.prog_appl_id = -1 OR
584: FND_GLOBAL.prog_appl_id IS NULL
585: THEN
586: RETURN NULL;
587: ELSE
588: RETURN FND_GLOBAL.prog_appl_id;
584: FND_GLOBAL.prog_appl_id IS NULL
585: THEN
586: RETURN NULL;
587: ELSE
588: RETURN FND_GLOBAL.prog_appl_id;
589: END IF;
590:
591: END program_application_id;
592:
592:
593: FUNCTION application_id RETURN NUMBER IS
594: BEGIN
595:
596: IF FND_GLOBAL.resp_appl_id = -1 OR
597: FND_GLOBAL.resp_appl_id IS NULL
598: THEN
599: RETURN NULL;
600: ELSE
593: FUNCTION application_id RETURN NUMBER IS
594: BEGIN
595:
596: IF FND_GLOBAL.resp_appl_id = -1 OR
597: FND_GLOBAL.resp_appl_id IS NULL
598: THEN
599: RETURN NULL;
600: ELSE
601: RETURN FND_GLOBAL.resp_appl_id;
597: FND_GLOBAL.resp_appl_id IS NULL
598: THEN
599: RETURN NULL;
600: ELSE
601: RETURN FND_GLOBAL.resp_appl_id;
602: END IF;
603:
604: END application_id;
605:
616:
617: FUNCTION user_id RETURN NUMBER IS
618: BEGIN
619:
620: RETURN NVL(FND_GLOBAL.user_id,-1);
621:
622: END user_id;
623:
624: FUNCTION Get_SchemaName (