616: BEGIN
617:
618: --========= Setting global variables==============--------------
619: v_current_date := SYSDATE ;
620: v_current_user := FND_GLOBAL.USER_ID ;
621: v_login_user := FND_GLOBAL.CONC_LOGIN_ID;
622: v_request_id := FND_GLOBAL.CONC_REQUEST_ID;
623: v_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
624: v_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
617:
618: --========= Setting global variables==============--------------
619: v_current_date := SYSDATE ;
620: v_current_user := FND_GLOBAL.USER_ID ;
621: v_login_user := FND_GLOBAL.CONC_LOGIN_ID;
622: v_request_id := FND_GLOBAL.CONC_REQUEST_ID;
623: v_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
624: v_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
625:
618: --========= Setting global variables==============--------------
619: v_current_date := SYSDATE ;
620: v_current_user := FND_GLOBAL.USER_ID ;
621: v_login_user := FND_GLOBAL.CONC_LOGIN_ID;
622: v_request_id := FND_GLOBAL.CONC_REQUEST_ID;
623: v_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
624: v_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
625:
626: v_instance_id := p_instance_id;
619: v_current_date := SYSDATE ;
620: v_current_user := FND_GLOBAL.USER_ID ;
621: v_login_user := FND_GLOBAL.CONC_LOGIN_ID;
622: v_request_id := FND_GLOBAL.CONC_REQUEST_ID;
623: v_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
624: v_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
625:
626: v_instance_id := p_instance_id;
627: v_date := fnd_date.canonical_to_date(p_date);
620: v_current_user := FND_GLOBAL.USER_ID ;
621: v_login_user := FND_GLOBAL.CONC_LOGIN_ID;
622: v_request_id := FND_GLOBAL.CONC_REQUEST_ID;
623: v_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
624: v_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
625:
626: v_instance_id := p_instance_id;
627: v_date := fnd_date.canonical_to_date(p_date);
628: lv_retval := FND_INSTALLATION.GET_APP_INFO(